Export biggest mailbox users with attributes to csv!
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!