How to generate the Exchange mailbox size report

Here’s a handly little script that you can use to get the size of your mailbox and other useful information such as the mailbox quotas.

The script generates a CSV file with the columns below:

• Display Name
• Primary SMTP
• Organizational Unit
• Email Aliases
• Total Item Size in MB
• Item Count
• Storage Limit Status
• Use Database Quota Defaults
• Prohibit Send Receive Quota in MB

How to generate the Exchange mailbox size report

1) Download the script from here: https://gallery.technet.microsoft.com/Exchange-2010-2013-2016-cee5e558

2) Open up the Exchange Management Shell then change to the directory where you have downloaded the script

3) Run the script as below:

.\New-MailboxSizeReport.ps1 -CSVPath C:\MailboxSizes.csv

Now you should have a CSV file which looks like this when opened up and formatted with Excel:

Hopefully this will help you manage your mailboxes.