Can I export user mailbox sizes to csv?
Hello, Can I export all our users mailbox current sizes and what their limit is? I did run this: Get-MailboxStatistics -server Exchange123 | Sort-Object To talItemSize -Descending | ft DisplayName,@ label="TotalItemSize(MB)";expression={$_.TotalItemSize.Value.ToMB() }},ItemCount >> c:\text12345.txt But can it show their what the maximum mailbox size can grow to? Thanks
October 19th, 2011 1:22pm

Hello I have tested in my lab below script, this should work J Get-Mailbox -ResultSize Unlimited | Get-MailboxStatistics | Select-Object DisplayName, @{name="TotalItemSize(MB)";expression={$_.TotalItemSize.Value.ToMB()}}, ItemCount | Export-Csv "UserMailboxSizes.csv" -NoTypeInformation Regards Chinthaka Shameera | MCITP: EA | MCSE: M | http://howtoexchange.wordpress.com/
Free Windows Admin Tool Kit Click here and download it now
October 19th, 2011 1:41pm

Probably. Exactly how will depend on what version of Exchange you're running.[string](0..33|%{[char][int](46+("686552495351636652556262185355647068516270555358646562655775 0645570").substring(($_*2),2))})-replace " "
October 19th, 2011 1:42pm

Hello I have tested in my lab below script, this should work J Get-Mailbox -ResultSize Unlimited | Get-MailboxStatistics | Select-Object DisplayName, @{name="TotalItemSize(MB)";expression={$_.TotalItemSize.Value.ToMB()}}, ItemCount | Export-Csv "UserMailboxSizes.csv" -NoTypeInformation Regards Chinthaka Shameera | MCITP: EA | MCSE: M | http://howtoexchange.wordpress.com/ Above my Cmdlet will work with Exchange 2010 and Exchange 2007 Chinthaka Shameera | MCITP: EA | MCSE: M | http://howtoexchange.wordpress.com/
Free Windows Admin Tool Kit Click here and download it now
October 19th, 2011 1:43pm

Sorry guys I missed the most important part off. We use Exchange 2007 SP3 Rollup 4.
October 19th, 2011 1:50pm

My script seems to do the same as yours, anyway I can add what the mailbox limit is, so it will show current size and it's limit that it acn go up to?
Free Windows Admin Tool Kit Click here and download it now
October 19th, 2011 1:55pm

OK done :) I have tested in my lab below script, this should work J get-mailbox -ResultSize unlimited | select-object DisplayName, IssueWarningQuota, ProhibitSendQuota, @{label="TotalItemSize(MB)";expression={(get-mailboxstatistics $_).TotalItemSize.Value.ToMB()}}, @{label="ItemCount";expression={(get-mailboxstatistics $_).ItemCount}}, Database | Export-Csv "UserMailboxSizes.csv" –NoTypeInformation Regards Chinthaka Shameera | MCITP: EA | MCSE: M | http://howtoexchange.wordpress.com/
October 19th, 2011 2:49pm

OK done :) I have tested in my lab below script, this should work J get-mailbox -ResultSize unlimited | select-object DisplayName, IssueWarningQuota, ProhibitSendQuota, @{label="TotalItemSize(MB)";expression={(get-mailboxstatistics $_).TotalItemSize.Value.ToMB()}}, @{label="ItemCount";expression={(get-mailboxstatistics $_).ItemCount}}, Database | Export-Csv "UserMailboxSizes.csv" –NoTypeInformation Regards Chinthaka Shameera | MCITP: EA | MCSE: M | http://howtoexchange.wordpress.com/
Free Windows Admin Tool Kit Click here and download it now
October 19th, 2011 9:39pm

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

Other recent topics Other recent topics