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...
How do i get the Department information with the help of this script?
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
What command do I need to use when I want to now the users without quota, but also want to know their TotalItemSize? Thanks.
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.
The Real Person!
The Real Person!
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*”
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
The Real Person!
The Real Person!
What commands have you tried so far?
Hi Paul,
I ran the command to convert to a CSV file, where does it get exported to?
Cheers,
Callan
The Real Person!
The Real Person!
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.
Pingback: Exchange 2010: Como localizar mailboxes sem Cota de armazenamento. – Windows Brasil
How would I output this to a csv file??
The Real Person!
The Real Person!
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.
hi…
this script saved my valuable time ….
thanks bro…
Pingback: PowerShell: How to Add a Message Body to Emails Sent from Scripts