Exchange: Getting Mailbox Sizes in PowerShell in MB - sort by size

You can use the following powershell command to filter the mailboxes sizes by Custom Attribut (department / country):

Just all mailboxes, sort by size, display in MB:

Get-mailbox -resultsize unlimited| Get-MailboxStatistics | sort-object TotalItemsize | FT DisplayName, @{label="Mailbox size (MB)"; expression={$_.TotalItemSize.Value.ToMB()}}

All mailboxes with export, sort by size, display in MB:

Get-mailbox -resultsize unlimited| Get-MailboxStatistics | sort-object TotalItemsize | FT DisplayName, @{label="Mailbox size (MB)"; expression={$_.TotalItemSize.Value.ToMB()}} | export-csv c:\test.csv

Filter by customattribute 10 with export, sort by size, display in MB

Get-mailbox | where {$_.CustomAttribute10 -eq "employee"} | Get-MailboxStatistics | sort-object TotalItemsize | FT DisplayName, @{label="Mailbox size (MB)"; expression={$_.TotalItemSize.Value.ToMB()}}  | export-csv c:\test.csv