Hi

I could use some help here. I would like to have a script that pulls out MailboxStatistics for a couple of Mailboxservers and mailed to me with the day and month.

my script:

$VarDay = (Get-Date).day
$VarMonth = (Get-Date).month
Get-MailboxStatistics -server  |select DisplayName,TotalItemSize,StorageLimitStatus, Database| sort-object TotalItemSize -Descending

I'm pretty new at this and would appreciate any help here.

Here is the one I use each night, maybe you can modify it to what you need:

$Day = (Get-Date).day
$Month = (Get-Date).month
$Year = (Get-Date).Year
$mailbox1 = "Mailbox Report for $Day/$Month/$Year`n"
$mailbox2 = Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | ft DisplayName,@{label="TotalItemSize(MB)";expression={$_.TotalItemSize.Value.ToMB()}},ItemCount | Out-String
$messagesubject = "Daily Mailbox Usage Report"
$mailboxfinal = $mailbox1 + $mailbox2
$SmtpClient = new-object system.net.mail.smtpClient
$MailMessage = New-Object system.net.mail.mailmessage
$SmtpClient.Host = "localhost"
$mailmessage.from = "fromaddress@domain.com"
$mailmessage.To.add(addressee1@domain.com)
$mailmessage.To.add(addressee2@domain.com)
$mailmessage.Subject = $messagesubject
$mailmessage.Body = $mailboxfinal
$smtpclient.Send($mailmessage)

I am running this script saved as getmailstats.ps1

$Day = (Get-Date).day
$Month = (Get-Date).month
$Year = (Get-Date).Year
$mailbox1 = "Mailbox Report for $Day/$Month/$Year`n"
$mailbox2 = Get-MailBoxStatistics | where {"IssueWarning","ProhibitSend","MailboxDisabled" -contains $_.StorageLimitStatus} | sort-object storagelimitstatus -Descending | ft DisplayName, StorageLimitStatus, LastLogonTime | Out-String
$mailbox3 = Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | ft DisplayName,@{label="TotalItemSize(MB)";expression={$_.TotalItemSize.Value.ToMB()}},ItemCount | Out-String
$messagesubject = "Daily Mailbox Usage Report"
$mailboxfinal = $mailbox1 + $mailbox2 + $mailbox3
$messagesubject = "Daily Mailbox Usage Report"
$mailboxfinal = $mailbox1 + $mailbox2
$SmtpClient = new-object system.net.mail.smtpClient
$MailMessage = New-Object system.net.mail.mailmessage
$SmtpClient.Host = "localhost"
$mailmessage.from = "reports@root.local"
$mailmessage.To.add("First.last@root.local")
$mailmessage.Subject = $messagesubject
$mailmessage.Body = $mailboxfinal
$smtpclient.Send($mailmessage)


When i run it i get this error

$smtpclient.Send($mailmessage)\Windows\System32>getmailstats.ps1
Exception calling "Send" with "1" argument(s): "Service not available, closing transmission channel. The server response was: 4.3.2 Service not available, closing
transmission channel"
At C:/Windows\system32\getmailstats.ps1:18 char:17
+ $smtpclient.Send( <<<< $mailmessage)



Anyone have any suggestion on what i am doing wrong
Thank you
Ken