Here is a quick way to use the Exchange Management Shell to the storage quota’s set for all of you Exchange 2010 databases. The quota limits are the default limit that will be used for all mailboxes on the database. This example will give you the database name, when a warning will be issued to the users approaching there limit, the prohibit send mail limit, the prohibit receive mail limit and the deleted item retention time. It will also get this information for all databases.
Get-MailboxDatabase | select identity,IssueWarningQuota,ProhibitSendReceiveQuota,ProhibitSendQuota,DeletedItemRetention
If you would like to run this same command and dump all of this information to a csv file you can type the following command:
Get-MailboxDatabase | select identity,IssueWarningQuota,ProhibitSendReceiveQuota,ProhibitSendQuota,DeletedItemRetention | Export-Csv c:\Output\Mailstoragequotas.csv -NoTypeInformation
The above command will create a csv name Mailstoragequotas.csv in the c:\output folder.
The output in the csv file will look as follows:
Hope this helps! If you have any questions or feedback please leave a comment.