Get-MSXBackupStatus.ps1

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:psGet-MSXBackupStatus.ps1

In addition to the script you will need Get-Bufferhtml.ps1 and send-mail.ps1

Send-Mail.ps1 uses a file (c:psemailAlertList1.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:psGet-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!                           ##########################################################################           

Leave a Reply

%d bloggers like this: