This is how:



Get-Mailbox -ResultSize Unlimited | Get-MailboxStatistics |
Select DisplayName,servername,database,StorageLimitStatus,
@{name="TotalItemSize (MB)";expression={::Round((($_.TotalItemSize.Value.ToString()).Split("(").Split(" ").
Replace(",","")/1MB),2)}},@{name="TotalDeletedItemSize (MB)";expression={
::Round((($_.TotalDeletedItemSize.Value.ToString()).Split("(").Split(" ").
Replace(",","")/1MB),2)}},ItemCount,DeletedItemCount | Sort "TotalItemSize (MB)"
 -Descending | Export-CSV "C:dirAll Mailboxes_120814.csv" -NoTypeInformation

Love it!

Archives