In Exchange Server 2010 the Exchange Management Console doesn’t provide a way to visually locate mailboxes that have no storage quota, or mailboxes that have a non-standard storage quota configured.  However you can find mailbox storage quota settings quickly using the Exchange Management Shell.

To list all Exchange Server 2010 mailboxes that are exempt from the mailbox database storage quota settings use this command in the Exchange Management Shell.

[PS] C:\>get-mailbox | where {$_.UseDatabaseQuotaDefaults -eq $False}

Name                      Alias                ServerName       ProhibitSendQuota
----                      -----                ----------       -----------------
DiscoverySearchMailbox... DiscoverySearchMa... ex2              50 GB (53,687,091,200 bytes)
Carole.Malik              Carole.Malik         ex2              unlimited
Davina.Nsiah              Davina.Nsiah         ex2              5.371 GB (5,767,168,000 bytes)
Helen.Cail                Helen.Cail           ex2              4.688 GB (5,033,164,800 bytes)
Jas.Mahal                 Jas.Mahal            ex2              unlimited
Lorraine.Oza              Lorraine.Oza         ex2              unlimited
Oliver.Loffler            Oliver.Loffler       ex2              4.688 GB (5,033,164,800 bytes)

The output above shows that some mailboxes have no quotas, whereas others have custom storage quotas applied. To see the full details of the storage quotas configured on these mailboxes use the following command in the Exchange Management Shell.

[PS] C:\>get-mailbox | where {$_.UseDatabaseQuotaDefaults -eq $False} | ft name,prohibit*,issue*

Name                          ProhibitSendQuota             ProhibitSendReceiveQuota      IssueWarningQuota
----                          -----------------             ------------------------      -----------------
DiscoverySearchMailbox {D9... 50 GB (53,687,091,200 bytes)  50 GB (53,687,091,200 bytes)  unlimited
Carole.Malik                  unlimited                     unlimited                     unlimited
Davina.Nsiah                  5.371 GB (5,767,168,000 by... unlimited                     4.883 GB (5,242,880,000 by...
Helen.Cail                    4.688 GB (5,033,164,800 by... unlimited                     4.395 GB (4,718,592,000 by...
Jas.Mahal                     unlimited                     unlimited                     unlimited
Lorraine.Oza                  unlimited                     unlimited                     unlimited
Oliver.Loffler                4.688 GB (5,033,164,800 by... unlimited                     4.395 GB (4,718,592,000 by...

About the Author

Paul Cunningham

Paul is a former Microsoft MVP for Office Apps and Services. He works as a consultant, writer, and trainer specializing in Office 365 and Exchange Server. Paul no longer writes for Practical365.com.

Comments

  1. Krish

    How do i get the Department information with the help of this script?

  2. Luis Poitevin

    I ran the script but some users without limit are not listed in results.
    I ran the scritp with the option -resultsize unlimited but still no results. If i go to EMC i can see that those users don’t have limits, in storage quote settings.
    get-mailbox -resultsize unlimited | where {$_.UseDatabaseQuotaDefaults -eq $False} | Export-Csv

  3. Peter

    What command do I need to use when I want to now the users without quota, but also want to know their TotalItemSize? Thanks.

  4. Celia

    The script is great! I got the report. But I am not sure if it shows all users not using default database quota. And how to get user email address at the same time?
    Looking forward to your reply. Thanks.

    1. Avatar photo
      Paul Cunningham

      You’re not sure it shows all users? If there’s a reason you’re not sure you’ll need to be clearer before I can offer any suggestions.

      Email address can be retrieved by adding “PrimarySMTPAddress” to the attributes at the end of the command, eg “| ft name,primarysmtpaddress,prohibit*,issue*”

  5. felix

    hi Paul,
    i want to export csv list to my desktop for all my users with their respective mailbox quota status. Please hekp me with the command so i can ran now.

    thanks, felix

  6. callan halls-palmer

    Hi Paul,

    I ran the command to convert to a CSV file, where does it get exported to?

    Cheers,

    Callan

    1. Avatar photo
      Paul Cunningham

      Same folder where you were running the command. Or if you provided a full path for the CSV file it will go to that full path.

  7. Tireak

    How would I output this to a csv file??

    1. Avatar photo
      Paul Cunningham

      get-mailbox | where {$_.UseDatabaseQuotaDefaults -eq $False} | select name,prohibit*,issue* | Export-CSV filename.csv -NoTypeInformation

      Replace filename.csv with whatever you want to call it.

  8. mohamed

    hi…
    this script saved my valuable time ….
    thanks bro…

Leave a Reply