Submitted By: Nuno Mota

Delivers a big-mailboxes report for Exchange Server 2007. The following script is very useful for almost every Exchange Administrator. It exports to a .csv file some important information about big mailboxes. For example, in companies where the normal mailbox size is 500 MB, the administrator can create every month a report using this script and get the DisplayName, ItemCount, TotalItemSize, TotalDeletedItemSize, and StorageLimitStatus for every user with a mailbox bigger than 500 MB (or any other value).

PowerShell
Edit|Remove

Get-Mailbox -ResultSize Unlimited | Get-MailboxStatistics | Where {$_.TotalItemSize -gt 500MB} `
| Select-Object DisplayName, ItemCount, TotalItemSize, TotalDeletedItemSize, StorageLimitStatus `
| Export-Csv "BigMailbox$(Get-Date -f 'yyyyMMdd').csv" -NoType