Powershell - Exchange 2010 Mailbox Size Report

The following script will give you a report of all mailbox sizes in the Exchange Organization.

Get-MailboxStatistics -Database "Mailbox Database 1584415394" | Sort-Object TotalItemSize –Descending | ft @{label=”User”;expression={$_.DisplayName}},@{label=”Total Size (MB)”;expression={$_.TotalItemSize.Value.ToMB()}},@{label=”Items”;expression={$_.ItemCount}} | out-file C:\MailboxSizeReport.txt

Note the -Database paramenter, this might change and would be the name of the current database. Also notice the out-file section and the file location. This would be put on the root of the C: drive on the machine running the script.