Generating a Report of Mailboxes Who Have Crossed Quota Threshold

Recently, I have got a request to send a copy of all users who are reaching or at or above mailbox quota threshold to one of the Administrators.

By default, quota threshold limit notifications are sent to users themselves only. Even if an Exchange Transport rule is set up for this, it won’t work.

Following Power Shell command can be executed instead to get a report of such mailboxes and send to whoever needs it. You can save and schedule it if you want if the request is to get that periodically.

Get-MailboxStatistics | where {“IssueWarning”,”ProhibitSend”,”MailboxDisabled” -contains $_.StorageLimitStatus} | format-Table DisplayName, @{expression={$_.totalitemsize.value.ToMB()};label=”Mailbox Size(MB)”}, itemcount >> c:\quota_threshold.csv

You can run this against a specific Database as well.