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