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.