One of the things that I have liked the most about the move to Exchange 2007 is the introduction of PowerShell into the management of Exchange. PowerShell is a very powerful tool that the Exchange ...
Updated Jul 01, 2019
Version 2.0
Blog Post
Hi Jbrines,
Quotas are actually stored as AD attributes, so you can just use get-mailbox to find out what a users current quota value is. If they have a value that differs from the default store limit the value of UseDatabaseQuotaDefaults will be set to False. So a simple one line command like:
get-mailbox -Filter "UseDatabaseQuotaDefaults -eq `$false" -ResultSize Unlimited
Will get us all of the users whose quota is not the default mailbox store value. Then simply adding a | export-csv will export all of the information about the users to a CSV file where you can import it into Excel and do anything you want with it data manipulation wise.
get-mailbox -Filter "UseDatabaseQuotaDefaults -eq `$false" -ResultSize Unlimited | export-csv c:quota.csv
Quotas are actually stored as AD attributes, so you can just use get-mailbox to find out what a users current quota value is. If they have a value that differs from the default store limit the value of UseDatabaseQuotaDefaults will be set to False. So a simple one line command like:
get-mailbox -Filter "UseDatabaseQuotaDefaults -eq `$false" -ResultSize Unlimited
Will get us all of the users whose quota is not the default mailbox store value. Then simply adding a | export-csv will export all of the information about the users to a CSV file where you can import it into Excel and do anything you want with it data manipulation wise.
get-mailbox -Filter "UseDatabaseQuotaDefaults -eq `$false" -ResultSize Unlimited | export-csv c:quota.csv