First 100 mailboxes
Get-Mailbox -ResultSize Unlimited | Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | Select-Object DisplayName,TotalItemSize -First 100 | Export-Csv -Path "c:\Top100mailboxusersSize_1_00.csv" -Delimiter ";"
All mailboxes
Get-Mailbox -ResultSize Unlimited | Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | Select-Object DisplayName,TotalItemSize | Export-Csv -Path "c:\AllmailboxusersSize_1_00.csv" -Delimiter ";"
Meanwhile you could be interested to get, for each mailboxes, relatives limits that was setting up on Exchange server
Get-Mailbox -ResultSize Unlimited | Select-Object DisplayName,Database,IssueWarningQuota,ProhibitSendQuota,ProhibitSendReceiveQuota | Export-Csv -Path "c:\AllmailboxusersIssueWarning_1_00.csv" -Delimiter ";"
So in this specific case you will get two .csv reports.
AllmailboxusersIssueWarning_1_00.csv
AllmailboxusersSize_1_00.csv
You can merge these files importing these .csv files in a single excel file and and use this Excel File function:
CERCA.VERT(A13;AllMailboxexLimits!1:1048576;3;FALSO)
In english function name should be find.vert
Where A13 is our Mailboxes user name and first column (AllmailboxusersSize_1_00.csv)
Where AllMailboxexLimits!1:1048576 is second Excel tab imported (AllmailboxusersIssueWarning_1_00.csv)
Where 3 is the relavive IssueWarningQuota found in second Excel tab imported (AllmailboxusersIssueWarning_1_00.csv)
You can repeat this task for other values:
ProhibitSendQuota
ProhibitSendReceiveQuota
<-----------other -------="" articles="" blog="" related="">
<-------->
You could be interested to these similar article too:
Exchange 201X- How get all users who have a forwarding email, redirect rule and delegate permission on them mailboxes or Outlook folders
Exchange 2013 - How to monitor it with powershell command
Exchange - Microsoft Exchange Server User Monitor
Exchange 2010 - Poster dell'architettura
Exchange 2010 - How to monitor Exchange Health
Exchange 2010 - How export to pst single mailbox or all mailboxes with single command or powershell command
Exchange 2013 - How to monitor it with powershell command
Exchange 2010 - How to get info on Mobile devices connected via ActiveSync, quarantine any new device and remote Wipe them.
Exchange 2003/2010 - Add a photo to user contact
