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