{"id":888,"date":"2018-02-12T17:00:10","date_gmt":"2018-02-12T17:00:10","guid":{"rendered":"http:\/\/virtualworlduk.co.uk\/?p=888"},"modified":"2018-02-12T17:00:10","modified_gmt":"2018-02-12T17:00:10","slug":"updated-veeam-weekly-backup-report-powershell-baw6","status":"publish","type":"post","link":"https:\/\/www.virtualworlduk.co.uk\/wordp\/updated-veeam-weekly-backup-report-powershell-baw6\/","title":{"rendered":"Updated Veeam Weekly Backup Report – Powershell (BAW6)"},"content":{"rendered":"

Back in 2015, I created a 3-day Backup Report for Veeam that was based on the\u00a0\u2018SysAdmin Modular Report\u2019 (SAMReport) – this is the link to the original post for that report:\u00a0\u00a0http:\/\/virtualworlduk.co.uk\/3-day-veeam-backup-report-powercli\/<\/a><\/p>\n

That report has been useful for a couple of years but I felt that I could do better, without having to link back to the vCenter server quite so much.\u00a0 After looking around at what other people were doing, I stumbled across the work that Shawn Masterson has been doing with his ‘Veeam v9 – My Veeam Report v9.5.3’ (https:\/\/blog.smasterson.com\/2017\/12\/22\/veeam-v9-my-veeam-report-9-5-3\/<\/a>) and I was then able to utilise some of his great work to create an updated version of my report as a full Weekly Backup Report.\u00a0 The comparison between my old report and my new report are shown below:<\/p>\n

\"\"<\/a><\/p>\n

Old Report<\/p>\n

 <\/p>\n

\"\"<\/p>\n

Updated Report<\/p>\n

As you can see from the screenshot, the look of the new report is more modern.\u00a0 This screenshot is taken from my lab environment with some forced failures.\u00a0 Backup failures are highlighted Red, VMs that end with a Warning status are highlighted Yellow and if a virtual machine has not been backed up at all (or is new), then you’ll see a blank next to the name on the days that it hasn’t been backed up.\u00a0 This means that it should be easier to identify if there are any issues.<\/p>\n

Other key items to be aware of with this, is that I am utilising Veeam 9.5 to run the report against, the report still needs to be run on the Veeam server itself but should run significantly quicker than previous reports, as it is just referencing the information in Veeam rather than connecting to vCenter.\u00a0 For my lab environment, I back up the virtual machines by datastore rather than adding individual backups to a job, this means that all of my virtual machines are automatically added to the backup jobs once a new virtual machine is created.\u00a0 It also means that my report should always include all of the virtual machines in the report.\u00a0 I am utilising Powershell version 5 on one of my systems but have also tested this utilising Powershell version 4.<\/p>\n

The code may still not be optimised as best as it could be and the report may be a bit rough and ready but it seems to work okay for me.<\/p>\n

The code listing is below:<\/p>\n

[powershell]<\/p>\n

If (!(Get-PSSnapin -Name VeeamPSSnapIn -ErrorAction SilentlyContinue)) {
\nIf (!(Add-PSSnapin -PassThru VeeamPSSnapIn)) {
\nWrite-Error "Unable to load Veeam snapin" -ForegroundColor Red
\nExit
\n}
\n}<\/p>\n

get-module -ListAvailable VM* | Import-Module<\/p>\n

$datetoday = [DateTime]::Today.ToString("ddd d MMM yyy")
\n$ReportDate = get-date -f yyyy-MM-dd<\/p>\n

$veeamExePath = "D:\\Program Files\\Veeam\\Backup and Replication\\Console\\Veeam.Backup.Shell.exe" # this should be the location of the Veeam.Backup.Shell.exe file
\n$veeamExe = Get-Item $veeamExePath<\/p>\n

$VeeamVersion = $veeamExe.VersionInfo.ProductVersion<\/p>\n

$emailTo = "Change This" # Email address that you wish to send the report to<\/p>\n

$smtpServerref = "Change This" # SMTP server name used for emailing<\/p>\n

$emailFrom = "Change This" # Email address that the report should come from<\/p>\n

$Outputlocation = "Change This" # this should be the directory and file name to save a copy of the report<\/p>\n

# HTML Stuff – this sets up the HTML report sections
\n$headerObj = @"
\n<!DOCTYPE html>
\n<html>
\n<head>
\n<title>"Veeam Backup Report – $datetoday<\/title>
\n<style>
\nbody {font-family: Tahoma; background-color:#ffffff;}
\ntable {font-family: Tahoma;width: $($rptWidth)%;font-size: 12px;border-collapse:collapse;}
\n<!– table tr:nth-child(odd) td {background: #e2e2e2;} –>
\nth {background-color: #e2e2e2;border: 1px solid #a7a9ac;border-bottom: none;}
\ntd {background-color: #ffffff;border: 1px solid #a7a9ac;padding: 2px 3px 2px 3px;}
\n<\/style>
\n<\/head>
\n"@<\/p>\n

$bodyTop = @"
\n<body>
\n<center><\/p>\n

<table>
\n<tr>
\n<td style="width: 100%;height: 12px;border: none;background-color: #143d63;color: White;font-size: 12px;vertical-align: bottom;text-align: right;padding: 0px 5px 0px 0px;"Report generated on $(Get-Date -format g)<\/td>
\n<\/tr>
\n<tr>
\n<td style="width: 100%;height: 24px;border: none;background-color: #ffffff;color: Black;font-size: 24px;vertical-align: bottom;text-align: center;padding: 0px 0px 0px 15px;">Veeam Backup Report – $datetoday<\/td><\/p>\n

<\/tr>
\n<tr>
\n<td style="width: 100%;height: 12px;border: none;background-color: #143d63;color: White;font-size: 12px;vertical-align: bottom;text-align: right;padding: 0px 5px 0px 0px;">Veeam Backup & Replication v$VeeamVersion<\/td>
\n<\/tr>
\n<tr>
\n<td style="width: 50%;height: 12px;border: none;background-color: ZZhdbgZZ;color: White;font-size: 12px;vertical-align: bottom;text-align: left;padding: 0px 0px 2px 5px;">$rptMode<\/td>
\n<td style="width: 50%;height: 12px;border: none;background-color: ZZhdbgZZ;color: White;font-size: 12px;vertical-align: bottom;text-align: right;padding: 0px 5px 2px 0px;">MVR v$MVRversion<\/td>
\n<\/tr>
\n<\/table>
\n"@<\/p>\n

$subHead01 = @"
\n<table>
\n<tr>
\n<td style="height: 35px;background-color: #f3f4f4;color: #626365;font-size: 16px;padding: 5px 0 0 15px;border-top: 5px solid white;border-bottom: none;">
\n"@<\/p>\n

$subHead01suc = @"
\n<table>
\n<tr>
\n<td style="height: 35px;background-color: #00b050;color: #ffffff;font-size: 16px;padding: 5px 0 0 15px;border-top: 5px solid white;border-bottom: none;">
\n"@<\/p>\n

$subHead01war = @"
\n<table>
\n<tr>
\n<td style="height: 35px;background-color: #ffd96c;color: #ffffff;font-size: 16px;padding: 5px 0 0 15px;border-top: 5px solid white;border-bottom: none;">
\n"@<\/p>\n

$subHead01err = @"
\n<table>
\n<tr>
\n<td style="height: 35px;background-color: #FB9895;color: #ffffff;font-size: 16px;padding: 5px 0 0 15px;border-top: 5px solid white;border-bottom: none;">
\n"@<\/p>\n

$subHead02 = @"
\n<\/td>
\n<\/tr>
\n<\/table>
\n"@<\/p>\n

$HTMLbreak = @"
\n<table>
\n<tr>
\n<td style="height: 10px;background-color: #626365;padding: 5px 0 0 15px;border-top: 5px solid white;border-bottom: none;"><\/td>
\n<\/tr>
\n<\/table>
\n"@<\/p>\n

$footerObj = @"
\n<table>
\n<tr>
\n<td style="height: 15px;background-color: #ffffff;border: none;color: #626365;font-size: 10px;text-align:center;<\/a><\/td>
\n<\/tr>
\n<\/table>
\n<\/center>
\n<\/body>
\n<\/html>
\n"@<\/p>\n

$BodySummHeader = @"
\n<table><\/p>\n

<tr>
\n<td style="height: 24px;border: none;background-color: #ffffff;color: Black;font-size: 15px;vertical-align: bottom;text-align: center;padding: 0px 0px 0px 15px;">Backups<\/td>
\n<\/tr>
\n<\/table><\/p>\n

"@<\/p>\n

$Signature = @"
\nChecked By:______________________________ Date:______________________________ Authorised:______________________________ Date:______________________________
\n"@<\/p>\n

$Result1= @{}
\n$Result2= @{}
\n$Result3= @{}
\n$Result4= @{}
\n$Result5= @{}
\n$Result6= @{}
\n$Result7= @{}
\n$Result8= @{}
\n$Result9= @{}<\/p>\n

#This sets up the number of days that will be removed from today for the report dates
\n$Day9=’-9′
\n$Day8=’-8′
\n$Day7=’-7′
\n$Day6=’-6′
\n$Day5=’-5′
\n$Day4=’-4′
\n$Day3=’-3′
\n$Day2=’-2′
\n$Day1=’-1′
\n$Day0=’0′<\/p>\n

#As the backups only run Monday – Saturday, there are longer backup windows over the weekend
\nif ([DateTime]::Today.AddDays($Day9).DayOfWeek -ne "Saturday" -or "Sunday") {
\n$StartDate1 = [DateTime]::Today.AddDays($Day9).AddHours(16)
\n$EndDate1 = [DateTime]::Today.AddDays($Day8).AddHours(16)
\n$Date1=[DateTime]::Today.AddDays($Day9).ToString("ddd d MMM yyy")
\n}
\nelseif ([DateTime]::Today.AddDays($Day9).DayOfWeek -eq "Saturday") {
\n$StartDate1 = [DateTime]::Today.AddDays($Day9).AddHours(16)
\n$EndDate1 = [DateTime]::Today.AddDays($Day7).AddHours(05)
\n$Date1=[DateTime]::Today.AddDays($Day9).ToString("ddd d MMM yyy")
\n}
\nelseif ([DateTime]::Today.AddDays($Day9).DayOfWeek -eq "Sunday") {
\n$Date1=[DateTime]::Today.AddDays($Day9).ToString("ddd d MMM yyy")
\n$StartDate1 = [DateTime]::Today.AddDays($Day0).AddHours(16)
\n$EndDate1 = [DateTime]::Today.AddDays($Day0).AddHours(16)
\n}<\/p>\n

if ([DateTime]::Today.AddDays($Day8).DayOfWeek -ne "Saturday" -or "Sunday") {
\n$StartDate2 = [DateTime]::Today.AddDays($Day8).AddHours(16)
\n$EndDate2 = [DateTime]::Today.AddDays($Day7).AddHours(16)
\n$Date2=[DateTime]::Today.AddDays($Day8).ToString("ddd d MMM yyy")
\n}
\nelseif ([DateTime]::Today.AddDays($Day8).DayOfWeek -eq "Saturday") {
\n$StartDate2 = [DateTime]::Today.AddDays($Day8).AddHours(16)
\n$EndDate2 = [DateTime]::Today.AddDays($Day6).AddHours(05)
\n$Date2=[DateTime]::Today.AddDays($Day8).ToString("ddd d MMM yyy")
\n}
\nelseif ([DateTime]::Today.AddDays($Day8).DayOfWeek -eq "Sunday") {
\n$Date2=[DateTime]::Today.AddDays($Day8).ToString("ddd d MMM yyy")
\n$StartDate2 = [DateTime]::Today.AddDays($Day0).AddHours(16)
\n$EndDate2 = [DateTime]::Today.AddDays($Day0).AddHours(16)
\n}<\/p>\n

if ([DateTime]::Today.AddDays($Day7).DayOfWeek -ne "Saturday" -or "Sunday") {
\n$StartDate3 = [DateTime]::Today.AddDays($Day7).AddHours(16)
\n$EndDate3 = [DateTime]::Today.AddDays($Day6).AddHours(16)
\n$Date3=[DateTime]::Today.AddDays($Day7).ToString("ddd d MMM yyy")
\n}
\nelseif ([DateTime]::Today.AddDays($Day7).DayOfWeek -eq "Saturday") {
\n$StartDate3 = [DateTime]::Today.AddDays($Day7).AddHours(16)
\n$EndDate3 = [DateTime]::Today.AddDays($Day5).AddHours(05)
\n$Date3=[DateTime]::Today.AddDays($Day7).ToString("ddd d MMM yyy")
\n}
\nelseif ([DateTime]::Today.AddDays($Day7).DayOfWeek -eq "Sunday") {
\n$Date3=[DateTime]::Today.AddDays($Day7).ToString("ddd d MMM yyy")
\n$StartDate3 = [DateTime]::Today.AddDays($Day0).AddHours(16)
\n$EndDate3 = [DateTime]::Today.AddDays($Day0).AddHours(16)
\n}<\/p>\n

if ([DateTime]::Today.AddDays($Day6).DayOfWeek -ne "Saturday" -or "Sunday") {
\n$StartDate4 = [DateTime]::Today.AddDays($Day6).AddHours(16)
\n$EndDate4 = [DateTime]::Today.AddDays($Day5).AddHours(16)
\n$Date4=[DateTime]::Today.AddDays($Day6).ToString("ddd d MMM yyy")
\n}
\nelseif ([DateTime]::Today.AddDays($Day6).DayOfWeek -eq "Saturday") {
\n$StartDate4 = [DateTime]::Today.AddDays($Day6).AddHours(16)
\n$EndDate4 = [DateTime]::Today.AddDays($Day4).AddHours(05)
\n$Date4=[DateTime]::Today.AddDays($Day6).ToString("ddd d MMM yyy")
\n}
\nelseif ([DateTime]::Today.AddDays($Day6).DayOfWeek -eq "Sunday") {
\n$Date4=[DateTime]::Today.AddDays($Day6).ToString("ddd d MMM yyy")
\n$StartDate4 = [DateTime]::Today.AddDays($Day0).AddHours(16)
\n$EndDate4 = [DateTime]::Today.AddDays($Day0).AddHours(16)
\n}<\/p>\n

if ([DateTime]::Today.AddDays($Day5).DayOfWeek -ne "Saturday" -or "Sunday") {
\n$StartDate5 = [DateTime]::Today.AddDays($Day5).AddHours(16)
\n$EndDate5 = [DateTime]::Today.AddDays($Day4).AddHours(16)
\n$Date5=[DateTime]::Today.AddDays($Day5).ToString("ddd d MMM yyy")
\n}
\nelseif ([DateTime]::Today.AddDays($Day5).DayOfWeek -eq "Saturday") {
\n$StartDate5 = [DateTime]::Today.AddDays($Day5).AddHours(16)
\n$EndDate5 = [DateTime]::Today.AddDays($Day3).AddHours(05)
\n$Date5=[DateTime]::Today.AddDays($Day5).ToString("ddd d MMM yyy")
\n}
\nelseif ([DateTime]::Today.AddDays($Day5).DayOfWeek -eq "Sunday") {
\n$Date5=[DateTime]::Today.AddDays($Day5).ToString("ddd d MMM yyy")
\n$StartDate5 = [DateTime]::Today.AddDays($Day0).AddHours(16)
\n$EndDate5 = [DateTime]::Today.AddDays($Day0).AddHours(16)
\n}<\/p>\n

if ([DateTime]::Today.AddDays($Day4).DayOfWeek -ne "Saturday" -or "Sunday") {
\n$StartDate6 = [DateTime]::Today.AddDays($Day4).AddHours(16)
\n$EndDate6 = [DateTime]::Today.AddDays($Day3).AddHours(16)
\n$Date6=[DateTime]::Today.AddDays($Day4).ToString("ddd d MMM yyy")
\n}
\nelseif ([DateTime]::Today.AddDays($Day4).DayOfWeek -eq "Saturday") {
\n$StartDate6 = [DateTime]::Today.AddDays($Day4).AddHours(16)
\n$EndDate6 = [DateTime]::Today.AddDays($Day2).AddHours(05)
\n$Date6=[DateTime]::Today.AddDays($Day4).ToString("ddd d MMM yyy")
\n}
\nelseif ([DateTime]::Today.AddDays($Day4).DayOfWeek -eq "Sunday") {
\n$Date6=[DateTime]::Today.AddDays($Day4).ToString("ddd d MMM yyy")
\n$StartDate6 = [DateTime]::Today.AddDays($Day0).AddHours(16)
\n$EndDate6 = [DateTime]::Today.AddDays($Day0).AddHours(16)
\n}<\/p>\n

if ([DateTime]::Today.AddDays($Day3).DayOfWeek -ne "Saturday" -or "Sunday") {
\n$StartDate7 = [DateTime]::Today.AddDays($Day3).AddHours(16)
\n$EndDate7 = [DateTime]::Today.AddDays($Day2).AddHours(16)
\n$Date7=[DateTime]::Today.AddDays($Day3).ToString("ddd d MMM yyy")
\n}
\nelseif ([DateTime]::Today.AddDays($Day3).DayOfWeek -eq "Saturday") {
\n$StartDate7 = [DateTime]::Today.AddDays($Day3).AddHours(16)
\n$EndDate7 = [DateTime]::Today.AddDays($Day1).AddHours(05)
\n$Date7=[DateTime]::Today.AddDays($Day3).ToString("ddd d MMM yyy")
\n}
\nelseif ([DateTime]::Today.AddDays($Day3).DayOfWeek -eq "Sunday") {
\n$Date7=[DateTime]::Today.AddDays($Day3).ToString("ddd d MMM yyy")
\n$StartDate7 = [DateTime]::Today.AddDays($Day0).AddHours(16)
\n$EndDate7 = [DateTime]::Today.AddDays($Day0).AddHours(16)
\n}<\/p>\n

if ([DateTime]::Today.AddDays($Day2).DayOfWeek -ne "Saturday" -or "Sunday") {
\n$StartDate8 = [DateTime]::Today.AddDays($Day2).AddHours(16)
\n$EndDate8 = [DateTime]::Today.AddDays($Day1).AddHours(16)
\n$Date8=[DateTime]::Today.AddDays($Day2).ToString("ddd d MMM yyy")
\n}
\nelseif ([DateTime]::Today.AddDays($Day2).DayOfWeek -eq "Saturday") {
\n$StartDate8 = [DateTime]::Today.AddDays($Day2).AddHours(16)
\n$EndDate8 = [DateTime]::Today.AddDays($Day0).AddHours(05)
\n$Date8=[DateTime]::Today.AddDays($Day2).ToString("ddd d MMM yyy")
\n}
\nelseif ([DateTime]::Today.AddDays($Day2).DayOfWeek -eq "Sunday") {
\n$Date8=[DateTime]::Today.AddDays($Day2).ToString("ddd d MMM yyy")
\n$StartDate8 = [DateTime]::Today.AddDays($Day0).AddHours(16)
\n$EndDate8 = [DateTime]::Today.AddDays($Day0).AddHours(16)
\n}<\/p>\n

if ([DateTime]::Today.AddDays($Day1).DayOfWeek -ne "Saturday" -or "Sunday") {
\n$StartDate9 = [DateTime]::Today.AddDays($Day1).AddHours(16)
\n$EndDate9 = [DateTime]::Today.AddDays($Day0).AddHours(16)
\n$Date9=[DateTime]::Today.AddDays($Day1).ToString("ddd d MMM yyy")
\n}
\nelseif ([DateTime]::Today.AddDays($Day1).DayOfWeek -eq "Saturday") {
\n$StartDate9 = [DateTime]::Today.AddDays($Day1).AddHours(16)
\n$EndDate9 = [DateTime]::Today.AddDays($Day0).AddHours(23)
\n$Date9=[DateTime]::Today.AddDays($Day1).ToString("ddd d MMM yyy")
\n}
\nelseif ([DateTime]::Today.AddDays($Day1).DayOfWeek -eq "Sunday") {
\n$Date9=[DateTime]::Today.AddDays($Day1).ToString("ddd d MMM yyy")
\n$StartDate9 = [DateTime]::Today.AddDays($Day0).AddHours(16)
\n$EndDate9 = [DateTime]::Today.AddDays($Day0).AddHours(16)
\n}<\/p>\n

# This checks the backups for the virtual machines on the various dates and keeps the results for later
\n$BackupSessions1 = Get-VBRBackupSession | where {(($_.JobType -eq "Backup") -and ($_.CreationTime -ge $StartDate1) -and ($_.CreationTime -le $EndDate1))} | Sort JobName, CreationTime
\n$Result1 = & {
\nForEach ($BackupSession1 in ($BackupSessions1 | ?{$_.IsRetryMode -eq $false})) {
\n[System.Collections.ArrayList]$TaskSessions1 = @($BackupSession1 | Get-VBRTaskSession)
\nIf ($BackupSession1.Result -eq "Failed") {
\n$RetrySessions1 = $BackupSessions1 | ?{($_.IsRetryMode -eq $true) -and ($_.OriginalSessionId -eq $BackupSession1.Id)}
\nForEach ($RetrySession1 in $RetrySessions1) {
\n[System.Collections.ArrayList]$RetryTaskSessions1 = @($RetrySession1 | Get-VBRTaskSession)
\nForEach ($RetryTaskSession1 in $RetryTaskSessions1) {
\n$PriorTaskSession1 = $TaskSessions1 | ?{$_.Name -eq $RetryTaskSession1.Name}
\nIf ($PriorTaskSession1) { $TaskSessions1.Remove($PriorTaskSession1) }
\n$TaskSessions1.Add($RetryTaskSession1) | Out-Null
\n}
\n}
\n}
\n$TaskSessions1 | Select @{N="JobName";E={$BackupSession1.JobName}},@{N="SessionName";E={$_.JobSess.Name}},@{N="JobResult";E={$_.JobSess.Result}},@{N="JobStart1";E={$_.JobSess.CreationTime}},@{N="JobEnd";E={$_.JobSess.EndTime}},@{N="Date";E={$_.JobSess.CreationTime.ToString("yyyy-MM-dd")}},name,@{N="Backup1";E={$_.Status}}<\/p>\n

}
\n}<\/p>\n

$BackupSessions2 = Get-VBRBackupSession | where {(($_.JobType -eq "Backup") -and ($_.CreationTime -ge $StartDate2) -and ($_.CreationTime -le $EndDate2))} | Sort JobName, CreationTime<\/p>\n

$Result2 = & {
\nForEach ($BackupSession2 in ($BackupSessions2 | ?{$_.IsRetryMode -eq $false})) {
\n[System.Collections.ArrayList]$TaskSessions2 = @($BackupSession2 | Get-VBRTaskSession)
\nIf ($BackupSession2.Result -eq "Failed") {
\n$RetrySessions2 = $BackupSessions2 | ?{($_.IsRetryMode -eq $true) -and ($_.OriginalSessionId -eq $BackupSession2.Id)}
\nForEach ($RetrySession2 in $RetrySessions2) {
\n[System.Collections.ArrayList]$RetryTaskSessions2 = @($RetrySession2 | Get-VBRTaskSession)
\nForEach ($RetryTaskSession2 in $RetryTaskSessions2) {
\n$PriorTaskSession2 = $TaskSessions2 | ?{$_.Name -eq $RetryTaskSession2.Name}
\nIf ($PriorTaskSession2) { $TaskSessions2.Remove($PriorTaskSession2) }
\n$TaskSessions2.Add($RetryTaskSession2) | Out-Null
\n}
\n}
\n}
\n$TaskSessions2 | Select @{N="JobName";E={$BackupSession2.JobName}},@{N="SessionName";E={$_.JobSess.Name}},@{N="JobResult";E={$_.JobSess.Result}},@{N="JobStart2";E={$_.JobSess.CreationTime}},@{N="JobEnd";E={$_.JobSess.EndTime}},@{N="Date";E={$_.JobSess.CreationTime.ToString("yyyy-MM-dd")}},name,@{N="Backup2";E={$_.Status}}#,status
\n}
\n}<\/p>\n

$BackupSessions3 = Get-VBRBackupSession | where {(($_.JobType -eq "Backup") -and ($_.CreationTime -ge $StartDate3) -and ($_.CreationTime -le $EndDate3))} | Sort JobName, CreationTime<\/p>\n

$Result3 = & {
\nForEach ($BackupSession3 in ($BackupSessions3 | ?{{-not [string]::IsNullOrEmpty($_)} -and $_.IsRetryMode -eq $false})) {
\n[System.Collections.ArrayList]$TaskSessions3 = @($BackupSession3 | Get-VBRTaskSession)
\nIf ($BackupSession3.Result -eq "Failed") {
\n$RetrySessions3 = $BackupSessions3 | ?{($_.IsRetryMode -eq $true) -and ($_.OriginalSessionId -eq $BackupSession3.Id) }
\nForEach ($RetrySession3 in $RetrySessions3) {
\n[System.Collections.ArrayList]$RetryTaskSessions3 = @($RetrySession3 | Get-VBRTaskSession)
\nForEach ($RetryTaskSession3 in $RetryTaskSessions3) {
\n$PriorTaskSession3 = $TaskSessions3 | ?{$_.Name -eq $RetryTaskSession3.Name}
\nIf ($PriorTaskSession3) { $TaskSessions3.Remove($PriorTaskSession3) }
\n$TaskSessions3.Add($RetryTaskSession3) | Out-Null
\n}
\n}
\n}
\n$TaskSessions3 | Select @{N="JobName3";E={$BackupSession3.JobName}},@{N="SessionName3";E={$_.JobSess.Name}},@{N="JobResult3";E={$_.JobSess.Result}},@{N="JobStart3";E={$_.JobSess.CreationTime}},@{N="JobEnd3";E={$_.JobSess.EndTime}},@{N="Date3";E={$_.JobSess.CreationTime.ToString("yyyy-MM-dd")}},name,@{N="Backup3";E={$_.Status}}#,status
\n}
\n}<\/p>\n

$BackupSessions4 = Get-VBRBackupSession | where {(($_.JobType -eq "Backup") -and ($_.CreationTime -ge $StartDate4) -and ($_.CreationTime -le $EndDate4))} | Sort JobName, CreationTime<\/p>\n

$Result4 = & {
\nForEach ($BackupSession4 in ($BackupSessions4 | ?{{-not [string]::IsNullOrEmpty($_)} -and $_.IsRetryMode -eq $false})) {
\n[System.Collections.ArrayList]$TaskSessions4 = @($BackupSession4 | Get-VBRTaskSession)
\nIf ($BackupSession4.Result -eq "Failed") {
\n$RetrySessions4 = $BackupSessions4 | ?{($_.IsRetryMode -eq $true) -and ($_.OriginalSessionId -eq $BackupSession4.Id) }
\nForEach ($RetrySession4 in $RetrySessions4) {
\n[System.Collections.ArrayList]$RetryTaskSessions4 = @($RetrySession4 | Get-VBRTaskSession)
\nForEach ($RetryTaskSession4 in $RetryTaskSessions4) {
\n$PriorTaskSession4 = $TaskSessions4 | ?{$_.Name -eq $RetryTaskSession4.Name}
\nIf ($PriorTaskSession4) { $TaskSessions4.Remove($PriorTaskSession4) }
\n$TaskSessions4.Add($RetryTaskSession4) | Out-Null
\n}
\n}
\n}
\n$TaskSessions4 | Select @{N="JobName4";E={$BackupSession4.JobName}},@{N="SessionName4";E={$_.JobSess.Name}},@{N="JobResult4";E={$_.JobSess.Result}},@{N="JobStart4";E={$_.JobSess.CreationTime}},@{N="JobEnd4";E={$_.JobSess.EndTime}},@{N="Date4";E={$_.JobSess.CreationTime.ToString("yyyy-MM-dd")}},name,@{N="Backup4";E={$_.Status}}#,status
\n}
\n}<\/p>\n

$BackupSessions5 = Get-VBRBackupSession | where {(($_.JobType -eq "Backup") -and ($_.CreationTime -ge $StartDate5) -and ($_.CreationTime -le $EndDate5))} | Sort JobName, CreationTime<\/p>\n

$Result5 = & {
\nForEach ($BackupSession5 in ($BackupSessions5 | ?{{-not [string]::IsNullOrEmpty($_)} -and $_.IsRetryMode -eq $false})) {
\n[System.Collections.ArrayList]$TaskSessions5 = @($BackupSession5 | Get-VBRTaskSession)
\nIf ($BackupSession5.Result -eq "Failed") {
\n$RetrySessions5 = $BackupSessions5 | ?{($_.IsRetryMode -eq $true) -and ($_.OriginalSessionId -eq $BackupSession5.Id) }
\nForEach ($RetrySession5 in $RetrySessions5) {
\n[System.Collections.ArrayList]$RetryTaskSessions5 = @($RetrySession5 | Get-VBRTaskSession)
\nForEach ($RetryTaskSession5 in $RetryTaskSessions5) {
\n$PriorTaskSession5 = $TaskSessions5 | ?{$_.Name -eq $RetryTaskSession5.Name}
\nIf ($PriorTaskSession5) { $TaskSessions5.Remove($PriorTaskSession5) }
\n$TaskSessions5.Add($RetryTaskSession5) | Out-Null
\n}
\n}
\n}
\n$TaskSessions5 | Select @{N="JobName5";E={$BackupSession5.JobName}},@{N="SessionName5";E={$_.JobSess.Name}},@{N="JobResult5";E={$_.JobSess.Result}},@{N="JobStart5";E={$_.JobSess.CreationTime}},@{N="JobEnd5";E={$_.JobSess.EndTime}},@{N="Date5";E={$_.JobSess.CreationTime.ToString("yyyy-MM-dd")}},name,@{N="Backup5";E={$_.Status}}#,status
\n}
\n}<\/p>\n

$BackupSessions6 = Get-VBRBackupSession | where {(($_.JobType -eq "Backup") -and ($_.CreationTime -ge $StartDate6) -and ($_.CreationTime -le $EndDate6))} | Sort JobName, CreationTime<\/p>\n

$Result6 = & {
\nForEach ($BackupSession6 in ($BackupSessions6 | ?{{-not [string]::IsNullOrEmpty($_)} -and $_.IsRetryMode -eq $false})) {
\n[System.Collections.ArrayList]$TaskSessions6 = @($BackupSession6 | Get-VBRTaskSession)
\nIf ($BackupSession6.Result -eq "Failed") {
\n$RetrySessions6 = $BackupSessions6 | ?{($_.IsRetryMode -eq $true) -and ($_.OriginalSessionId -eq $BackupSession6.Id) }
\nForEach ($RetrySession6 in $RetrySessions6) {
\n[System.Collections.ArrayList]$RetryTaskSessions6 = @($RetrySession6 | Get-VBRTaskSession)
\nForEach ($RetryTaskSession6 in $RetryTaskSessions6) {
\n$PriorTaskSession6 = $TaskSessions6 | ?{$_.Name -eq $RetryTaskSession6.Name}
\nIf ($PriorTaskSession6) { $TaskSessions6.Remove($PriorTaskSession6) }
\n$TaskSessions6.Add($RetryTaskSession6) | Out-Null
\n}
\n}
\n}
\n$TaskSessions6 | Select @{N="JobName6";E={$BackupSession6.JobName}},@{N="SessionName6";E={$_.JobSess.Name}},@{N="JobResult6";E={$_.JobSess.Result}},@{N="JobStart6";E={$_.JobSess.CreationTime}},@{N="JobEnd6";E={$_.JobSess.EndTime}},@{N="Date6";E={$_.JobSess.CreationTime.ToString("yyyy-MM-dd")}},name,@{N="Backup6";E={$_.Status}}#,status
\n}
\n}<\/p>\n

$BackupSessions7 = Get-VBRBackupSession | where {(($_.JobType -eq "Backup") -and ($_.CreationTime -ge $StartDate7) -and ($_.CreationTime -le $EndDate7))} | Sort JobName, CreationTime<\/p>\n

$Result7 = & {
\nForEach ($BackupSession7 in ($BackupSessions7 | ?{{-not [string]::IsNullOrEmpty($_)} -and $_.IsRetryMode -eq $false})) {
\n[System.Collections.ArrayList]$TaskSessions7 = @($BackupSession7 | Get-VBRTaskSession)
\nIf ($BackupSession7.Result -eq "Failed") {
\n$RetrySessions7 = $BackupSessions7 | ?{($_.IsRetryMode -eq $true) -and ($_.OriginalSessionId -eq $BackupSession7.Id) }
\nForEach ($RetrySession7 in $RetrySessions7) {
\n[System.Collections.ArrayList]$RetryTaskSessions7 = @($RetrySession7 | Get-VBRTaskSession)
\nForEach ($RetryTaskSession7 in $RetryTaskSessions7) {
\n$PriorTaskSession7 = $TaskSessions7 | ?{$_.Name -eq $RetryTaskSession7.Name}
\nIf ($PriorTaskSession7) { $TaskSessions7.Remove($PriorTaskSession7) }
\n$TaskSessions7.Add($RetryTaskSession7) | Out-Null
\n}
\n}
\n}
\n$TaskSessions7 | Select @{N="JobName7";E={$BackupSession7.JobName}},@{N="SessionName7";E={$_.JobSess.Name}},@{N="JobResult7";E={$_.JobSess.Result}},@{N="JobStart7";E={$_.JobSess.CreationTime}},@{N="JobEnd7";E={$_.JobSess.EndTime}},@{N="Date7";E={$_.JobSess.CreationTime.ToString("yyyy-MM-dd")}},name,@{N="Backup7";E={$_.Status}}#,status
\n}
\n}<\/p>\n

$BackupSessions8 = Get-VBRBackupSession | where {(($_.JobType -eq "Backup") -and ($_.CreationTime -ge $StartDate8) -and ($_.CreationTime -le $EndDate8))} | Sort JobName, CreationTime<\/p>\n

$Result8 = & {
\nForEach ($BackupSession8 in ($BackupSessions8 | ?{{-not [string]::IsNullOrEmpty($_)} -and $_.IsRetryMode -eq $false})) {
\n[System.Collections.ArrayList]$TaskSessions8 = @($BackupSession8 | Get-VBRTaskSession)
\nIf ($BackupSession8.Result -eq "Failed") {
\n$RetrySessions8 = $BackupSessions8 | ?{($_.IsRetryMode -eq $true) -and ($_.OriginalSessionId -eq $BackupSession8.Id) }
\nForEach ($RetrySession8 in $RetrySessions8) {
\n[System.Collections.ArrayList]$RetryTaskSessions8 = @($RetrySession8 | Get-VBRTaskSession)
\nForEach ($RetryTaskSession8 in $RetryTaskSessions8) {
\n$PriorTaskSession8 = $TaskSessions8 | ?{$_.Name -eq $RetryTaskSession8.Name}
\nIf ($PriorTaskSession8) { $TaskSessions8.Remove($PriorTaskSession8) }
\n$TaskSessions8.Add($RetryTaskSession8) | Out-Null
\n}
\n}
\n}
\n$TaskSessions8 | Select @{N="JobName8";E={$BackupSession8.JobName}},@{N="SessionName8";E={$_.JobSess.Name}},@{N="JobResult8";E={$_.JobSess.Result}},@{N="JobStart8";E={$_.JobSess.CreationTime}},@{N="JobEnd8";E={$_.JobSess.EndTime}},@{N="Date8";E={$_.JobSess.CreationTime.ToString("yyyy-MM-dd")}},name,@{N="Backup8";E={$_.Status}}#,status
\n}
\n}<\/p>\n

$BackupSessions9 = Get-VBRBackupSession | where {(($_.JobType -eq "Backup") -and ($_.CreationTime -ge $StartDate9) -and ($_.CreationTime -le $EndDate9))} | Sort JobName, CreationTime<\/p>\n

$Result9 = & {
\nForEach ($BackupSession9 in ($BackupSessions9 | ?{{-not [string]::IsNullOrEmpty($_)} -and $_.IsRetryMode -eq $false})) {
\n[System.Collections.ArrayList]$TaskSessions9 = @($BackupSession9 | Get-VBRTaskSession)
\nIf ($BackupSession9.Result -eq "Failed") {
\n$RetrySessions9 = $BackupSessions9 | ?{($_.IsRetryMode -eq $true) -and ($_.OriginalSessionId -eq $BackupSession9.Id) }
\nForEach ($RetrySession9 in $RetrySessions9) {
\n[System.Collections.ArrayList]$RetryTaskSessions9 = @($RetrySession9 | Get-VBRTaskSession)
\nForEach ($RetryTaskSession9 in $RetryTaskSessions9) {
\n$PriorTaskSession9 = $TaskSessions9 | ?{$_.Name -eq $RetryTaskSession9.Name}
\nIf ($PriorTaskSession9) { $TaskSessions9.Remove($PriorTaskSession9) }
\n$TaskSessions9.Add($RetryTaskSession9) | Out-Null
\n}
\n}
\n}
\n$TaskSessions9 | Select @{N="JobName9";E={$BackupSession9.JobName}},@{N="SessionName9";E={$_.JobSess.Name}},@{N="JobResult9";E={$_.JobSess.Result}},@{N="JobStart9";E={$_.JobSess.CreationTime}},@{N="JobEnd9";E={$_.JobSess.EndTime}},@{N="Date9";E={$_.JobSess.CreationTime.ToString("yyyy-MM-dd")}},name,@{N="Backup9";E={$_.Status}}#,status
\n}
\n}<\/p>\n

$EndResult = $Result1+$Result2+$Result3+$Result4+$Result5+$Result6+$Result7+$Result8+$Result9<\/p>\n

#This now references through the results to find the relevant result for each VM on each day
\n#It will check whether the backup date is a Sunday and exclude those days, and also change the column name of the Saturday
\n#before to show ‘Weekend of ‘ instead of just the date
\nif ([DateTime]::Today.AddDays($Day8).DayOfWeek -eq "Sunday") {
\nWrite-Host "Combined"
\n$bodySummaryRp = $EndResult | Group Name | ForEach {
\nNew-Object PSObject -Property @{
\nName = $_.Name
\nBackup1 = if ($_.Group[0].Backup1 -ne $null) {
\n($_.Group[0].Backup1)}
\nelseif ($_.Group[1].Backup1 -ne $null) {
\n($_.Group[1].Backup1)}
\nelseif ($_.Group[2].Backup1 -ne $null) {
\n($_.Group[2].Backup1)}
\nelseif ($_.Group[3].Backup1 -ne $null) {
\n($_.Group[3].Backup1)}
\nelseif ($_.Group[4].Backup1 -ne $null) {
\n($_.Group[4].Backup1)}
\nelseif ($_.Group[5].Backup1 -ne $null) {
\n($_.Group[5].Backup1)}
\nelseif ($_.Group[6].Backup1 -ne $null) {
\n($_.Group[6].Backup1)}
\nelseif ($_.Group[7].Backup1 -ne $null) {
\n($_.Group[7].Backup1)}
\nelseif ($_.Group[8].Backup1 -ne $null) {
\n($_.Group[8].Backup1)}
\nelseif ($_.Group[9].Backup1 -ne $null) {
\n($_.Group[9].Backup1)}
\nelseif ($_.Group[10].Backup1 -ne $null) {
\n($_.Group[10].Backup1)};
\nBackup3 = if ($_.Group[0].Backup3 -ne $null) {
\n($_.Group[0].Backup3)}
\nelseif ($_.Group[1].Backup3 -ne $null) {
\n($_.Group[1].Backup3)}
\nelseif ($_.Group[2].Backup3 -ne $null) {
\n($_.Group[2].Backup3)}
\nelseif ($_.Group[3].Backup3 -ne $null) {
\n($_.Group[3].Backup3)}
\nelseif ($_.Group[4].Backup3 -ne $null) {
\n($_.Group[4].Backup3)}
\nelseif ($_.Group[5].Backup3 -ne $null) {
\n($_.Group[5].Backup3)}
\nelseif ($_.Group[6].Backup3 -ne $null) {
\n($_.Group[6].Backup3)}
\nelseif ($_.Group[7].Backup3 -ne $null) {
\n($_.Group[7].Backup3)}
\nelseif ($_.Group[8].Backup3 -ne $null) {
\n($_.Group[8].Backup3)}
\nelseif ($_.Group[9].Backup3 -ne $null) {
\n($_.Group[9].Backup3)}
\nelseif ($_.Group[10].Backup3 -ne $null) {
\n($_.Group[10].Backup3)};
\nBackup4 = if ($_.Group[0].Backup4 -ne $null) {
\n($_.Group[0].Backup4)}
\nelseif ($_.Group[1].Backup4 -ne $null) {
\n($_.Group[1].Backup4)}
\nelseif ($_.Group[2].Backup4 -ne $null) {
\n($_.Group[2].Backup4)}
\nelseif ($_.Group[3].Backup4 -ne $null) {
\n($_.Group[3].Backup4)}
\nelseif ($_.Group[4].Backup4 -ne $null) {
\n($_.Group[4].Backup4)}
\nelseif ($_.Group[5].Backup4 -ne $null) {
\n($_.Group[5].Backup4)}
\nelseif ($_.Group[6].Backup4 -ne $null) {
\n($_.Group[6].Backup4)}
\nelseif ($_.Group[7].Backup4 -ne $null) {
\n($_.Group[7].Backup4)}
\nelseif ($_.Group[8].Backup4 -ne $null) {
\n($_.Group[8].Backup4)}
\nelseif ($_.Group[9].Backup4 -ne $null) {
\n($_.Group[9].Backup4)}
\nelseif ($_.Group[10].Backup4 -ne $null) {
\n($_.Group[10].Backup4)};
\nBackup5 = if ($_.Group[0].Backup5 -ne $null) {
\n($_.Group[0].Backup5)}
\nelseif ($_.Group[1].Backup5 -ne $null) {
\n($_.Group[1].Backup5)}
\nelseif ($_.Group[2].Backup5 -ne $null) {
\n($_.Group[2].Backup5)}
\nelseif ($_.Group[3].Backup5 -ne $null) {
\n($_.Group[3].Backup5)}
\nelseif ($_.Group[4].Backup5 -ne $null) {
\n($_.Group[4].Backup5)}
\nelseif ($_.Group[5].Backup5 -ne $null) {
\n($_.Group[5].Backup5)}
\nelseif ($_.Group[6].Backup5 -ne $null) {
\n($_.Group[6].Backup5)}
\nelseif ($_.Group[7].Backup5 -ne $null) {
\n($_.Group[7].Backup5)}
\nelseif ($_.Group[8].Backup5 -ne $null) {
\n($_.Group[8].Backup5)}
\nelseif ($_.Group[9].Backup5 -ne $null) {
\n($_.Group[9].Backup5)}
\nelseif ($_.Group[10].Backup5 -ne $null) {
\n($_.Group[10].Backup5)};
\nBackup6 = if ($_.Group[0].Backup6 -ne $null) {
\n($_.Group[0].Backup6)}
\nelseif ($_.Group[1].Backup6 -ne $null) {
\n($_.Group[1].Backup6)}
\nelseif ($_.Group[2].Backup6 -ne $null) {
\n($_.Group[2].Backup6)}
\nelseif ($_.Group[3].Backup6 -ne $null) {
\n($_.Group[3].Backup6)}
\nelseif ($_.Group[4].Backup6 -ne $null) {
\n($_.Group[4].Backup6)}
\nelseif ($_.Group[5].Backup6 -ne $null) {
\n($_.Group[5].Backup6)}
\nelseif ($_.Group[6].Backup6 -ne $null) {
\n($_.Group[6].Backup6)}
\nelseif ($_.Group[7].Backup6 -ne $null) {
\n($_.Group[7].Backup6)}
\nelseif ($_.Group[8].Backup6 -ne $null) {
\n($_.Group[8].Backup6)}
\nelseif ($_.Group[9].Backup6 -ne $null) {
\n($_.Group[9].Backup6)}
\nelseif ($_.Group[10].Backup6 -ne $null) {
\n($_.Group[10].Backup6)};
\nBackup7 = if ($_.Group[0].Backup7 -ne $null) {
\n($_.Group[0].Backup7)}
\nelseif ($_.Group[1].Backup7 -ne $null) {
\n($_.Group[1].Backup7)}
\nelseif ($_.Group[2].Backup7 -ne $null) {
\n($_.Group[2].Backup7)}
\nelseif ($_.Group[3].Backup7 -ne $null) {
\n($_.Group[3].Backup7)}
\nelseif ($_.Group[4].Backup7 -ne $null) {
\n($_.Group[4].Backup7)}
\nelseif ($_.Group[5].Backup7 -ne $null) {
\n($_.Group[5].Backup7)}
\nelseif ($_.Group[6].Backup7 -ne $null) {
\n($_.Group[6].Backup7)}
\nelseif ($_.Group[7].Backup7 -ne $null) {
\n($_.Group[7].Backup7)}
\nelseif ($_.Group[8].Backup7 -ne $null) {
\n($_.Group[8].Backup7)}
\nelseif ($_.Group[9].Backup7 -ne $null) {
\n($_.Group[9].Backup7)}
\nelseif ($_.Group[10].Backup7 -ne $null) {
\n($_.Group[10].Backup7)};
\nBackup8 = if ($_.Group[0].Backup8 -ne $null) {
\n($_.Group[0].Backup8)}
\nelseif ($_.Group[1].Backup8 -ne $null) {
\n($_.Group[1].Backup8)}
\nelseif ($_.Group[2].Backup8 -ne $null) {
\n($_.Group[2].Backup8)}
\nelseif ($_.Group[3].Backup8 -ne $null) {
\n($_.Group[3].Backup8)}
\nelseif ($_.Group[4].Backup8 -ne $null) {
\n($_.Group[4].Backup8)}
\nelseif ($_.Group[5].Backup8 -ne $null) {
\n($_.Group[5].Backup8)}
\nelseif ($_.Group[6].Backup8 -ne $null) {
\n($_.Group[6].Backup8)}
\nelseif ($_.Group[7].Backup8 -ne $null) {
\n($_.Group[7].Backup8)}
\nelseif ($_.Group[8].Backup8 -ne $null) {
\n($_.Group[8].Backup8)}
\nelseif ($_.Group[9].Backup8 -ne $null) {
\n($_.Group[9].Backup8)}
\nelseif ($_.Group[10].Backup8 -ne $null) {
\n($_.Group[10].Backup8)};
\n}
\n} | select Name,@{N="Weekend of $Date1";E={$_.Backup1}},@{N="$Date3";E={$_.Backup3}},@{N="$Date4";E={$_.Backup4}},@{N="$Date5";E={$_.Backup5}},@{N="$Date6";E={$_.Backup6}},@{N="$Date7";E={$_.Backup7}},@{N="Weekend of $Date8";E={$_.Backup8}}| Sort Name | ConvertTo-Html -Fragment
\n} elseif ([DateTime]::Today.AddDays($Day7).DayOfWeek -eq "Sunday") {
\nWrite-Host "Combined"
\n$ColumnDate = ‘Weekend of ‘ + $Date1
\n$bodySummaryRp = $EndResult | Group Name | ForEach {
\nNew-Object PSObject -Property @{
\nName = $_.Name
\nBackup2 = if ($_.Group[0].Backup2 -ne $null) {
\n($_.Group[0].Backup2)}
\nelseif ($_.Group[1].Backup2 -ne $null) {
\n($_.Group[1].Backup2)}
\nelseif ($_.Group[2].Backup2 -ne $null) {
\n($_.Group[2].Backup2)}
\nelseif ($_.Group[3].Backup2 -ne $null) {
\n($_.Group[3].Backup2)}
\nelseif ($_.Group[4].Backup2 -ne $null) {
\n($_.Group[4].Backup2)}
\nelseif ($_.Group[5].Backup2 -ne $null) {
\n($_.Group[5].Backup2)}
\nelseif ($_.Group[6].Backup2 -ne $null) {
\n($_.Group[6].Backup2)}
\nelseif ($_.Group[7].Backup2 -ne $null) {
\n($_.Group[7].Backup2)}
\nelseif ($_.Group[8].Backup2 -ne $null) {
\n($_.Group[8].Backup2)}
\nelseif ($_.Group[9].Backup2 -ne $null) {
\n($_.Group[9].Backup2)}
\nelseif ($_.Group[10].Backup2 -ne $null) {
\n($_.Group[10].Backup2)};<\/p>\n

Backup4 = if ($_.Group[0].Backup4 -ne $null) {
\n($_.Group[0].Backup4)}
\nelseif ($_.Group[1].Backup4 -ne $null) {
\n($_.Group[1].Backup4)}
\nelseif ($_.Group[2].Backup4 -ne $null) {
\n($_.Group[2].Backup4)}
\nelseif ($_.Group[3].Backup4 -ne $null) {
\n($_.Group[3].Backup4)}
\nelseif ($_.Group[4].Backup4 -ne $null) {
\n($_.Group[4].Backup4)}
\nelseif ($_.Group[5].Backup4 -ne $null) {
\n($_.Group[5].Backup4)}
\nelseif ($_.Group[6].Backup4 -ne $null) {
\n($_.Group[6].Backup4)}
\nelseif ($_.Group[7].Backup4 -ne $null) {
\n($_.Group[7].Backup4)}
\nelseif ($_.Group[8].Backup4 -ne $null) {
\n($_.Group[8].Backup4)}
\nelseif ($_.Group[9].Backup4 -ne $null) {
\n($_.Group[9].Backup4)}
\nelseif ($_.Group[10].Backup4 -ne $null) {
\n($_.Group[10].Backup4)};
\nBackup5 = if ($_.Group[0].Backup5 -ne $null) {
\n($_.Group[0].Backup5)}
\nelseif ($_.Group[1].Backup5 -ne $null) {
\n($_.Group[1].Backup5)}
\nelseif ($_.Group[2].Backup5 -ne $null) {
\n($_.Group[2].Backup5)}
\nelseif ($_.Group[3].Backup5 -ne $null) {
\n($_.Group[3].Backup5)}
\nelseif ($_.Group[4].Backup5 -ne $null) {
\n($_.Group[4].Backup5)}
\nelseif ($_.Group[5].Backup5 -ne $null) {
\n($_.Group[5].Backup5)}
\nelseif ($_.Group[6].Backup5 -ne $null) {
\n($_.Group[6].Backup5)}
\nelseif ($_.Group[7].Backup5 -ne $null) {
\n($_.Group[7].Backup5)}
\nelseif ($_.Group[8].Backup5 -ne $null) {
\n($_.Group[8].Backup5)}
\nelseif ($_.Group[9].Backup5 -ne $null) {
\n($_.Group[9].Backup5)}
\nelseif ($_.Group[10].Backup5 -ne $null) {
\n($_.Group[10].Backup5)};
\nBackup6 = if ($_.Group[0].Backup6 -ne $null) {
\n($_.Group[0].Backup6)}
\nelseif ($_.Group[1].Backup6 -ne $null) {
\n($_.Group[1].Backup6)}
\nelseif ($_.Group[2].Backup6 -ne $null) {
\n($_.Group[2].Backup6)}
\nelseif ($_.Group[3].Backup6 -ne $null) {
\n($_.Group[3].Backup6)}
\nelseif ($_.Group[4].Backup6 -ne $null) {
\n($_.Group[4].Backup6)}
\nelseif ($_.Group[5].Backup6 -ne $null) {
\n($_.Group[5].Backup6)}
\nelseif ($_.Group[6].Backup6 -ne $null) {
\n($_.Group[6].Backup6)}
\nelseif ($_.Group[7].Backup6 -ne $null) {
\n($_.Group[7].Backup6)}
\nelseif ($_.Group[8].Backup6 -ne $null) {
\n($_.Group[8].Backup6)}
\nelseif ($_.Group[9].Backup6 -ne $null) {
\n($_.Group[9].Backup6)}
\nelseif ($_.Group[10].Backup6 -ne $null) {
\n($_.Group[10].Backup6)};
\nBackup7 = if ($_.Group[0].Backup7 -ne $null) {
\n($_.Group[0].Backup7)}
\nelseif ($_.Group[1].Backup7 -ne $null) {
\n($_.Group[1].Backup7)}
\nelseif ($_.Group[2].Backup7 -ne $null) {
\n($_.Group[2].Backup7)}
\nelseif ($_.Group[3].Backup7 -ne $null) {
\n($_.Group[3].Backup7)}
\nelseif ($_.Group[4].Backup7 -ne $null) {
\n($_.Group[4].Backup7)}
\nelseif ($_.Group[5].Backup7 -ne $null) {
\n($_.Group[5].Backup7)}
\nelseif ($_.Group[6].Backup7 -ne $null) {
\n($_.Group[6].Backup7)}
\nelseif ($_.Group[7].Backup7 -ne $null) {
\n($_.Group[7].Backup7)}
\nelseif ($_.Group[8].Backup7 -ne $null) {
\n($_.Group[8].Backup7)}
\nelseif ($_.Group[9].Backup7 -ne $null) {
\n($_.Group[9].Backup7)}
\nelseif ($_.Group[10].Backup7 -ne $null) {
\n($_.Group[10].Backup7)};
\nBackup8 = if ($_.Group[0].Backup8 -ne $null) {
\n($_.Group[0].Backup8)}
\nelseif ($_.Group[1].Backup8 -ne $null) {
\n($_.Group[1].Backup8)}
\nelseif ($_.Group[2].Backup8 -ne $null) {
\n($_.Group[2].Backup8)}
\nelseif ($_.Group[3].Backup8 -ne $null) {
\n($_.Group[3].Backup8)}
\nelseif ($_.Group[4].Backup8 -ne $null) {
\n($_.Group[4].Backup8)}
\nelseif ($_.Group[5].Backup8 -ne $null) {
\n($_.Group[5].Backup8)}
\nelseif ($_.Group[6].Backup8 -ne $null) {
\n($_.Group[6].Backup8)}
\nelseif ($_.Group[7].Backup8 -ne $null) {
\n($_.Group[7].Backup8)}
\nelseif ($_.Group[8].Backup8 -ne $null) {
\n($_.Group[8].Backup8)}
\nelseif ($_.Group[9].Backup8 -ne $null) {
\n($_.Group[9].Backup8)}
\nelseif ($_.Group[10].Backup8 -ne $null) {
\n($_.Group[10].Backup8)};
\nBackup9 = if ($_.Group[0].Backup9 -ne $null) {
\n($_.Group[0].Backup9)}
\nelseif ($_.Group[1].Backup9 -ne $null) {
\n($_.Group[1].Backup9)}
\nelseif ($_.Group[2].Backup9 -ne $null) {
\n($_.Group[2].Backup9)}
\nelseif ($_.Group[3].Backup9 -ne $null) {
\n($_.Group[3].Backup9)}
\nelseif ($_.Group[4].Backup9 -ne $null) {
\n($_.Group[4].Backup9)}
\nelseif ($_.Group[5].Backup9 -ne $null) {
\n($_.Group[5].Backup9)}
\nelseif ($_.Group[6].Backup9 -ne $null) {
\n($_.Group[6].Backup9)}
\nelseif ($_.Group[7].Backup9 -ne $null) {
\n($_.Group[7].Backup9)}
\nelseif ($_.Group[8].Backup9 -ne $null) {
\n($_.Group[8].Backup9)}
\nelseif ($_.Group[9].Backup9 -ne $null) {
\n($_.Group[9].Backup9)}
\nelseif ($_.Group[10].Backup9 -ne $null) {
\n($_.Group[10].Backup9)};
\n}
\n} | Select Name,@{N="Weekend of $Date2";E={$_.Backup1}},@{N="$Date4";E={$_.Backup4}},@{N="$Date5";E={$_.Backup5}},@{N="$Date6";E={$_.Backup6}},@{N="$Date7";E={$_.Backup7}},@{N="$Date8";E={$_.Backup8}},@{N="Weekend of $Date9";E={$_.Backup9}} | Sort Name | ConvertTo-Html -Fragment # | set-cellcolor -Property $Date3 -Color red -Filter "$Date3 -like ‘Failed’" | set-cellcolor -Property $Date3 -Color ‘#00ff00’ -Filter "$Date3 -like ‘Success’" | set-cellcolor -Property $Date3 -Color ‘#FFFF00’ -Filter "$Date3 -like ‘Warning’" #set-cellcolor -Property $Date3 -Color red -Filter "$Date3 -like ‘Failed’" | set-cellcolor -Property $Date4 -Color red -Filter "$Date4 -like ‘Failed’" | set-cellcolor -Property "Weekend of $Date1" -Color ‘#00ff00′ -Filter "’Weekend of $Date1’ -like ‘Success’" | set-cellcolor -Property $Date3 -Color ‘#00ff00’ -Filter "$Date3 -like ‘Success’" | set-cellcolor -Property $Date4 -Color ‘#00ff00’ -Filter "$Date4 -like ‘Success’" | set-cellcolor -Property "Weekend of $Date1" -Color ‘#FFFF00′ -Filter "’Weekend of $Date1’ -like ‘Warning’" | Out-File "D:\\Scripts\\New-BackupCheck\\VeeamBackupReport.htm"
\n} elseif ([DateTime]::Today.AddDays($Day6).DayOfWeek -eq "Sunday") {
\nWrite-Host "Combined"
\n$ColumnDate = ‘Weekend of ‘ + $Date2
\n$bodySummaryRp = $EndResult | Group Name | ForEach {
\nNew-Object PSObject -Property @{
\nName = $_.Name<\/p>\n

Backup2 = if ($_.Group[0].Backup2 -ne $null) {
\n($_.Group[0].Backup2)}
\nelseif ($_.Group[1].Backup2 -ne $null) {
\n($_.Group[1].Backup2)}
\nelseif ($_.Group[2].Backup2 -ne $null) {
\n($_.Group[2].Backup2)}
\nelseif ($_.Group[3].Backup2 -ne $null) {
\n($_.Group[3].Backup2)}
\nelseif ($_.Group[4].Backup2 -ne $null) {
\n($_.Group[4].Backup2)}
\nelseif ($_.Group[5].Backup2 -ne $null) {
\n($_.Group[5].Backup2)}
\nelseif ($_.Group[6].Backup2 -ne $null) {
\n($_.Group[6].Backup2)}
\nelseif ($_.Group[7].Backup2 -ne $null) {
\n($_.Group[7].Backup2)}
\nelseif ($_.Group[8].Backup2 -ne $null) {
\n($_.Group[8].Backup2)}
\nelseif ($_.Group[9].Backup2 -ne $null) {
\n($_.Group[9].Backup2)}
\nelseif ($_.Group[10].Backup2 -ne $null) {
\n($_.Group[10].Backup2)};
\nBackup3 = if ($_.Group[0].Backup3 -ne $null) {
\n($_.Group[0].Backup3)}
\nelseif ($_.Group[1].Backup3 -ne $null) {
\n($_.Group[1].Backup3)}
\nelseif ($_.Group[2].Backup3 -ne $null) {
\n($_.Group[2].Backup3)}
\nelseif ($_.Group[3].Backup3 -ne $null) {
\n($_.Group[3].Backup3)}
\nelseif ($_.Group[4].Backup3 -ne $null) {
\n($_.Group[4].Backup3)}
\nelseif ($_.Group[5].Backup3 -ne $null) {
\n($_.Group[5].Backup3)}
\nelseif ($_.Group[6].Backup3 -ne $null) {
\n($_.Group[6].Backup3)}
\nelseif ($_.Group[7].Backup3 -ne $null) {
\n($_.Group[7].Backup3)}
\nelseif ($_.Group[8].Backup3 -ne $null) {
\n($_.Group[8].Backup3)}
\nelseif ($_.Group[9].Backup3 -ne $null) {
\n($_.Group[9].Backup3)}
\nelseif ($_.Group[10].Backup3 -ne $null) {
\n($_.Group[10].Backup3)};<\/p>\n

Backup5 = if ($_.Group[0].Backup5 -ne $null) {
\n($_.Group[0].Backup5)}
\nelseif ($_.Group[1].Backup5 -ne $null) {
\n($_.Group[1].Backup5)}
\nelseif ($_.Group[2].Backup5 -ne $null) {
\n($_.Group[2].Backup5)}
\nelseif ($_.Group[3].Backup5 -ne $null) {
\n($_.Group[3].Backup5)}
\nelseif ($_.Group[4].Backup5 -ne $null) {
\n($_.Group[4].Backup5)}
\nelseif ($_.Group[5].Backup5 -ne $null) {
\n($_.Group[5].Backup5)}
\nelseif ($_.Group[6].Backup5 -ne $null) {
\n($_.Group[6].Backup5)}
\nelseif ($_.Group[7].Backup5 -ne $null) {
\n($_.Group[7].Backup5)}
\nelseif ($_.Group[8].Backup5 -ne $null) {
\n($_.Group[8].Backup5)}
\nelseif ($_.Group[9].Backup5 -ne $null) {
\n($_.Group[9].Backup5)}
\nelseif ($_.Group[10].Backup5 -ne $null) {
\n($_.Group[10].Backup5)};
\nBackup6 = if ($_.Group[0].Backup6 -ne $null) {
\n($_.Group[0].Backup6)}
\nelseif ($_.Group[1].Backup6 -ne $null) {
\n($_.Group[1].Backup6)}
\nelseif ($_.Group[2].Backup6 -ne $null) {
\n($_.Group[2].Backup6)}
\nelseif ($_.Group[3].Backup6 -ne $null) {
\n($_.Group[3].Backup6)}
\nelseif ($_.Group[4].Backup6 -ne $null) {
\n($_.Group[4].Backup6)}
\nelseif ($_.Group[5].Backup6 -ne $null) {
\n($_.Group[5].Backup6)}
\nelseif ($_.Group[6].Backup6 -ne $null) {
\n($_.Group[6].Backup6)}
\nelseif ($_.Group[7].Backup6 -ne $null) {
\n($_.Group[7].Backup6)}
\nelseif ($_.Group[8].Backup6 -ne $null) {
\n($_.Group[8].Backup6)}
\nelseif ($_.Group[9].Backup6 -ne $null) {
\n($_.Group[9].Backup6)}
\nelseif ($_.Group[10].Backup6 -ne $null) {
\n($_.Group[10].Backup6)};
\nBackup7 = if ($_.Group[0].Backup7 -ne $null) {
\n($_.Group[0].Backup7)}
\nelseif ($_.Group[1].Backup7 -ne $null) {
\n($_.Group[1].Backup7)}
\nelseif ($_.Group[2].Backup7 -ne $null) {
\n($_.Group[2].Backup7)}
\nelseif ($_.Group[3].Backup7 -ne $null) {
\n($_.Group[3].Backup7)}
\nelseif ($_.Group[4].Backup7 -ne $null) {
\n($_.Group[4].Backup7)}
\nelseif ($_.Group[5].Backup7 -ne $null) {
\n($_.Group[5].Backup7)}
\nelseif ($_.Group[6].Backup7 -ne $null) {
\n($_.Group[6].Backup7)}
\nelseif ($_.Group[7].Backup7 -ne $null) {
\n($_.Group[7].Backup7)}
\nelseif ($_.Group[8].Backup7 -ne $null) {
\n($_.Group[8].Backup7)}
\nelseif ($_.Group[9].Backup7 -ne $null) {
\n($_.Group[9].Backup7)}
\nelseif ($_.Group[10].Backup7 -ne $null) {
\n($_.Group[10].Backup7)};
\nBackup8 = if ($_.Group[0].Backup8 -ne $null) {
\n($_.Group[0].Backup8)}
\nelseif ($_.Group[1].Backup8 -ne $null) {
\n($_.Group[1].Backup8)}
\nelseif ($_.Group[2].Backup8 -ne $null) {
\n($_.Group[2].Backup8)}
\nelseif ($_.Group[3].Backup8 -ne $null) {
\n($_.Group[3].Backup8)}
\nelseif ($_.Group[4].Backup8 -ne $null) {
\n($_.Group[4].Backup8)}
\nelseif ($_.Group[5].Backup8 -ne $null) {
\n($_.Group[5].Backup8)}
\nelseif ($_.Group[6].Backup8 -ne $null) {
\n($_.Group[6].Backup8)}
\nelseif ($_.Group[7].Backup8 -ne $null) {
\n($_.Group[7].Backup8)}
\nelseif ($_.Group[8].Backup8 -ne $null) {
\n($_.Group[8].Backup8)}
\nelseif ($_.Group[9].Backup8 -ne $null) {
\n($_.Group[9].Backup8)}
\nelseif ($_.Group[10].Backup8 -ne $null) {
\n($_.Group[10].Backup8)};
\nBackup9 = if ($_.Group[0].Backup9 -ne $null) {
\n($_.Group[0].Backup9)}
\nelseif ($_.Group[1].Backup9 -ne $null) {
\n($_.Group[1].Backup9)}
\nelseif ($_.Group[2].Backup9 -ne $null) {
\n($_.Group[2].Backup9)}
\nelseif ($_.Group[3].Backup9 -ne $null) {
\n($_.Group[3].Backup9)}
\nelseif ($_.Group[4].Backup9 -ne $null) {
\n($_.Group[4].Backup9)}
\nelseif ($_.Group[5].Backup9 -ne $null) {
\n($_.Group[5].Backup9)}
\nelseif ($_.Group[6].Backup9 -ne $null) {
\n($_.Group[6].Backup9)}
\nelseif ($_.Group[7].Backup9 -ne $null) {
\n($_.Group[7].Backup9)}
\nelseif ($_.Group[8].Backup9 -ne $null) {
\n($_.Group[8].Backup9)}
\nelseif ($_.Group[9].Backup9 -ne $null) {
\n($_.Group[9].Backup9)}
\nelseif ($_.Group[10].Backup9 -ne $null) {
\n($_.Group[10].Backup9)};
\n}
\n} | select Name,@{N="$Date2";E={$_.Backup2}},@{N="Weekend of $Date3";E={$_.Backup3}},@{N="$Date5";E={$_.Backup5}},@{N="$Date6";E={$_.Backup6}},@{N="$Date7";E={$_.Backup7}},@{N="$Date8";E={$_.Backup8}},@{N="$Date9";E={$_.Backup9}} | Sort Name | ConvertTo-Html -Fragment #| set-cellcolor -Property $Date1 -Color red -Filter "$Date1 -like ‘Failed’" | set-cellcolor -Property $Date1 -Color ‘#00ff00’ -Filter "$Date1 -like ‘Success’" | set-cellcolor -Property $Date1 -Color ‘#FFFF00’ -Filter "$Date1 -like ‘Warning’"<\/p>\n

} elseif ([DateTime]::Today.AddDays($Day5).DayOfWeek -eq "Sunday") {
\nWrite-Host "Combined"
\n$bodySummaryRp = $EndResult | Group Name | ForEach {
\nNew-Object PSObject -Property @{
\nName = $_.Name<\/p>\n

Backup2 = if ($_.Group[0].Backup2 -ne $null) {
\n($_.Group[0].Backup2)}
\nelseif ($_.Group[1].Backup2 -ne $null) {
\n($_.Group[1].Backup2)}
\nelseif ($_.Group[2].Backup2 -ne $null) {
\n($_.Group[2].Backup2)}
\nelseif ($_.Group[3].Backup2 -ne $null) {
\n($_.Group[3].Backup2)}
\nelseif ($_.Group[4].Backup2 -ne $null) {
\n($_.Group[4].Backup2)}
\nelseif ($_.Group[5].Backup2 -ne $null) {
\n($_.Group[5].Backup2)}
\nelseif ($_.Group[6].Backup2 -ne $null) {
\n($_.Group[6].Backup2)}
\nelseif ($_.Group[7].Backup2 -ne $null) {
\n($_.Group[7].Backup2)}
\nelseif ($_.Group[8].Backup2 -ne $null) {
\n($_.Group[8].Backup2)}
\nelseif ($_.Group[9].Backup2 -ne $null) {
\n($_.Group[9].Backup2)}
\nelseif ($_.Group[10].Backup2 -ne $null) {
\n($_.Group[10].Backup2)};
\nBackup3 = if ($_.Group[0].Backup3 -ne $null) {
\n($_.Group[0].Backup3)}
\nelseif ($_.Group[1].Backup3 -ne $null) {
\n($_.Group[1].Backup3)}
\nelseif ($_.Group[2].Backup3 -ne $null) {
\n($_.Group[2].Backup3)}
\nelseif ($_.Group[3].Backup3 -ne $null) {
\n($_.Group[3].Backup3)}
\nelseif ($_.Group[4].Backup3 -ne $null) {
\n($_.Group[4].Backup3)}
\nelseif ($_.Group[5].Backup3 -ne $null) {
\n($_.Group[5].Backup3)}
\nelseif ($_.Group[6].Backup3 -ne $null) {
\n($_.Group[6].Backup3)}
\nelseif ($_.Group[7].Backup3 -ne $null) {
\n($_.Group[7].Backup3)}
\nelseif ($_.Group[8].Backup3 -ne $null) {
\n($_.Group[8].Backup3)}
\nelseif ($_.Group[9].Backup3 -ne $null) {
\n($_.Group[9].Backup3)}
\nelseif ($_.Group[10].Backup3 -ne $null) {
\n($_.Group[10].Backup3)};
\nBackup4 = if ($_.Group[0].Backup4 -ne $null) {
\n($_.Group[0].Backup4)}
\nelseif ($_.Group[1].Backup4 -ne $null) {
\n($_.Group[1].Backup4)}
\nelseif ($_.Group[2].Backup4 -ne $null) {
\n($_.Group[2].Backup4)}
\nelseif ($_.Group[3].Backup4 -ne $null) {
\n($_.Group[3].Backup4)}
\nelseif ($_.Group[4].Backup4 -ne $null) {
\n($_.Group[4].Backup4)}
\nelseif ($_.Group[5].Backup4 -ne $null) {
\n($_.Group[5].Backup4)}
\nelseif ($_.Group[6].Backup4 -ne $null) {
\n($_.Group[6].Backup4)}
\nelseif ($_.Group[7].Backup4 -ne $null) {
\n($_.Group[7].Backup4)}
\nelseif ($_.Group[8].Backup4 -ne $null) {
\n($_.Group[8].Backup4)}
\nelseif ($_.Group[9].Backup4 -ne $null) {
\n($_.Group[9].Backup4)}
\nelseif ($_.Group[10].Backup4 -ne $null) {
\n($_.Group[10].Backup4)};<\/p>\n

Backup6 = if ($_.Group[0].Backup6 -ne $null) {
\n($_.Group[0].Backup6)}
\nelseif ($_.Group[1].Backup6 -ne $null) {
\n($_.Group[1].Backup6)}
\nelseif ($_.Group[2].Backup6 -ne $null) {
\n($_.Group[2].Backup6)}
\nelseif ($_.Group[3].Backup6 -ne $null) {
\n($_.Group[3].Backup6)}
\nelseif ($_.Group[4].Backup6 -ne $null) {
\n($_.Group[4].Backup6)}
\nelseif ($_.Group[5].Backup6 -ne $null) {
\n($_.Group[5].Backup6)}
\nelseif ($_.Group[6].Backup6 -ne $null) {
\n($_.Group[6].Backup6)}
\nelseif ($_.Group[7].Backup6 -ne $null) {
\n($_.Group[7].Backup6)}
\nelseif ($_.Group[8].Backup6 -ne $null) {
\n($_.Group[8].Backup6)}
\nelseif ($_.Group[9].Backup6 -ne $null) {
\n($_.Group[9].Backup6)}
\nelseif ($_.Group[10].Backup6 -ne $null) {
\n($_.Group[10].Backup6)};
\nBackup7 = if ($_.Group[0].Backup7 -ne $null) {
\n($_.Group[0].Backup7)}
\nelseif ($_.Group[1].Backup7 -ne $null) {
\n($_.Group[1].Backup7)}
\nelseif ($_.Group[2].Backup7 -ne $null) {
\n($_.Group[2].Backup7)}
\nelseif ($_.Group[3].Backup7 -ne $null) {
\n($_.Group[3].Backup7)}
\nelseif ($_.Group[4].Backup7 -ne $null) {
\n($_.Group[4].Backup7)}
\nelseif ($_.Group[5].Backup7 -ne $null) {
\n($_.Group[5].Backup7)}
\nelseif ($_.Group[6].Backup7 -ne $null) {
\n($_.Group[6].Backup7)}
\nelseif ($_.Group[7].Backup7 -ne $null) {
\n($_.Group[7].Backup7)}
\nelseif ($_.Group[8].Backup7 -ne $null) {
\n($_.Group[8].Backup7)}
\nelseif ($_.Group[9].Backup7 -ne $null) {
\n($_.Group[9].Backup7)}
\nelseif ($_.Group[10].Backup7 -ne $null) {
\n($_.Group[10].Backup7)};
\nBackup8 = if ($_.Group[0].Backup8 -ne $null) {
\n($_.Group[0].Backup8)}
\nelseif ($_.Group[1].Backup8 -ne $null) {
\n($_.Group[1].Backup8)}
\nelseif ($_.Group[2].Backup8 -ne $null) {
\n($_.Group[2].Backup8)}
\nelseif ($_.Group[3].Backup8 -ne $null) {
\n($_.Group[3].Backup8)}
\nelseif ($_.Group[4].Backup8 -ne $null) {
\n($_.Group[4].Backup8)}
\nelseif ($_.Group[5].Backup8 -ne $null) {
\n($_.Group[5].Backup8)}
\nelseif ($_.Group[6].Backup8 -ne $null) {
\n($_.Group[6].Backup8)}
\nelseif ($_.Group[7].Backup8 -ne $null) {
\n($_.Group[7].Backup8)}
\nelseif ($_.Group[8].Backup8 -ne $null) {
\n($_.Group[8].Backup8)}
\nelseif ($_.Group[9].Backup8 -ne $null) {
\n($_.Group[9].Backup8)}
\nelseif ($_.Group[10].Backup8 -ne $null) {
\n($_.Group[10].Backup8)};
\nBackup9 = if ($_.Group[0].Backup9 -ne $null) {
\n($_.Group[0].Backup9)}
\nelseif ($_.Group[1].Backup9 -ne $null) {
\n($_.Group[1].Backup9)}
\nelseif ($_.Group[2].Backup9 -ne $null) {
\n($_.Group[2].Backup9)}
\nelseif ($_.Group[3].Backup9 -ne $null) {
\n($_.Group[3].Backup9)}
\nelseif ($_.Group[4].Backup9 -ne $null) {
\n($_.Group[4].Backup9)}
\nelseif ($_.Group[5].Backup9 -ne $null) {
\n($_.Group[5].Backup9)}
\nelseif ($_.Group[6].Backup9 -ne $null) {
\n($_.Group[6].Backup9)}
\nelseif ($_.Group[7].Backup9 -ne $null) {
\n($_.Group[7].Backup9)}
\nelseif ($_.Group[8].Backup9 -ne $null) {
\n($_.Group[8].Backup9)}
\nelseif ($_.Group[9].Backup9 -ne $null) {
\n($_.Group[9].Backup9)}
\nelseif ($_.Group[10].Backup9 -ne $null) {
\n($_.Group[10].Backup9)};
\n}
\n} | select Name,@{N="$Date2";E={$_.Backup2}},@{N="$Date3";E={$_.Backup3}},@{N="Weekend of $Date4";E={$_.Backup4}},@{N="$Date6";E={$_.Backup6}},@{N="$Date7";E={$_.Backup7}},@{N="$Date8";E={$_.Backup8}},@{N="$Date9";E={$_.Backup9}} | Sort Name | ConvertTo-Html -Fragment #| set-cellcolor -Property $Date1 -Color red -Filter "$Date1 -like ‘Failed’" | set-cellcolor -Property $Date1 -Color ‘#00ff00’ -Filter "$Date1 -like ‘Success’" | set-cellcolor -Property $Date1 -Color ‘#FFFF00’ -Filter "$Date1 -like ‘Warning’"
\n} elseif ([DateTime]::Today.AddDays($Day4).DayOfWeek -eq "Sunday") {
\nWrite-Host "Combined"
\n$bodySummaryRp = $EndResult | Group Name | ForEach {
\nNew-Object PSObject -Property @{
\nName = $_.Name<\/p>\n

Backup2 = if ($_.Group[0].Backup2 -ne $null) {
\n($_.Group[0].Backup2)}
\nelseif ($_.Group[1].Backup2 -ne $null) {
\n($_.Group[1].Backup2)}
\nelseif ($_.Group[2].Backup2 -ne $null) {
\n($_.Group[2].Backup2)}
\nelseif ($_.Group[3].Backup2 -ne $null) {
\n($_.Group[3].Backup2)}
\nelseif ($_.Group[4].Backup2 -ne $null) {
\n($_.Group[4].Backup2)}
\nelseif ($_.Group[5].Backup2 -ne $null) {
\n($_.Group[5].Backup2)}
\nelseif ($_.Group[6].Backup2 -ne $null) {
\n($_.Group[6].Backup2)}
\nelseif ($_.Group[7].Backup2 -ne $null) {
\n($_.Group[7].Backup2)}
\nelseif ($_.Group[8].Backup2 -ne $null) {
\n($_.Group[8].Backup2)}
\nelseif ($_.Group[9].Backup2 -ne $null) {
\n($_.Group[9].Backup2)}
\nelseif ($_.Group[10].Backup2 -ne $null) {
\n($_.Group[10].Backup2)};
\nBackup3 = if ($_.Group[0].Backup3 -ne $null) {
\n($_.Group[0].Backup3)}
\nelseif ($_.Group[1].Backup3 -ne $null) {
\n($_.Group[1].Backup3)}
\nelseif ($_.Group[2].Backup3 -ne $null) {
\n($_.Group[2].Backup3)}
\nelseif ($_.Group[3].Backup3 -ne $null) {
\n($_.Group[3].Backup3)}
\nelseif ($_.Group[4].Backup3 -ne $null) {
\n($_.Group[4].Backup3)}
\nelseif ($_.Group[5].Backup3 -ne $null) {
\n($_.Group[5].Backup3)}
\nelseif ($_.Group[6].Backup3 -ne $null) {
\n($_.Group[6].Backup3)}
\nelseif ($_.Group[7].Backup3 -ne $null) {
\n($_.Group[7].Backup3)}
\nelseif ($_.Group[8].Backup3 -ne $null) {
\n($_.Group[8].Backup3)}
\nelseif ($_.Group[9].Backup3 -ne $null) {
\n($_.Group[9].Backup3)}
\nelseif ($_.Group[10].Backup3 -ne $null) {
\n($_.Group[10].Backup3)};
\nBackup4 = if ($_.Group[0].Backup4 -ne $null) {
\n($_.Group[0].Backup4)}
\nelseif ($_.Group[1].Backup4 -ne $null) {
\n($_.Group[1].Backup4)}
\nelseif ($_.Group[2].Backup4 -ne $null) {
\n($_.Group[2].Backup4)}
\nelseif ($_.Group[3].Backup4 -ne $null) {
\n($_.Group[3].Backup4)}
\nelseif ($_.Group[4].Backup4 -ne $null) {
\n($_.Group[4].Backup4)}
\nelseif ($_.Group[5].Backup4 -ne $null) {
\n($_.Group[5].Backup4)}
\nelseif ($_.Group[6].Backup4 -ne $null) {
\n($_.Group[6].Backup4)}
\nelseif ($_.Group[7].Backup4 -ne $null) {
\n($_.Group[7].Backup4)}
\nelseif ($_.Group[8].Backup4 -ne $null) {
\n($_.Group[8].Backup4)}
\nelseif ($_.Group[9].Backup4 -ne $null) {
\n($_.Group[9].Backup4)}
\nelseif ($_.Group[10].Backup4 -ne $null) {
\n($_.Group[10].Backup4)};
\nBackup5 = if ($_.Group[0].Backup5 -ne $null) {
\n($_.Group[0].Backup5)}
\nelseif ($_.Group[1].Backup5 -ne $null) {
\n($_.Group[1].Backup5)}
\nelseif ($_.Group[2].Backup5 -ne $null) {
\n($_.Group[2].Backup5)}
\nelseif ($_.Group[3].Backup5 -ne $null) {
\n($_.Group[3].Backup5)}
\nelseif ($_.Group[4].Backup5 -ne $null) {
\n($_.Group[4].Backup5)}
\nelseif ($_.Group[5].Backup5 -ne $null) {
\n($_.Group[5].Backup5)}
\nelseif ($_.Group[6].Backup5 -ne $null) {
\n($_.Group[6].Backup5)}
\nelseif ($_.Group[7].Backup5 -ne $null) {
\n($_.Group[7].Backup5)}
\nelseif ($_.Group[8].Backup5 -ne $null) {
\n($_.Group[8].Backup5)}
\nelseif ($_.Group[9].Backup5 -ne $null) {
\n($_.Group[9].Backup5)}
\nelseif ($_.Group[10].Backup5 -ne $null) {
\n($_.Group[10].Backup5)};<\/p>\n

Backup7 = if ($_.Group[0].Backup7 -ne $null) {
\n($_.Group[0].Backup7)}
\nelseif ($_.Group[1].Backup7 -ne $null) {
\n($_.Group[1].Backup7)}
\nelseif ($_.Group[2].Backup7 -ne $null) {
\n($_.Group[2].Backup7)}
\nelseif ($_.Group[3].Backup7 -ne $null) {
\n($_.Group[3].Backup7)}
\nelseif ($_.Group[4].Backup7 -ne $null) {
\n($_.Group[4].Backup7)}
\nelseif ($_.Group[5].Backup7 -ne $null) {
\n($_.Group[5].Backup7)}
\nelseif ($_.Group[6].Backup7 -ne $null) {
\n($_.Group[6].Backup7)}
\nelseif ($_.Group[7].Backup7 -ne $null) {
\n($_.Group[7].Backup7)}
\nelseif ($_.Group[8].Backup7 -ne $null) {
\n($_.Group[8].Backup7)}
\nelseif ($_.Group[9].Backup7 -ne $null) {
\n($_.Group[9].Backup7)}
\nelseif ($_.Group[10].Backup7 -ne $null) {
\n($_.Group[10].Backup7)};
\nBackup8 = if ($_.Group[0].Backup8 -ne $null) {
\n($_.Group[0].Backup8)}
\nelseif ($_.Group[1].Backup8 -ne $null) {
\n($_.Group[1].Backup8)}
\nelseif ($_.Group[2].Backup8 -ne $null) {
\n($_.Group[2].Backup8)}
\nelseif ($_.Group[3].Backup8 -ne $null) {
\n($_.Group[3].Backup8)}
\nelseif ($_.Group[4].Backup8 -ne $null) {
\n($_.Group[4].Backup8)}
\nelseif ($_.Group[5].Backup8 -ne $null) {
\n($_.Group[5].Backup8)}
\nelseif ($_.Group[6].Backup8 -ne $null) {
\n($_.Group[6].Backup8)}
\nelseif ($_.Group[7].Backup8 -ne $null) {
\n($_.Group[7].Backup8)}
\nelseif ($_.Group[8].Backup8 -ne $null) {
\n($_.Group[8].Backup8)}
\nelseif ($_.Group[9].Backup8 -ne $null) {
\n($_.Group[9].Backup8)}
\nelseif ($_.Group[10].Backup8 -ne $null) {
\n($_.Group[10].Backup8)};
\nBackup9 = if ($_.Group[0].Backup9 -ne $null) {
\n($_.Group[0].Backup9)}
\nelseif ($_.Group[1].Backup9 -ne $null) {
\n($_.Group[1].Backup9)}
\nelseif ($_.Group[2].Backup9 -ne $null) {
\n($_.Group[2].Backup9)}
\nelseif ($_.Group[3].Backup9 -ne $null) {
\n($_.Group[3].Backup9)}
\nelseif ($_.Group[4].Backup9 -ne $null) {
\n($_.Group[4].Backup9)}
\nelseif ($_.Group[5].Backup9 -ne $null) {
\n($_.Group[5].Backup9)}
\nelseif ($_.Group[6].Backup9 -ne $null) {
\n($_.Group[6].Backup9)}
\nelseif ($_.Group[7].Backup9 -ne $null) {
\n($_.Group[7].Backup9)}
\nelseif ($_.Group[8].Backup9 -ne $null) {
\n($_.Group[8].Backup9)}
\nelseif ($_.Group[9].Backup9 -ne $null) {
\n($_.Group[9].Backup9)}
\nelseif ($_.Group[10].Backup9 -ne $null) {
\n($_.Group[10].Backup9)};
\n}
\n} | select Name,@{N="$Date2";E={$_.Backup2}},@{N="$Date3";E={$_.Backup3}},@{N="$Date4";E={$_.Backup4}},@{N="Weekend of $Date5";E={$_.Backup5}},@{N="$Date7";E={$_.Backup7}},@{N="$Date8";E={$_.Backup8}},@{N="$Date9";E={$_.Backup9}} | Sort Name | ConvertTo-Html -Fragment #| set-cellcolor -Property $Date1 -Color red -Filter "$Date1 -like ‘Failed’" | set-cellcolor -Property $Date1 -Color ‘#00ff00’ -Filter "$Date1 -like ‘Success’" | set-cellcolor -Property $Date1 -Color ‘#FFFF00’ -Filter "$Date1 -like ‘Warning’"
\n} elseif ([DateTime]::Today.AddDays($Day3).DayOfWeek -eq "Sunday") {
\nWrite-Host "Combined"
\n$bodySummaryRp = $EndResult | Group Name | ForEach {
\nNew-Object PSObject -Property @{
\nName = $_.Name<\/p>\n

Backup2 = if ($_.Group[0].Backup2 -ne $null) {
\n($_.Group[0].Backup2)}
\nelseif ($_.Group[1].Backup2 -ne $null) {
\n($_.Group[1].Backup2)}
\nelseif ($_.Group[2].Backup2 -ne $null) {
\n($_.Group[2].Backup2)}
\nelseif ($_.Group[3].Backup2 -ne $null) {
\n($_.Group[3].Backup2)}
\nelseif ($_.Group[4].Backup2 -ne $null) {
\n($_.Group[4].Backup2)}
\nelseif ($_.Group[5].Backup2 -ne $null) {
\n($_.Group[5].Backup2)}
\nelseif ($_.Group[6].Backup2 -ne $null) {
\n($_.Group[6].Backup2)}
\nelseif ($_.Group[7].Backup2 -ne $null) {
\n($_.Group[7].Backup2)}
\nelseif ($_.Group[8].Backup2 -ne $null) {
\n($_.Group[8].Backup2)}
\nelseif ($_.Group[9].Backup2 -ne $null) {
\n($_.Group[9].Backup2)}
\nelseif ($_.Group[10].Backup2 -ne $null) {
\n($_.Group[10].Backup2)};
\nBackup3 = if ($_.Group[0].Backup3 -ne $null) {
\n($_.Group[0].Backup3)}
\nelseif ($_.Group[1].Backup3 -ne $null) {
\n($_.Group[1].Backup3)}
\nelseif ($_.Group[2].Backup3 -ne $null) {
\n($_.Group[2].Backup3)}
\nelseif ($_.Group[3].Backup3 -ne $null) {
\n($_.Group[3].Backup3)}
\nelseif ($_.Group[4].Backup3 -ne $null) {
\n($_.Group[4].Backup3)}
\nelseif ($_.Group[5].Backup3 -ne $null) {
\n($_.Group[5].Backup3)}
\nelseif ($_.Group[6].Backup3 -ne $null) {
\n($_.Group[6].Backup3)}
\nelseif ($_.Group[7].Backup3 -ne $null) {
\n($_.Group[7].Backup3)}
\nelseif ($_.Group[8].Backup3 -ne $null) {
\n($_.Group[8].Backup3)}
\nelseif ($_.Group[9].Backup3 -ne $null) {
\n($_.Group[9].Backup3)}
\nelseif ($_.Group[10].Backup3 -ne $null) {
\n($_.Group[10].Backup3)};
\nBackup4 = if ($_.Group[0].Backup4 -ne $null) {
\n($_.Group[0].Backup4)}
\nelseif ($_.Group[1].Backup4 -ne $null) {
\n($_.Group[1].Backup4)}
\nelseif ($_.Group[2].Backup4 -ne $null) {
\n($_.Group[2].Backup4)}
\nelseif ($_.Group[3].Backup4 -ne $null) {
\n($_.Group[3].Backup4)}
\nelseif ($_.Group[4].Backup4 -ne $null) {
\n($_.Group[4].Backup4)}
\nelseif ($_.Group[5].Backup4 -ne $null) {
\n($_.Group[5].Backup4)}
\nelseif ($_.Group[6].Backup4 -ne $null) {
\n($_.Group[6].Backup4)}
\nelseif ($_.Group[7].Backup4 -ne $null) {
\n($_.Group[7].Backup4)}
\nelseif ($_.Group[8].Backup4 -ne $null) {
\n($_.Group[8].Backup4)}
\nelseif ($_.Group[9].Backup4 -ne $null) {
\n($_.Group[9].Backup4)}
\nelseif ($_.Group[10].Backup4 -ne $null) {
\n($_.Group[10].Backup4)};
\nBackup5 = if ($_.Group[0].Backup5 -ne $null) {
\n($_.Group[0].Backup5)}
\nelseif ($_.Group[1].Backup5 -ne $null) {
\n($_.Group[1].Backup5)}
\nelseif ($_.Group[2].Backup5 -ne $null) {
\n($_.Group[2].Backup5)}
\nelseif ($_.Group[3].Backup5 -ne $null) {
\n($_.Group[3].Backup5)}
\nelseif ($_.Group[4].Backup5 -ne $null) {
\n($_.Group[4].Backup5)}
\nelseif ($_.Group[5].Backup5 -ne $null) {
\n($_.Group[5].Backup5)}
\nelseif ($_.Group[6].Backup5 -ne $null) {
\n($_.Group[6].Backup5)}
\nelseif ($_.Group[7].Backup5 -ne $null) {
\n($_.Group[7].Backup5)}
\nelseif ($_.Group[8].Backup5 -ne $null) {
\n($_.Group[8].Backup5)}
\nelseif ($_.Group[9].Backup5 -ne $null) {
\n($_.Group[9].Backup5)}
\nelseif ($_.Group[10].Backup5 -ne $null) {
\n($_.Group[10].Backup5)};
\nBackup6 = if ($_.Group[0].Backup6 -ne $null) {
\n($_.Group[0].Backup6)}
\nelseif ($_.Group[1].Backup6 -ne $null) {
\n($_.Group[1].Backup6)}
\nelseif ($_.Group[2].Backup6 -ne $null) {
\n($_.Group[2].Backup6)}
\nelseif ($_.Group[3].Backup6 -ne $null) {
\n($_.Group[3].Backup6)}
\nelseif ($_.Group[4].Backup6 -ne $null) {
\n($_.Group[4].Backup6)}
\nelseif ($_.Group[5].Backup6 -ne $null) {
\n($_.Group[5].Backup6)}
\nelseif ($_.Group[6].Backup6 -ne $null) {
\n($_.Group[6].Backup6)}
\nelseif ($_.Group[7].Backup6 -ne $null) {
\n($_.Group[7].Backup6)}
\nelseif ($_.Group[8].Backup6 -ne $null) {
\n($_.Group[8].Backup6)}
\nelseif ($_.Group[9].Backup6 -ne $null) {
\n($_.Group[9].Backup6)}
\nelseif ($_.Group[10].Backup6 -ne $null) {
\n($_.Group[10].Backup6)};
\nBackup8 = if ($_.Group[0].Backup8 -ne $null) {
\n($_.Group[0].Backup8)}
\nelseif ($_.Group[1].Backup8 -ne $null) {
\n($_.Group[1].Backup8)}
\nelseif ($_.Group[2].Backup8 -ne $null) {
\n($_.Group[2].Backup8)}
\nelseif ($_.Group[3].Backup8 -ne $null) {
\n($_.Group[3].Backup8)}
\nelseif ($_.Group[4].Backup8 -ne $null) {
\n($_.Group[4].Backup8)}
\nelseif ($_.Group[5].Backup8 -ne $null) {
\n($_.Group[5].Backup8)}
\nelseif ($_.Group[6].Backup8 -ne $null) {
\n($_.Group[6].Backup8)}
\nelseif ($_.Group[7].Backup8 -ne $null) {
\n($_.Group[7].Backup8)}
\nelseif ($_.Group[8].Backup8 -ne $null) {
\n($_.Group[8].Backup8)}
\nelseif ($_.Group[9].Backup8 -ne $null) {
\n($_.Group[9].Backup8)}
\nelseif ($_.Group[10].Backup8 -ne $null) {
\n($_.Group[10].Backup8)};
\nBackup9 = if ($_.Group[0].Backup9 -ne $null) {
\n($_.Group[0].Backup9)}
\nelseif ($_.Group[1].Backup9 -ne $null) {
\n($_.Group[1].Backup9)}
\nelseif ($_.Group[2].Backup9 -ne $null) {
\n($_.Group[2].Backup9)}
\nelseif ($_.Group[3].Backup9 -ne $null) {
\n($_.Group[3].Backup9)}
\nelseif ($_.Group[4].Backup9 -ne $null) {
\n($_.Group[4].Backup9)}
\nelseif ($_.Group[5].Backup9 -ne $null) {
\n($_.Group[5].Backup9)}
\nelseif ($_.Group[6].Backup9 -ne $null) {
\n($_.Group[6].Backup9)}
\nelseif ($_.Group[7].Backup9 -ne $null) {
\n($_.Group[7].Backup9)}
\nelseif ($_.Group[8].Backup9 -ne $null) {
\n($_.Group[8].Backup9)}
\nelseif ($_.Group[9].Backup9 -ne $null) {
\n($_.Group[9].Backup9)}
\nelseif ($_.Group[10].Backup9 -ne $null) {
\n($_.Group[10].Backup9)};
\n}
\n} | select Name,@{N="$Date2";E={$_.Backup2}},@{N="$Date3";E={$_.Backup3}},@{N="$Date4";E={$_.Backup4}},@{N="$Date5";E={$_.Backup5}},@{N="Weekend of $Date6";E={$_.Backup6}},@{N="$Date8";E={$_.Backup8}},@{N="$Date9";E={$_.Backup9}} | Sort Name | ConvertTo-Html -Fragment #| set-cellcolor -Property $Date1 -Color red -Filter "$Date1 -like ‘Failed’" | set-cellcolor -Property $Date1 -Color ‘#00ff00’ -Filter "$Date1 -like ‘Success’" | set-cellcolor -Property $Date1 -Color ‘#FFFF00’ -Filter "$Date1 -like ‘Warning’"
\n} elseif ([DateTime]::Today.AddDays($Day2).DayOfWeek -eq "Sunday") {
\nWrite-Host "Combined"
\n$bodySummaryRp = $EndResult | Group Name | ForEach {
\nNew-Object PSObject -Property @{
\nName = $_.Name<\/p>\n

Backup2 = if ($_.Group[0].Backup2 -ne $null) {
\n($_.Group[0].Backup2)}
\nelseif ($_.Group[1].Backup2 -ne $null) {
\n($_.Group[1].Backup2)}
\nelseif ($_.Group[2].Backup2 -ne $null) {
\n($_.Group[2].Backup2)}
\nelseif ($_.Group[3].Backup2 -ne $null) {
\n($_.Group[3].Backup2)}
\nelseif ($_.Group[4].Backup2 -ne $null) {
\n($_.Group[4].Backup2)}
\nelseif ($_.Group[5].Backup2 -ne $null) {
\n($_.Group[5].Backup2)}
\nelseif ($_.Group[6].Backup2 -ne $null) {
\n($_.Group[6].Backup2)}
\nelseif ($_.Group[7].Backup2 -ne $null) {
\n($_.Group[7].Backup2)}
\nelseif ($_.Group[8].Backup2 -ne $null) {
\n($_.Group[8].Backup2)}
\nelseif ($_.Group[9].Backup2 -ne $null) {
\n($_.Group[9].Backup2)}
\nelseif ($_.Group[10].Backup2 -ne $null) {
\n($_.Group[10].Backup2)};
\nBackup3 = if ($_.Group[0].Backup3 -ne $null) {
\n($_.Group[0].Backup3)}
\nelseif ($_.Group[1].Backup3 -ne $null) {
\n($_.Group[1].Backup3)}
\nelseif ($_.Group[2].Backup3 -ne $null) {
\n($_.Group[2].Backup3)}
\nelseif ($_.Group[3].Backup3 -ne $null) {
\n($_.Group[3].Backup3)}
\nelseif ($_.Group[4].Backup3 -ne $null) {
\n($_.Group[4].Backup3)}
\nelseif ($_.Group[5].Backup3 -ne $null) {
\n($_.Group[5].Backup3)}
\nelseif ($_.Group[6].Backup3 -ne $null) {
\n($_.Group[6].Backup3)}
\nelseif ($_.Group[7].Backup3 -ne $null) {
\n($_.Group[7].Backup3)}
\nelseif ($_.Group[8].Backup3 -ne $null) {
\n($_.Group[8].Backup3)}
\nelseif ($_.Group[9].Backup3 -ne $null) {
\n($_.Group[9].Backup3)}
\nelseif ($_.Group[10].Backup3 -ne $null) {
\n($_.Group[10].Backup3)};
\nBackup4 = if ($_.Group[0].Backup4 -ne $null) {
\n($_.Group[0].Backup4)}
\nelseif ($_.Group[1].Backup4 -ne $null) {
\n($_.Group[1].Backup4)}
\nelseif ($_.Group[2].Backup4 -ne $null) {
\n($_.Group[2].Backup4)}
\nelseif ($_.Group[3].Backup4 -ne $null) {
\n($_.Group[3].Backup4)}
\nelseif ($_.Group[4].Backup4 -ne $null) {
\n($_.Group[4].Backup4)}
\nelseif ($_.Group[5].Backup4 -ne $null) {
\n($_.Group[5].Backup4)}
\nelseif ($_.Group[6].Backup4 -ne $null) {
\n($_.Group[6].Backup4)}
\nelseif ($_.Group[7].Backup4 -ne $null) {
\n($_.Group[7].Backup4)}
\nelseif ($_.Group[8].Backup4 -ne $null) {
\n($_.Group[8].Backup4)}
\nelseif ($_.Group[9].Backup4 -ne $null) {
\n($_.Group[9].Backup4)}
\nelseif ($_.Group[10].Backup4 -ne $null) {
\n($_.Group[10].Backup4)};
\nBackup5 = if ($_.Group[0].Backup5 -ne $null) {
\n($_.Group[0].Backup5)}
\nelseif ($_.Group[1].Backup5 -ne $null) {
\n($_.Group[1].Backup5)}
\nelseif ($_.Group[2].Backup5 -ne $null) {
\n($_.Group[2].Backup5)}
\nelseif ($_.Group[3].Backup5 -ne $null) {
\n($_.Group[3].Backup5)}
\nelseif ($_.Group[4].Backup5 -ne $null) {
\n($_.Group[4].Backup5)}
\nelseif ($_.Group[5].Backup5 -ne $null) {
\n($_.Group[5].Backup5)}
\nelseif ($_.Group[6].Backup5 -ne $null) {
\n($_.Group[6].Backup5)}
\nelseif ($_.Group[7].Backup5 -ne $null) {
\n($_.Group[7].Backup5)}
\nelseif ($_.Group[8].Backup5 -ne $null) {
\n($_.Group[8].Backup5)}
\nelseif ($_.Group[9].Backup5 -ne $null) {
\n($_.Group[9].Backup5)}
\nelseif ($_.Group[10].Backup5 -ne $null) {
\n($_.Group[10].Backup5)};
\nBackup6 = if ($_.Group[0].Backup6 -ne $null) {
\n($_.Group[0].Backup6)}
\nelseif ($_.Group[1].Backup6 -ne $null) {
\n($_.Group[1].Backup6)}
\nelseif ($_.Group[2].Backup6 -ne $null) {
\n($_.Group[2].Backup6)}
\nelseif ($_.Group[3].Backup6 -ne $null) {
\n($_.Group[3].Backup6)}
\nelseif ($_.Group[4].Backup6 -ne $null) {
\n($_.Group[4].Backup6)}
\nelseif ($_.Group[5].Backup6 -ne $null) {
\n($_.Group[5].Backup6)}
\nelseif ($_.Group[6].Backup6 -ne $null) {
\n($_.Group[6].Backup6)}
\nelseif ($_.Group[7].Backup6 -ne $null) {
\n($_.Group[7].Backup6)}
\nelseif ($_.Group[8].Backup6 -ne $null) {
\n($_.Group[8].Backup6)}
\nelseif ($_.Group[9].Backup6 -ne $null) {
\n($_.Group[9].Backup6)}
\nelseif ($_.Group[10].Backup6 -ne $null) {
\n($_.Group[10].Backup6)};
\nBackup7 = if ($_.Group[0].Backup7 -ne $null) {
\n($_.Group[0].Backup7)}
\nelseif ($_.Group[1].Backup7 -ne $null) {
\n($_.Group[1].Backup7)}
\nelseif ($_.Group[2].Backup7 -ne $null) {
\n($_.Group[2].Backup7)}
\nelseif ($_.Group[3].Backup7 -ne $null) {
\n($_.Group[3].Backup7)}
\nelseif ($_.Group[4].Backup7 -ne $null) {
\n($_.Group[4].Backup7)}
\nelseif ($_.Group[5].Backup7 -ne $null) {
\n($_.Group[5].Backup7)}
\nelseif ($_.Group[6].Backup7 -ne $null) {
\n($_.Group[6].Backup7)}
\nelseif ($_.Group[7].Backup7 -ne $null) {
\n($_.Group[7].Backup7)}
\nelseif ($_.Group[8].Backup7 -ne $null) {
\n($_.Group[8].Backup7)}
\nelseif ($_.Group[9].Backup7 -ne $null) {
\n($_.Group[9].Backup7)}
\nelseif ($_.Group[10].Backup7 -ne $null) {
\n($_.Group[10].Backup7)};
\nBackup9 = if ($_.Group[0].Backup9 -ne $null) {
\n($_.Group[0].Backup9)}
\nelseif ($_.Group[1].Backup9 -ne $null) {
\n($_.Group[1].Backup9)}
\nelseif ($_.Group[2].Backup9 -ne $null) {
\n($_.Group[2].Backup9)}
\nelseif ($_.Group[3].Backup9 -ne $null) {
\n($_.Group[3].Backup9)}
\nelseif ($_.Group[4].Backup9 -ne $null) {
\n($_.Group[4].Backup9)}
\nelseif ($_.Group[5].Backup9 -ne $null) {
\n($_.Group[5].Backup9)}
\nelseif ($_.Group[6].Backup9 -ne $null) {
\n($_.Group[6].Backup9)}
\nelseif ($_.Group[7].Backup9 -ne $null) {
\n($_.Group[7].Backup9)}
\nelseif ($_.Group[8].Backup9 -ne $null) {
\n($_.Group[8].Backup9)}
\nelseif ($_.Group[9].Backup9 -ne $null) {
\n($_.Group[9].Backup9)}
\nelseif ($_.Group[10].Backup9 -ne $null) {
\n($_.Group[10].Backup9)};
\n}
\n} | select Name,@{N="$Date2";E={$_.Backup2}},@{N="$Date3";E={$_.Backup3}},@{N="$Date4";E={$_.Backup4}},@{N="$Date5";E={$_.Backup5}},@{N="$Date6";E={$_.Backup6}},@{N="Weekend of $Date7";E={$_.Backup7}},@{N="$Date9";E={$_.Backup9}} | Sort Name | ConvertTo-Html -Fragment #| set-cellcolor -Property $Date1 -Color red -Filter "$Date1 -like ‘Failed’" | set-cellcolor -Property $Date1 -Color ‘#00ff00’ -Filter "$Date1 -like ‘Success’" | set-cellcolor -Property $Date1 -Color ‘#FFFF00’ -Filter "$Date1 -like ‘Warning’"
\n} elseif ([DateTime]::Today.AddDays($Day1).DayOfWeek -eq "Sunday") {
\nWrite-Host "Combined"
\n$bodySummaryRp = $EndResult | Group Name | ForEach {
\nNew-Object PSObject -Property @{
\nName = $_.Name
\nBackup1 = if ($_.Group[0].Backup1 -ne $null) {
\n($_.Group[0].Backup1)}
\nelseif ($_.Group[1].Backup1 -ne $null) {
\n($_.Group[1].Backup1)}
\nelseif ($_.Group[2].Backup1 -ne $null) {
\n($_.Group[2].Backup1)}
\nelseif ($_.Group[3].Backup1 -ne $null) {
\n($_.Group[3].Backup1)}
\nelseif ($_.Group[4].Backup1 -ne $null) {
\n($_.Group[4].Backup1)}
\nelseif ($_.Group[5].Backup1 -ne $null) {
\n($_.Group[5].Backup1)}
\nelseif ($_.Group[6].Backup1 -ne $null) {
\n($_.Group[6].Backup1)}
\nelseif ($_.Group[7].Backup1 -ne $null) {
\n($_.Group[7].Backup1)}
\nelseif ($_.Group[8].Backup1 -ne $null) {
\n($_.Group[8].Backup1)}
\nelseif ($_.Group[9].Backup1 -ne $null) {
\n($_.Group[9].Backup1)}
\nelseif ($_.Group[10].Backup1 -ne $null) {
\n($_.Group[10].Backup1)};<\/p>\n

Backup3 = if ($_.Group[0].Backup3 -ne $null) {
\n($_.Group[0].Backup3)}
\nelseif ($_.Group[1].Backup3 -ne $null) {
\n($_.Group[1].Backup3)}
\nelseif ($_.Group[2].Backup3 -ne $null) {
\n($_.Group[2].Backup3)}
\nelseif ($_.Group[3].Backup3 -ne $null) {
\n($_.Group[3].Backup3)}
\nelseif ($_.Group[4].Backup3 -ne $null) {
\n($_.Group[4].Backup3)}
\nelseif ($_.Group[5].Backup3 -ne $null) {
\n($_.Group[5].Backup3)}
\nelseif ($_.Group[6].Backup3 -ne $null) {
\n($_.Group[6].Backup3)}
\nelseif ($_.Group[7].Backup3 -ne $null) {
\n($_.Group[7].Backup3)}
\nelseif ($_.Group[8].Backup3 -ne $null) {
\n($_.Group[8].Backup3)}
\nelseif ($_.Group[9].Backup3 -ne $null) {
\n($_.Group[9].Backup3)}
\nelseif ($_.Group[10].Backup3 -ne $null) {
\n($_.Group[10].Backup3)};
\nBackup4 = if ($_.Group[0].Backup4 -ne $null) {
\n($_.Group[0].Backup4)}
\nelseif ($_.Group[1].Backup4 -ne $null) {
\n($_.Group[1].Backup4)}
\nelseif ($_.Group[2].Backup4 -ne $null) {
\n($_.Group[2].Backup4)}
\nelseif ($_.Group[3].Backup4 -ne $null) {
\n($_.Group[3].Backup4)}
\nelseif ($_.Group[4].Backup4 -ne $null) {
\n($_.Group[4].Backup4)}
\nelseif ($_.Group[5].Backup4 -ne $null) {
\n($_.Group[5].Backup4)}
\nelseif ($_.Group[6].Backup4 -ne $null) {
\n($_.Group[6].Backup4)}
\nelseif ($_.Group[7].Backup4 -ne $null) {
\n($_.Group[7].Backup4)}
\nelseif ($_.Group[8].Backup4 -ne $null) {
\n($_.Group[8].Backup4)}
\nelseif ($_.Group[9].Backup4 -ne $null) {
\n($_.Group[9].Backup4)}
\nelseif ($_.Group[10].Backup4 -ne $null) {
\n($_.Group[10].Backup4)};
\nBackup5 = if ($_.Group[0].Backup5 -ne $null) {
\n($_.Group[0].Backup5)}
\nelseif ($_.Group[1].Backup5 -ne $null) {
\n($_.Group[1].Backup5)}
\nelseif ($_.Group[2].Backup5 -ne $null) {
\n($_.Group[2].Backup5)}
\nelseif ($_.Group[3].Backup5 -ne $null) {
\n($_.Group[3].Backup5)}
\nelseif ($_.Group[4].Backup5 -ne $null) {
\n($_.Group[4].Backup5)}
\nelseif ($_.Group[5].Backup5 -ne $null) {
\n($_.Group[5].Backup5)}
\nelseif ($_.Group[6].Backup5 -ne $null) {
\n($_.Group[6].Backup5)}
\nelseif ($_.Group[7].Backup5 -ne $null) {
\n($_.Group[7].Backup5)}
\nelseif ($_.Group[8].Backup5 -ne $null) {
\n($_.Group[8].Backup5)}
\nelseif ($_.Group[9].Backup5 -ne $null) {
\n($_.Group[9].Backup5)}
\nelseif ($_.Group[10].Backup5 -ne $null) {
\n($_.Group[10].Backup5)};
\nBackup6 = if ($_.Group[0].Backup6 -ne $null) {
\n($_.Group[0].Backup6)}
\nelseif ($_.Group[1].Backup6 -ne $null) {
\n($_.Group[1].Backup6)}
\nelseif ($_.Group[2].Backup6 -ne $null) {
\n($_.Group[2].Backup6)}
\nelseif ($_.Group[3].Backup6 -ne $null) {
\n($_.Group[3].Backup6)}
\nelseif ($_.Group[4].Backup6 -ne $null) {
\n($_.Group[4].Backup6)}
\nelseif ($_.Group[5].Backup6 -ne $null) {
\n($_.Group[5].Backup6)}
\nelseif ($_.Group[6].Backup6 -ne $null) {
\n($_.Group[6].Backup6)}
\nelseif ($_.Group[7].Backup6 -ne $null) {
\n($_.Group[7].Backup6)}
\nelseif ($_.Group[8].Backup6 -ne $null) {
\n($_.Group[8].Backup6)}
\nelseif ($_.Group[9].Backup6 -ne $null) {
\n($_.Group[9].Backup6)}
\nelseif ($_.Group[10].Backup6 -ne $null) {
\n($_.Group[10].Backup6)};
\nBackup7 = if ($_.Group[0].Backup7 -ne $null) {
\n($_.Group[0].Backup7)}
\nelseif ($_.Group[1].Backup7 -ne $null) {
\n($_.Group[1].Backup7)}
\nelseif ($_.Group[2].Backup7 -ne $null) {
\n($_.Group[2].Backup7)}
\nelseif ($_.Group[3].Backup7 -ne $null) {
\n($_.Group[3].Backup7)}
\nelseif ($_.Group[4].Backup7 -ne $null) {
\n($_.Group[4].Backup7)}
\nelseif ($_.Group[5].Backup7 -ne $null) {
\n($_.Group[5].Backup7)}
\nelseif ($_.Group[6].Backup7 -ne $null) {
\n($_.Group[6].Backup7)}
\nelseif ($_.Group[7].Backup7 -ne $null) {
\n($_.Group[7].Backup7)}
\nelseif ($_.Group[8].Backup7 -ne $null) {
\n($_.Group[8].Backup7)}
\nelseif ($_.Group[9].Backup7 -ne $null) {
\n($_.Group[9].Backup7)}
\nelseif ($_.Group[10].Backup7 -ne $null) {
\n($_.Group[10].Backup7)};
\nBackup8 = if ($_.Group[0].Backup8 -ne $null) {
\n($_.Group[0].Backup8)}
\nelseif ($_.Group[1].Backup8 -ne $null) {
\n($_.Group[1].Backup8)}
\nelseif ($_.Group[2].Backup8 -ne $null) {
\n($_.Group[2].Backup8)}
\nelseif ($_.Group[3].Backup8 -ne $null) {
\n($_.Group[3].Backup8)}
\nelseif ($_.Group[4].Backup8 -ne $null) {
\n($_.Group[4].Backup8)}
\nelseif ($_.Group[5].Backup8 -ne $null) {
\n($_.Group[5].Backup8)}
\nelseif ($_.Group[6].Backup8 -ne $null) {
\n($_.Group[6].Backup8)}
\nelseif ($_.Group[7].Backup8 -ne $null) {
\n($_.Group[7].Backup8)}
\nelseif ($_.Group[8].Backup8 -ne $null) {
\n($_.Group[8].Backup8)}
\nelseif ($_.Group[9].Backup8 -ne $null) {
\n($_.Group[9].Backup8)}
\nelseif ($_.Group[10].Backup8 -ne $null) {
\n($_.Group[10].Backup8)};
\n}
\n} | select Name,@{N="Weekend of $Date1";E={$_.Backup1}},@{N="$Date3";E={$_.Backup3}},@{N="$Date4";E={$_.Backup4}},@{N="$Date5";E={$_.Backup5}},@{N="$Date6";E={$_.Backup6}},@{N="$Date7";E={$_.Backup7}},@{N="Weekend of $Date8";E={$_.Backup8}} | Sort Name | ConvertTo-Html -Fragment #| set-cellcolor -Property $Date1 -Color red -Filter "$Date1 -like ‘Failed’" | set-cellcolor -Property $Date1 -Color ‘#00ff00’ -Filter "$Date1 -like ‘Success’" | set-cellcolor -Property $Date1 -Color ‘#FFFF00’ -Filter "$Date1 -like ‘Warning’"
\n}<\/p>\n

#Compile all of the fragments together ready for the report
\n$htmlOutput = $headerObj + $bodyTop + $BodySummHeader + $bodySummaryRp <\/p>\n

$htmlOutput = $htmlOutput.Replace("$($HTMLbreak + $footerObj)","$($footerObj)")
\n# Add color to output depending on results
\n#Green
\n$htmlOutput = $htmlOutput.Replace("<td>Running<","<td style=""color: #00b051;"">Running<")
\n$htmlOutput = $htmlOutput.Replace("<td>OK<","<td style=""color: #00b051;"">OK<")
\n$htmlOutput = $htmlOutput.Replace("<td>Alive<","<td style=""color: #00b051;"">Alive<")
\n$htmlOutput = $htmlOutput.Replace("<td>Success<","<td style=""background-color: #00b051;color: #ffffff;text-align: center;"">Success<")
\n#Yellow
\n$htmlOutput = $htmlOutput.Replace("<td>Warning<","<td style=""background-color: #ffc000;text-align: center;"">Warning<")
\n#Red
\n$htmlOutput = $htmlOutput.Replace("<td>Not Running<","<td style=""color: #ff0000;"">Not Running<")
\n$htmlOutput = $htmlOutput.Replace("<td>Failed<","<td style=""background-color: #ff0000;color: #ffffff;text-align: center;"">Failed<")
\n$htmlOutput = $htmlOutput.Replace("<td>Critical<","<td style=""color: #ff0000;"">Critical<")
\n$htmlOutput = $htmlOutput.Replace("<td>Dead<","<td style=""color: #ff0000;"">Dead<")<\/p>\n

#Save the report
\n$htmlOutput | Out-File $Outputlocation<\/p>\n

#Email the report
\n$Email = $htmlOutput<\/p>\n

$smtpServer = $smtpServerref
\n[string[]]$to = $emailTo
\n$from = $emailFrom
\n$subject = "Veeam Backup Report – $DateToday"
\n$body = ""
\n$body += $Email<\/p>\n

Send-MailMessage -SmtpServer $smtpServer -To $to -From $from -Subject $subject -Body $body -BodyAsHtml<\/p>\n

[\/powershell]<\/p>\n

Blog-a-Week 2018 Posting (BAW):<\/span><\/h5>\n

In previous years, I have had periods throughout the year where I have been unable to post an entry to myblog.\u00a0 During 2018, my aim is to post a blog entry each week of the year.\u00a0 I\u2019m hoping that the blog entries will all be useful bits of information or items that I\u2019ve been working on recently but if the standard of the entries drops, I apologise now, as this could have been a busy week and I wasn\u2019t able to put in as much time as I would have liked into the post<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Back in 2015, I created a 3-day Backup Report for Veeam that was based on the\u00a0\u2018SysAdmin Modular Report\u2019 (SAMReport) – this is the link to the original post for that report:\u00a0\u00a0http:\/\/virtualworlduk.co.uk\/3-day-veeam-backup-report-powercli\/ That report has been useful for a couple of years but I felt that I could do better, without having to link back to the vCenter server quite so […]<\/p>\n","protected":false},"author":1,"featured_media":891,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[3,8,9],"tags":[],"class_list":["post-888","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blogaweek2018","category-veeam","category-vmware"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/posts\/888","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/comments?post=888"}],"version-history":[{"count":0,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/posts\/888\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/media?parent=888"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/categories?post=888"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/tags?post=888"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}