Exchange 2010 Mailbox Quotas Report

nutekconsultant
nutekconsultant used Ask the Experts™
on
Hi, our management is asking for a "report" which shows the entire companies Exchange 2010 users and what mailbox quotas are setup/configured (any users unlimited, or have hard coded quotas and what the quotas are)




Thanks,
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Technical Manager
Top Expert 2010
Commented:
Please execute below command in Exchange PowerShell:
Get-Mailbox -ResultSize Unlimited | Select-Object DisplayName, IssueWarningQuota, ProhibitSendQuota, @{label="TotalItemSize(MB)";expression={(Get-MailboxStatistics $_).TotalItemSize.Value.ToMB()}}, @{label="ItemCount";expression={(Get-MailboxStatistics $_).ItemCount}}, Database | Export-Csv "C:\UserMailboxSizes.csv" -NoTypeInformation
Scott CSenior Engineer
Commented:
Try this:

get-mailbox -server <server> -ResultSize unlimited |
  Where {$_.UseDatabaseQuotaDefaults -eq $false} |
    ft DisplayName,IssueWarningQuota,ProhibitSendQuota,@{label="TotalItemSize(MB)";expression={(get-mailboxstatistics $_).TotalItemSize.Value.ToMB()}}

Or this if you want it sent to a CSV file.

get-mailbox -server <server> -ResultSize unlimited |
 Where {$_.UseDatabaseQuotaDefaults -eq $false} |
    Select-Object DisplayName,IssueWarningQuota,ProhibitSendQuota,@{label="TotalItemSize(MB)";expression={(get-mailboxstatistics $_).TotalItemSize.Value.ToMB()}} |
 Export-CSV C:\report.csv

Author

Commented:
great !  thanks for the great replies and quick responses!

Author

Commented:
is there a way to show the above without the "Disabled Users "in Exchange
and also sort/export to a csv in alphabetical order?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial