Friday, April 16, 2010

How Big are those Mailboxes

One thing I truly miss about Exchange 2003 is the list of mailbox sizes that were easily accessible in the GUI. But things must move on and the display in the Exchange Management Console for both 2007 and 2010 lack the ability to populate and view this information.

Exchange Management Shell to the rescue! If you enter just the basic Get-MailboxStatistics command it will be sorely lacking (and the sizes will be in KB). The command below will get Exchange to cough up a full list and friendlier MB display suitable for analyzing in Excel.

Open Exchange Management Shell and run the following:
Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | ft DisplayName,@{label=”TotalItemSize(MB)”;expression={$_.TotalItemSize.Value.ToMB()}},ItemCount