Export biggest mailbox users with attributes to csv!

Posted by Harri Jaakkonen Posted on 12/08/2014 0 Comments on Export biggest mailbox users with attributes to csv!
Posted in Exchange, Powershell

This is how:

Get-Mailbox -ResultSize
Unlimited |
Get-MailboxStatistics |
Select DisplayName,servername,database,StorageLimitStatus,
@{name=”TotalItemSize (MB)”;expression={[math]::Round((($_.TotalItemSize.Value.ToString()).Split(“(“)[1].Split(” “)[0].
Replace(“,”,””)/1MB),2)}},@{name=”TotalDeletedItemSize (MB)”;expression={[math]
::Round((($_.TotalDeletedItemSize.Value.ToString()).Split(“(“)[1].Split(” “)[0].
Replace(“,”,””)/1MB),2)}},ItemCount,DeletedItemCount
| Sort “TotalItemSize (MB)”
 -Descending | Export-CSV “C:dirAll Mailboxes_120814.csv” -NoTypeInformation
Love it!
Author: Harri Jaakkonen

Leave a Reply

Your email address will not be published. Required fields are marked *