Quotas Request
HelloI would need to provide 3 reports in both *.txt and .*cvs of:1- A list of the Mailbox Size (space used and free) foreach user.2- A list ofMailbox Sizesfor only only user (space used and free) 3- A list of quota sizes for each user.I guess I need to use shell Commands but I am not good enough to find the correct one and to export the dat into a file.Could you please help me out
April 8th, 2009 12:01pm

Hi Graiggoriz, Based on my research, we can run the following command to query space used of all mailboxes that reside on a server: Get-MailboxStatistics -server server_name| ft TotalItemSize,DisplayName >c:\TotalSizereport.csv However, there is no straight way to query free space of a mailbox. Because we can set mailbox size Quota on mailbox database and individual mailbox. If we get mailbox size Quota on mailbox database and individual mailbox, we will calculate the free space of a mailbox. You can try the following steps: 1. Run the following command to query the mailbox size Quota on the mailbox database: Get-MailboxDatabase -Server server_name | ft Identity,IssueWarningQuota,ProhibitSendReceiveQuota,ProhibitSendQuota Wrap 2. Then run the following command to query mailbox size Quota of all mailboxes that reside on a server, the first two steps answer your third question get-mailbox -Server server_name | ft Identity,ProhibitSendReceiveQuota,IssueWarningQuota,ProhibitSendQuota,UseDatabaseQuotaDefaults -Wrap >c:\report.csv 3. Subtract space used from mailbox size Quota, you can get the free space. For how to get single users space used and free space, run the following commands: Get-MailboxStatistics identity mailbox_name | ft TotalItemSize,DisplayName >c:\report.csv Get-MailboxDatabase -Server server_name | ft Identity,IssueWarningQuota,ProhibitSendReceiveQuota,ProhibitSendQuota Wrap get-mailboxidentity mailbox_name | ft Identity,ProhibitSendReceiveQuota,IssueWarningQuota,ProhibitSendQuota,UseDatabaseQuotaDefaults -Wrap >c:\report.csv Note: you should replace server_name with the exact server name, replace mailbox_name with the exact mailboxs name related articles: Get-MailboxStatistics http://technet.microsoft.com/en-us/library/bb124612.aspx Get-Mailbox http://technet.microsoft.com/en-us/library/bb123685.aspx If anything is unclear, feel free to let me know. Regards, Rock WangRock Wang MSFT
Free Windows Admin Tool Kit Click here and download it now
April 8th, 2009 2:05pm

I agree with Rock, just wanted to share brief procedure to get report with Get-MailboxStatistics.... EMC - Where are Mailbox Total Items & Size (KB) Columns? http://exchangeshare.wordpress.com/2008/04/23/emc-where-are-mailbox-total-items-size-kb-columns/ Amit Tank | MVP - Exchange | MCITP:EMA MCSA:M | http://ExchangeShare.WordPress.com
April 8th, 2009 2:51pm

Thank you so much!! IT is very clean and it helped me a lot.THANKS AGAIN :-D
Free Windows Admin Tool Kit Click here and download it now
April 9th, 2009 12:46pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics