MailBox Report -Exchange 2007

Very well formated report in HTML format email to your email address:

Taken from some other site but successfully tested.

just change email address to your email address & ip address to ipaddress of your SMTP server.

 $message = new-object System.Net.Mail.MailMessage(“email@email.com“, “email@email.com“)
$message.IsBodyHtml = $True
$message.Subject = “Automated E-Mail Quota Report”
$smtp = new-object Net.Mail.SmtpClient(“ipaddress“)
 
$mbcombCollection = @()
Get-Mailbox -ResultSize Unlimited | foreach-object{
$mbstatis = get-mailboxstatistics $_.identity
$TotalSizeMB = $mbstatis.TotalItemSize.Value.ToMB()
 
$mbcomb = “” | select DisplayName, TotalItemSizeMB, QuotaStatus, Itemcount, Email, CompanyName
 
$mbcomb.DisplayName = $_.DisplayName
$mbcomb.TotalItemSizeMB = $TotalSizeMB
$mbcomb.Itemcount = $mbstatis.ItemCount
$mbcomb.QuotaStatus = $mbstatis.StorageLimitStatus
$mbcomb.Email = $_.PrimarySmtpAddress
$mbcomb.CompanyName = $_.CustomAttribute1
$mbcombCollection += $mbcomb
}
 
$body = $mbcombCollection | Sort-Object -descending TotalItemSizeMB | where {$_.TotalItemSizeMB -ge 100}  | convertto-html -head ‘<style type=”text/css”> body { background-color:#EEEEEE; } body,table,td,th { font-family:Tahoma; color:Black; Font-Size:10pt } th { font-weight:bold; background-color:#CCCCCC; } td { background-color:white; } </style>’
 
$message.Body = $body
$smtp.Send($message)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s