During last few months, more than few times I received inquiry from clients, where they want list all mailboxes sorted by size.

For that action, approximately needed time is 5 minutes, if you know which PowerShell command you need to run.

Command Get-Mailbox | Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | Select DisplayName, TotalItemSize will show you desired list.

<br />
DisplayName               TotalItemSize<br />
-----------               -------------<br />
Vladimir Stefanovic       24.73 GB (26,553,551,240 bytes)<br />
John Doe                  15.49 GB (16,630,213,681 bytes)<br />
User 01                   14.5 GB (15,566,374,992 bytes)<br />
User 02                    7.188 GB (7,717,571,477 bytes)<br />
Administrator              5.474 GB (5,877,998,363 bytes)<br />
Local Administrator        1.993 GB (2,139,826,545 bytes)<br />

If you want to export result to CSV file, just need to add one more pipe and command for exporting. Get-Mailbox | Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | Select DisplayName, TotalItemSize | Export-Csv “path”.

 

 

Leave a Reply

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