If only Microsoft would realize that it’s pretty easy to add a single column known as “size of mailbox” when searching through the GUI exchange management tool. Instead, we have to open up the Command prompt tool. Big deal.<\/p>\n
Here’s the quick and easy way to list the name of the mailbox, size of said mailbox, and number of emails: And apparently you can get it to email you if you write a script as follows: But I couldn’t get it to actually attach the txt document.<\/p>\n EDIT!!!<\/p>\n 11.11.2008<\/p>\n I got it to work – the problem was with a couple issues we had.<\/p>\n 1.) In the Windows PowerShell, you must ***EDIT 05.23.2011*** You can use -Identity MAILBOXORUSERNAME, -Database DATABASEHERE, or -Server SERVERNAMEHERE. I chose server as it’s exactly what I needed.<\/p>\n","protected":false},"excerpt":{"rendered":" If only Microsoft would realize that it’s pretty easy to add a single column known as “size of mailbox” when searching through the GUI exchange management tool. Instead, we have to open up the Command prompt tool. Big deal. Here’s the quick and easy way to list the name of the mailbox, size of said … Continue reading Exchange 2007 Mailbox Statistics<\/span>
\nGet-MailboxStatistics | Sort-Object TotalItemSize -Descending | ft DisplayName,@{label=\"TotalItemSize(KB)\";expression={$_.TotalItemSize.Value.ToKB()}},ItemCount<\/code><\/p>\n
\n###Send mailbox statistics script
\n###First, the administrator must change the mail message values in this section
\n$FromAddress = \"MailboxReport@ngh.net\"
\n$ToAddress = \"administrator@ngh.net\"
\n$MessageSubject = \"Mailbox Size Report\"
\n$MessageBody = \"Attached is the current list of mailbox sizes.\"
\n$SendingServer = \"e2k7.ngh.net\"
\n###Now get the stats and store in a text file
\nGet-MailboxStatistics | Sort-Object TotalItemSize -Descending | ft DisplayName,@{label=\"TotalItemSize(KB)\";expression={$_.TotalItemSize.Value.ToKB()}}, ItemCount > mailboxes.txt
\n###Create the mail message and add the statistics text file as an attachment
\n$SMTPMessage = New-Object System.Net.Mail.MailMessage $FromAddress, $ToAddress,
\n$MessageSubject, $MessageBody
\n$Attachment = New-Object Net.Mail.Attachment(\".\/mailboxes.txt\")
\n$SMTPMessage.Attachments.Add($Attachment)
\n###Send the message
\n$SMTPClient = New-Object System.Net.Mail.SMTPClient $SendingServer
\n$SMTPClient.Send($SMTPMessage)
\n<\/code><\/p>\nSet-ExecutionPolicy Unrestricted<\/code>
\n2.) I wrote a bat file to open this once a week:
\nC:\\WINDOWS\\system32\\WindowsPowerShell\\v1.0\\PowerShell.exe -PSConsoleFile \"C:\\Program Files\\Microsoft\\Exchange Server\\bin\\exshell.psc1\" -command \". 'C:\\sendstats.ps1'\"<\/code>
\n3.) I wrote a ps1 file to run the actual commands (see above for the code)
\n4.) If you get an error, see if the following command helps:
\nAdd-PSSnapin Microsoft.Exchange.Management.PowerShell.Admin<\/code>
\n5.) MAKE SURE the get-mailboxstatistics is all on one single line – I can’t tell you how much word-wrap in notepad screwed me out of 20 minutes of time.<\/p>\n
\nSo Exchange 2010 screwed me a little bit on this – it requires another flag:
\nGet-MailboxStatistics -server SERVERNAME | Sort-Object TotalItemSize -Descending | ft DisplayName,@{label=\"TotalItemSize(KB)\";expression={$_.TotalItemSize.Value.ToKB()}},ItemCount<\/code><\/p>\n