Exchange 2010 Mailbox Sizes, formated output

Here is the command to output a formatted table with the Mailbox size formatted to be human readable.

 

[PS] C:\Users\adminpds>get-mailboxstatistics -server ex-002 |Sort-Object TotalItemSize -Descending |Select-Object Displayname,  itemcount, TotalItemSize, database |ft Displayname,itemcount,@{n="Total Size (MB)";e={"{0:N0}" -f $_.TotalItemSize.Value.ToMB()};a="right"}, database