Need a little help with a powershell script

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'm trying to set up a powershell script that will email me the statistics of mailbox sizes on our exchange 2007 server. Basically it works so far. It pulls the stats for the mailboxes and puts them into a text file okay. Then it should send the file to me as an attachment but you can see the result below (in red).



$FromAddress = "[email protected]"
$ToAddress = "name@company.com"
$MessageSubject = "Mailbox Size Report"
$MessageBody = "Attached is the current list of mailbox sizes."
$SendingServer = "fqdn of mail server"


get-mailboxstatistics | Sort-Object TotalItemSize -Descending | format-table DisplayName,@{Label="TotalItemSize(MB)";expression={$_.TotalItemSize.Value.ToMB()}},ItemCount | format-table DisplayName,TotalItemSize,ItemCount > C:\CustomScripts\mailboxes.txt


$SMTPMessage = New-Object System.Net.Mail.MailMessage $FromAddress, $ToAddress,
$MessageSubject, $MessageBody
$Attachment = New-Object Net.Mail.Attachment("./mailboxes.txt")
$SMTPMessage.Attachments.Add($Attachment)


$SMTPClient = New-Object System.Net.Mail.SMTPClient $SendingServer
$SMTPClient.Send($SMTPMessage)

[PS] C:\Documents and Settings\me>C:\CustomScripts\MailBoxStatistics.PS1
Exception calling "Send" with "1" argument(s): "Mailbox unavailable. The server response was: 5.7.1 Message rejected as spam by Content Filtering."
At C:\CustomScripts\MailBoxStatistics.PS1:21 char:17
+ $SMTPClient.Send( <<<< $SMTPMessage)


Anyone with any ideas of what I'm doing wrong?

 

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.

If that is directly how you've got your script it's probably being caught as spam from:

$SendingServer = "fqdn of mail server"

Even with the correct fqdn, eg my.mailserver.com it's likely it'll be caught as spam because it can tell it has been spoofed from the headers, we had masses of problems at my company with MailMarshal being overly pedantic with our Intranet systems using a similar function, the fix was to allow a specific address, eg [email protected] to be a safe address and bypass the rules.

 

Thanks for the help.

I ended up putting the phrase Attached is the current list of mailbox sizes. into the content filter to allow messages with these phrases.

Works a treat. Now to schedule it to run every week.

 

If you were to fully authenticate with SMTP/Exchange it'd let you do it without that hassle :P

 

try this code it worked for me.



$file = "c:\name of Attachment file goes here "

$smtpServer = "severname"
$msg = new-object Net.Mail.MailMessage
$att = new-object Net.Mail.Attachment($file)
$smtp = new-object Net.Mail.SmtpClient($smtpServer)

$msg.From = "from email address"
$msg.To.Add("to email address")
$msg.Subject = " "
$msg.Body = " "
$msg.Attachments.Add($att)

$smtp.Send($msg)

$att.Dispose()