Need to find all users who are NOT set to use the default message store limits in Exchange 2010

Over the years have accumulated many users who have been hard set by multiple admins to a "higher" mailbox limit than what default size was at the time, but as we have increased default message store sizes, these users in turn end up with smaller size limits than the new default.  None of these users will be set to "unlimited".

Trying to find the correct powershell command to search all databases in Exchange 2010 to find users who are NOT set to use mailbox database defaults, and preferably output to an Excel or Word doc to be used to go back and easily review settings for the users.  
pifer-grinnell-eduAsked:
Who is Participating?
 
KenMcFConnect With a Mentor Commented:
Try to use this

get-mailbox | where{$_.UseDatabaseQuotaDefaults -ne "TRUE"} | select name, database | export-csv c:\mailbox.csv
0
 
pifer-grinnell-eduAuthor Commented:
Command was almost perfect, only needed to add -ResultSize Unlimited to it for final command of:
get-mailbox -ResultSize Unlimited | where{$_.UseDatabaseQuotaDefaults -ne "TRUE"} | select name, database | export-csv c:\mailbox.csv
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.