Export mailbox sizes in Exchange 2010 using Exchange Management Shell

Thought I’d share two scripts today. I use both daily to export mailbox sizes to a csv file for reporting purposes.

These scripts will export the following:

User Display Name, Database where the mailbox is homed ,the mailbox’s  Total Item Size, Item Count in the mailbox and the Storage Limit Status

Export a report on mailbox sizes on a specific server:

Get-Mailbox –Server the server name –ResultSize Unlimited | Get-MailboxStatistics | Select-Object DisplayName, Database, TotalItemSize, ItemCount, StorageLimitStatus | Sort TotalItemSize, -Ascending | Export-CSV driveletter:\foldername\reportname.csv

Export a report for mailboxes homed on all your mailbox servers:

Get-ExchangeServer -Domain your domain name | Get-MailboxStatistics | sort TotalItemSize -Descending | select DisplayName, Database, StorageLimitStatus, @{label=”Total Size (MB)”;expression={$_.TotalItemSize.Value.ToMB()}}, @{label=”Deleted Item Size (MB)”;expression={$_.TotalDeletedItemSize.Value.ToMB()}} | epcsv driveletter:\foldername\reportname.csv

Obviously change -Ascending to -Descending so that the output is to your liking.


Leave a Reply