is it generally seen as best practice to enforce a max mailbox size limit?
Get-Mailbox -ResultSize Unlimited | Get-MailboxStatistics | ?{$_.TotalItemSize -gt 2GB} | Select DisplayName,TotalItemSize
Above command will only get you the mailboxes that are greater than 2GB.
In case if you want query per database then you can use:
Get-MailboxStatistics -Database DBName | ?{$_.TotalItemSize -gt 2GB} | Select DisplayName,TotalItemSize
Hi,
If you want to verify the status of the mailbox quota for all the mailboxes that are hosted on a database, run the following command:
Get-MailboxStatistics -Database <var>DatabaseName</var> | ft displayname,*quota*,*size -AutoSize -Wrap
For mor information about this, please refer to:
http://support2.microsoft.com/kb/2819389/en-us
Regards,