Monday, February 13, 2017
Exchange 2010 How to create report about biggest mailboxes exportied to csv
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 dellarchitettura
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
Available link for download
