Exchange 2010 - How to create report about biggest mailboxes exportied to .csv

If you need to identify users that have bigger mailboxes size you can use these scripts on your exchange server:


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


720check