There have been a few instances recently where I have been asked to evaluate the sizes of user’s mailboxes in Exchange. The best way I have found to do this in a sortable list is by running the following command in the Exchange Management Shell:
Get-MailboxStatistics -Database “Mailbox DB Name Here” | Select DisplayName, ItemCount, {$_.TotalItemSize.Value.ToMB()} | Sort-Object TotalItemSize -Descending | Export-CSV C:MBSizes.csv
This command will go out to your exchange datastore and create a CSV file with the following information:
- User Display Name
- Mailbox Item Count
- Mailbox Size in MB.
The command runs very quickly and gives you a sortable list located at C:MBSizes.csv
Andy Shaffer, PEI
