Use the following script in PowerShell:
Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | ft DisplayName,@{label="TotalItemSize(MB)";expression={$_.TotalItemSize.Value.ToMB()}},ItemCount
This script will list all mailboxes starting with the largest then descending down the page. It will also give you number of items in each mailbox and list size in MB.
You can adjust the Size metric given by changing {$_.TotalItemSize.Value.ToMB()} to either {$_.TotalItemSize.Value.ToKB()} or if you are unlucky {$_.TotalItemSize.Value.ToGB()}. Also if you would like to change the listing at the top of the report make a similar change to the "TotalItemSize(MB)" expression.
Also take a look at this posts:
http://social.technet.microsoft.com/Forums/en-US/exchangesvradmin/thread/1d95e6b4-e3cf-4bce-85af-8ce0d94d9cef
http://exchangeshare.wordpress.com/2008/04/23/emc-where-are-mailbox-total-items-size-kb-columns/
http://www.exchangeninjas.com/MailboxSizeReport
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment