Get Exchange mailbox statistics on your email (Powershell)

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

I've written this for work but thought that someone else can find it useful.

The script connects to Exchange server, gets the list of mailboxes and emails results to you in CSV file with following format:

Code:

Name | Item Count | Size | Deleted Item Count | Deleted Item Size | Mailbox Database

Script needs to be executed from EMS so below you can see batch script used to run it in case you want to get Task Scheduler to send you reports on regular basis.

ReportMailboxSizes.ps1:

Code:

$EmailFrom = "from_address"
$EmailTo = "to_address"
$EmailSubject = "Weekly Mailbox Report"  

$SMTPServer = "192.168.10.5"

Get-MailboxStatistics -Server <Exchange_Server_Name> |
Sort-Object -Property TotalItemSize -Descending | 
Select-Object -property DisplayName,@{N="ItemCount";E={$_.ItemCount}},
				@{N="TotalItemSize";E={$_.TotalItemSize}},
				@{N="deletedItemCount";E={$_.deletedItemCount}},
				@{N="TotalDeletedItemSize";E={$_.TotalDeletedItemSize}},
				@{N="Database";E={$_.Database}} |
Export-CSV -Path MailboxReport.csv -NoTypeInformation 

Send-MailMessage -To "$EmailTo" -From "$EmailFrom" -subject "$EmailSubject" 
-Attachments "MailboxReport.csv" -smtpServer "$SMTPServer"

You will need to provide email addresses (from and to), SMTP server IP address (doesn't seem to work with hostnames for some reason) and Exchange Server name in Get-MailboxStatistics cmdlet.

To add it to task scheduler use batch file.

RunMailboxReport.bat

Code:

C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -command 
". 'C:\Program Files\Microsoft\Exchange Server\V14\bin\RemoteExchange.ps1'; 
Connect-ExchangeServer -auto; C:\EXCHANGE_Scripts\ReportMailboxSizes.ps1"

Modify path to ReportMailboxSizes.ps1 file. It's basically target entry from EMS shortcut in start menu with semicolon and path to our script at the end.

It requires Powershell v2 due to new mail sending cmdlet. Tested with Exchange 2010.

Hopefully someone fill find it useful.

Any questions, just ask.

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Yeeeeeah. Nice one MS - remove something from the GUI and make people p155 around with scripting instead to get the info you need. If I wanted to do that, I'd run an opensource mail server and save myself a sh1tload of cash. Removing stuff like this from the ESM is yet another in a long line of stupidness from MS. If it's all the same with you, MS, I'll stick with 2003 (which works, is stable to the point of ridiculousness and doesn't require me to write forty lines of code to do the same thing as 'right-click - export')

Kudos to you for the script though Luke - nice one.