Office365: What Is The Size Of Users Mailbox?

ExchangeMicrosoft CloudOffice 365
Misha Hanin -
December 3, 2016
1
Get-Mailbox | Get-MailboxStatistics | Select-Object DisplayName, @{name="TotalItemSize (GB)";expression={[math]::Round((($_.TotalItemSize.Value.ToString()).Split("(")[1].Split(" ")[0].Replace(",","")/1GB),2)}},ItemCount | Sort "TotalItemSize (GB)" -Descending

If we need to export the results into CSV file:

1
Get-Mailbox | Get-MailboxStatistics | Select-Object DisplayName, @{name="TotalItemSize (GB)";expression={[math]::Round((($_.TotalItemSize.Value.ToString()).Split("(")[1].Split(" ")[0].Replace(",","")/1GB),2)}},ItemCount | Sort "TotalItemSize (GB)" -Descending | Export-CSV C:\TMP\Office365-MailboxSize-Report.csv
#Exchange 2016Mailbox SizesOffice 365Office365PowerShell

No responses yet

Leave a Reply