So this is a script I knocked up to make sure Exchange is being backed up. It does it by querying the LastFullBackup attribute of an Exchange Database.
It groups servers by AD site, and I have this run as a scheduled task every day. It also send and email.
As a scheduled task I created a .cmd file with the following in it:
powershell c:\ps\Get-MSXBackupStatus.ps1
In addition to the script you will need Get-Bufferhtml.ps1 and send-mail.ps1Send-Mail.ps1 uses a file (c:\ps\emailAlertList1.txt) to send email to. This should be a text file, with the word "email" on the first line, followed by email addresses of people you want to send the email to.
[PS] C:\PS>.\Get-MSXBackupStatus.ps1 Transcript started, output file is c:\ps\Get-MSXBackupStatus.ps1.wri Get-MSXBackupStatus.ps1: v1.1 [12 Nov 2007] Run on MyDesktop at 02/06/2008 12:02:07 |-------------------------------------------------------------------| a.mydom.local/Configuration/Sites/SITE01 J01VA : 8 Mailbox Databases SG01-DB01-J01VA : LastFull: - OLD! SG02-DB01-J01VA : LastFull: - OLD! SG03-DB01-J01VA : LastFull: - OLD! SG04-DB01-J01VA : LastFull: - OLD! SG05-DB01-J01VA : LastFull: - OLD! SG06-DB01-J01VA : LastFull: - OLD! SG07-DB01-J01VA : LastFull: - OLD! SG08-DB01-J01VA : LastFull: - OLD! M01VA : 8 Mailbox Databases SG01-DB01-M01VA : LastFull:02/05/2008 22:04:30 - OK SG02-DB01-M01VA : LastFull:02/05/2008 22:34:19 - OK SG03-DB01-M01VA : LastFull:02/05/2008 23:04:04 - OK SG04-DB01-M01VA : LastFull:02/05/2008 23:34:21 - OK SG05-DB01-M01VA : LastFull:02/06/2008 00:04:11 - OK SG07-DB01-M01VA : LastFull:02/06/2008 01:04:14 - OK SG08-DB01-M01VA : LastFull:02/06/2008 01:34:07 - OK SG06-DB01-M01VA : LastFull:02/06/2008 00:34:06 - OK MBX01 : 2 Mailbox Databases SG01-DB01-MBX01 : LastFull:02/05/2008 21:03:18 - OK SG02-DB01-MBX01 : LastFull:02/05/2008 21:03:42 - OK MRS02 : 1 Mailbox Databases SG01-DB01-MRS02 : LastFull:02/05/2008 21:12:35 - OK MRS02 : 1 Public Folder Databases Public Folder Database : LastFull:02/05/2008 21:12:38 - OK a.mydom.local/Configuration/Sites/SITE01 - 19 Mailbox databases - 1 Public Folder Databases - 8 of them have FULL backups greater than 8 days old! ########################################################################## a.mydom.local/Configuration/Sites/SITE02 xMRS01 : 1 Mailbox Databases SG01-DB01-GIBPSMMSWMRS01 : LastFull: - OLD! xMRS02 : 1 Mailbox Databases SG01-DB01-GIBPSMMSWMRS02 : LastFull: - OLD! xMRS02 : 1 Public Folder Databases PUB01-xMRS02 : LastFull: - OLD! a.mydom.local/Configuration/Sites/SITE02 - 2 Mailbox databases - 1 Public Folder Databases - 3 of them have FULL backups greater than 8 days old! ##########################################################################
Business Email System Penetration Varies Greatly by Customer Size, Industry and More, says Ferris Research