Get Mailbox Statistics Scripts

Attachment must be a full path, and it must be quoted.

e.g.

$Attachment = New-Object Net.Mail.Attachment("mailboxes.txt")

You know you can use a CSV file for this (opens nicely in Excel) or HTML if you prefer to have it in the message body? Both look better than redirecting the output from Format-Table to a file in my opinion.

Chris

Chandru -  I saw that and used parts of it as examples.  Here is the script that I am using...

Chris -The .csv doesn't format the file correctly but I am happy to say that the script is working except for a few things.

Would either of you guys have any thoughts about how to  add in the "Storage Limit Status Column" that is viewed when typing the get-mailbox statistics command into the script?  also I am not sure how to do a carriage return after the e-mail has been sent.  

Thanks guys!


$FromAddress = "nymail@test.com"
$ToAddress = "user@test.com"
$MessageSubject = "Mailbox Size Report"
$MessageBody = "Attached is the current list of mailbox sizes"
$SendingServer = "nymail.test.corp"
get-mailbox -Server NYMAIL | Get-MailboxStatistics | Sort-Object TotalItemSize Descending | ft DisplayName,@{ expression={$_.TotalItemSize.Value.ToKB()}},ItemCount > c:\NYMAIL.txt
$SMTPMessage = New-Object System.Net.Mail.MailMessage $FromAddress, $ToAddress,
$MessageSubject, $MessageBody
$Attachment = New-Object Net.Mail.Attachment("C:\NYMAIL.txt")
$SMTPMessage.Attachments.Add($Attachment)
###Send the message
$SMTPClient = New-Object System.Net.Mail.SMTPClient $SendingServer
$SMTPClient.Send($SMTPMessage)<-------------------------------------------CARRIAGE RETURN HERE, CLOSE EXCHANGE MGMT SHELL.

Hey,

It should just need one line replacing.

The Export-CSV version:


Get-MailboxStatistics -Server NYMAIL | Sort-Object TotalItemSize -Descending | Select-Object DisplayName, `
  @{n='TotalItemSize';e={ $_.TotalItemSize.Value.ToKB() }}, ItemCount, StorageLimitStatus | Export-CSV "C:\nymail.csv"


The Format-Table version:


Get-MailboxStatistics -Server NYMAIL | Sort-Object TotalItemSize -Descending | Select-Object DisplayName, `
  @{n='TotalItemSize';e={ $_.TotalItemSize.Value.ToKB() }}, ItemCount, StorageLimitStatus | Format-Table > "C:\nymail.txt"

Chris

Chris,

Awesome! So close!  Last question, any idea how to do the carriage return at the end?  It will not send the e-mail unless I hit enter twice after I run the script.  It just hangs.

I would have thought you could just include it in the file?

Is this the last line in the file?

$SMTPClient.Send($SMTPMessage)

Or is there a line after that?

Otherwise how are you calling it at the moment? If you add a command in to load the Exchange CmdLets you can just run:

PowerShell.exe WhateverThisScriptIsCalled.ps1

Chris

I am entering the script just like it is written above into Mgmt Shell.  (changing values for fromaddress, toaddress, etc)  Once the script has finished it just hangs there.  Once you hit the enter key it will come back to the original prompt.

Oh okay, I assumed scheduled task :)

You have to hit enter twice at the end so it finishes off the script block. Just the way PowerShell works, so if you add two carriage returns at the end and always paste those in when you run it'll execute right away.

Otherwise you can always save it as a .ps1 file and run it in the shell with ./SendStats.ps1 or similar. The only change you may have to make there is to allow PowerShell to run unsigned scripts, the least restrictive setting is Unrestricted and can be set with:

Set-ExecutionPolicy Unrestricted

With that you don't have to worry about finishing off the script block at all.

Chris

ok, well I am going to run it as a scheduled task so do I need the carriage return?  What is the carriage return command?  I have googled and saw 'r'n but I tried it in an earlier script and it threw a ton of errors.

Chris is the man with scripting!