Exchange Database Last Backup - Size Report and HTML Email

Exchange 2010 / 2013 Database Last Backup - Size Report and HTML Email

#Makes a report about exchange database sizes and the last time they were backed up sends HTML email

add-pssnapin Microsoft.Exchange.Management.PowerShell.E2010

clear

$newlist = @()

function do_mail ($myhtml) {

$mymail = new-object Net.Mail.MailMessage

$smtp = new-object Net.Mail.SmtpClient("mailrelay.domain1.com") #Dns name or IP

$mymail.IsBodyHTML = $true

$mymail.From = "ServerReporting@Company.edu"

$mymail.To.Add("sysadmins@company.edu")

$mymail.Subject = ("Exchange DB Size / Backup Monitor report")

$mymail.Body = $myhtml

#$mymail.Attachments.Add($attach)

$smtp.Send($mymail)

} #do_mail

$head = "<style>"

$head = $head + "BODY{background-color:#9FAEB5;}"

$head = $head + "TABLE{border-width: 1px;border-style: solid;border-color: black;border-collapse: collapse;}"

$head = $head + "TH{border-width: 1px;padding: 0px;border-style: solid;border-color: black;background-color:#999999}"

$head = $head + "TD{border-width: 1px;padding: 0px;border-style: solid;border-color: black;background-color:#CCCCCC}"

$head = $head + "</style>"

$myhtml = Get-MailboxDatabase -Status | select Name, Mountedonserver, DatabaseSize, LastFullBackup | ConvertTo-HTML -head $head -body ("<H2>Exchange Database Sizes / Last Backup</H2>")

do_mail $myhtml