How to list largest mailboxes
Does anyone know how to list mailboxes sorted by size??
After consulting SAMS Microsoft Exchange Server 2007 Unleashed and finding that their samples scripts for EX07 that use get-wmiobject are useless in EX07, I'm at a standstill. Yes 2007 is great unless you look for what used to be in the GUI and now needs to be scripted. I don't have time to spend learning scripting to get a simple list - on top of evrything else I need to do. It already took me a couple of days to find WMI is useless in EX07 - thanks Sams Publishing.
Anyway - any help or direction will be greatly appreciated.
October 3rd, 2007 9:24pm
This is what I use;
Get-MailboxStatistics -Server ServerName | where {$_.totalitemsize -gt "100000000"} | Sort-Object -descending totalItemSize | Format-table DisplayName,@{expression={$_.totalitemsize.value.ToMB()};label="Mailbox Size(MB)"}, storagelimitstatus, itemcount
It shows me the mailboxes that are over 100MB
Adam Smith
Free Windows Admin Tool Kit Click here and download it now
October 3rd, 2007 10:47pm
Thank you Adam.
I very much appreciate your post and will try it tomorrow.
Dennis
October 4th, 2007 12:27am
your just simply then 10 biggest boxes
Get-MailboxStatistics | sort TotalItemSize Desc)[0..9]
Free Windows Admin Tool Kit Click here and download it now
October 4th, 2007 12:28am