"@
$subHead01suc = @"
"@
$subHead01war = @"
"@
$subHead01err = @"
"@
$HTMLbreak = @"
"@
$footerObj = @"
"@
#Get VM Backup Status
$vmStatus = @()
If ($showSummaryProtect + $showUnprotectedVMs + $showProtectedVMs) {
$vmStatus = Get-VMsBackupStatus
}
# VMs Missing Backups
$missingVMs = @($vmStatus | ?{$_.Status -match "!|Failed"})
ForEach ($VM in $missingVMs) {
If ($VM.Status -eq "!") {
$VM.Details = "No Backup Task has completed"
$VM.StartTime = ""
$VM.StopTime = ""
}
}
# VMs Successfuly Backed Up
$successVMs = @($vmStatus | ?{$_.Status -eq "Success"})
# VMs Backed Up w/Warning
$warnVMs = @($vmStatus | ?{$_.Status -eq "Warning"})
# Get VM Backup Protection Summary
$bodySummaryProtect = $null
$sumprotectHead = $subHead01
If ($showSummaryProtect) {
If (@($successVMs).Count -ge 1) {
$percentProt = 1
$sumprotectHead = $subHead01suc
}
If (@($warnVMs).Count -ge 1) {
$percentWarn = "*"
$sumprotectHead = $subHead01war
} Else {
$percentWarn = ""
}
If (@($missingVMs).Count -ge 1) {
$percentProt = (@($warnVMs).Count + @($successVMs).Count) / (@($warnVMs).Count + @($successVMs).Count + @($missingVMs).Count)
$sumprotectHead = $subHead01err
}
$vbrMasterHash = @{
WarningVM = @($warnVMs).Count
ProtectedVM = @($successVMs).Count
FailedVM = @($missingVMs).Count
PercentProt = "{0:P2}{1}" -f $percentProt,$percentWarn
}
$vbrMasterObj = New-Object -TypeName PSObject -Property $vbrMasterHash
$summaryProtect = $vbrMasterObj | Select @{Name="% Protected"; Expression = {$_.PercentProt}},
@{Name="Fully Protected VMs"; Expression = {$_.ProtectedVM}},
@{Name="Protected VMs w/Warnings"; Expression = {$_.WarningVM}},
@{Name="Unprotected VMs"; Expression = {$_.FailedVM}}
$bodySummaryProtect = $summaryProtect | ConvertTo-HTML -Fragment
$bodySummaryProtect = $sumprotectHead + "VM Backup Protection Summary" + $subHead02 + $bodySummaryProtect
}
# Get VMs Missing Backups
$bodyMissing = $null
If ($showUnprotectedVMs) {
If ($missingVMs -ne $null) {
$missingVMs = $missingVMs | Sort vCenter, Datacenter, Cluster, Name | Select Name, vCenter, Datacenter, Cluster, Folder,
@{Name="Last Start Time"; Expression = {$_.StartTime}}, @{Name="Last End Time"; Expression = {$_.StopTime}}, Details | ConvertTo-HTML -Fragment
$bodyMissing = $subHead01err + "VMs with No Successful Backups within RPO" + $subHead02 + $missingVMs
}
}
# Get VMs Backed Up w/Warnings
$bodyWarning = $null
If ($showProtectedVMs) {
If ($warnVMs -ne $null) {
$warnVMs = $warnVMs | Sort vCenter, Datacenter, Cluster, Name | Select Name, vCenter, Datacenter, Cluster, Folder,
@{Name="Last Start Time"; Expression = {$_.StartTime}}, @{Name="Last End Time"; Expression = {$_.StopTime}}, Details | ConvertTo-HTML -Fragment
$bodyWarning = $subHead01war + "VMs with only Backups with Warnings within RPO" + $subHead02 + $warnVMs
}
}
# Get VMs Successfuly Backed Up
$bodySuccess = $null
If ($showProtectedVMs) {
If ($successVMs -ne $null) {
$successVMs = $successVMs | Sort vCenter, Datacenter, Cluster, Name | Select Name, vCenter, Datacenter, Cluster, Folder,
@{Name="Last Start Time"; Expression = {$_.StartTime}}, @{Name="Last End Time"; Expression = {$_.StopTime}} | ConvertTo-HTML -Fragment
$bodySuccess = $subHead01suc + "VMs with Successful Backups within RPO" + $subHead02 + $successVMs
}
}
# Get VMs Backed Up by Multiple Jobs
$bodyMultiJobs = $null
If ($showMultiJobs) {
$multiJobs = @(Get-MultiJobs)
If ($multiJobs.Count -gt 0) {
$bodyMultiJobs = $multiJobs | Sort vCenter, Datacenter, Cluster, Name | Select Name, vCenter, Datacenter, Cluster, Folder,
@{Name="Job Name"; Expression = {$_.JobName}} | ConvertTo-HTML -Fragment
$bodyMultiJobs = $subHead01err + "VMs Backed Up by Multiple Jobs within RPO" + $subHead02 + $bodyMultiJobs
}
}
# Get Backup Summary Info
$bodySummaryBk = $null
If ($showSummaryBk) {
$vbrMasterHash = @{
"Failed" = @($failedSessionsBk).Count
"Sessions" = If ($sessListBk) {@($sessListBk).Count} Else {0}
"Read" = $totalReadBk
"Transferred" = $totalXferBk
"Successful" = @($successSessionsBk).Count
"Warning" = @($warningSessionsBk).Count
"Fails" = @($failsSessionsBk).Count
"Running" = @($runningSessionsBk).Count
}
$vbrMasterObj = New-Object -TypeName PSObject -Property $vbrMasterHash
If ($onlyLastBk) {
$total = "Jobs Run"
} Else {
$total = "Total Sessions"
}
$arrSummaryBk = $vbrMasterObj | Select @{Name=$total; Expression = {$_.Sessions}},
@{Name="Read (GB)"; Expression = {$_.Read}}, @{Name="Transferred (GB)"; Expression = {$_.Transferred}},
@{Name="Running"; Expression = {$_.Running}}, @{Name="Successful"; Expression = {$_.Successful}},
@{Name="Warnings"; Expression = {$_.Warning}}, @{Name="Failures"; Expression = {$_.Fails}},
@{Name="Failed"; Expression = {$_.Failed}}
$bodySummaryBk = $arrSummaryBk | ConvertTo-HTML -Fragment
If ($arrSummaryBk.Failed -gt 0) {
$summaryBkHead = $subHead01err
} ElseIf ($arrSummaryBk.Warnings -gt 0) {
$summaryBkHead = $subHead01war
} ElseIf ($arrSummaryBk.Successful -gt 0) {
$summaryBkHead = $subHead01suc
} Else {
$summaryBkHead = $subHead01
}
$bodySummaryBk = $summaryBkHead + "Backup Results Summary" + $subHead02 + $bodySummaryBk
}
# Get Backup Job Status
$bodyJobsBk = $null
If ($showJobsBk) {
If ($allJobsBk.count -gt 0) {
$bodyJobsBk = @()
Foreach($bkJob in $allJobsBk) {
$bodyJobsBk += $bkJob | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Enabled"; Expression = {$_.IsScheduleEnabled}},
@{Name="Status"; Expression = {
If ($bkJob.IsRunning) {
$currentSess = $runningSessionsBk | ?{$_.JobName -eq $bkJob.Name}
$csessPercent = $currentSess.Progress.Percents
$csessSpeed = [Math]::Round($currentSess.Progress.AvgSpeed/1MB,2)
$cStatus = "$($csessPercent)% completed at $($csessSpeed) MB/s"
$cStatus
} Else {
"Stopped"
}
}},
@{Name="Target Repo"; Expression = {
If ($($repoList | Where {$_.Id -eq $BkJob.Info.TargetRepositoryId}).Name) {
$($repoList | Where {$_.Id -eq $BkJob.Info.TargetRepositoryId}).Name
} Else {
$($repoListSo | Where {$_.Id -eq $BkJob.Info.TargetRepositoryId}).Name
}
}},
@{Name="Next Run"; Expression = {
If ($_.IsScheduleEnabled -eq $false) {""}
ElseIf ($_.Options.JobOptions.RunManually) {""}
ElseIf ($_.ScheduleOptions.IsContinious) {""}
ElseIf ($_.ScheduleOptions.OptionsScheduleAfterJob.IsEnabled) {"After [" + $(($allJobs + $allJobsTp) | Where {$_.Id -eq $bkJob.Info.ParentScheduleId}).Name + "]"}
Else {$_.ScheduleOptions.NextRun}
}},
@{Name="Last Result"; Expression = {If ($_.Info.LatestStatus -eq "None"){"Unknown"}Else{$_.Info.LatestStatus}}}
}
$bodyJobsBk = $bodyJobsBk | Sort "Next Run" | ConvertTo-HTML -Fragment
$bodyJobsBk = $subHead01 + "Backup Job Status" + $subHead02 + $bodyJobsBk
}
}
# Get Backup Job Size
$bodyJobSizeBk = $null
If ($showBackupSizeBk) {
If ($backupsBk.count -gt 0) {
$bodyJobSizeBk = Get-BackupSize -backups $backupsBk | Sort JobName | Select @{Name="Job Name"; Expression = {$_.JobName}},
@{Name="VM Count"; Expression = {$_.VMCount}},
@{Name="Repository"; Expression = {$_.Repo}},
@{Name="Data Size (GB)"; Expression = {$_.DataSize}},
@{Name="Backup Size (GB)"; Expression = {$_.BackupSize}} | ConvertTo-HTML -Fragment
$bodyJobSizeBk = $subHead01 + "Backup Job Size" + $subHead02 + $bodyJobSizeBk
}
}
# Get all Backup Sessions
$bodyAllSessBk = $null
If ($showAllSessBk) {
If ($sessListBk.count -gt 0) {
If ($showDetailedBk) {
$arrAllSessBk = $sessListBk | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="State"; Expression = {$_.State}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {If ($_.EndTime -eq "1/1/1900 12:00:00 AM"){"-"} Else {$_.EndTime}}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Progress.AvgSpeed/1MB,2)}},
@{Name="Total (GB)"; Expression = {[Math]::Round($_.Progress.ProcessedSize/1GB,2)}},
@{Name="Processed (GB)"; Expression = {[Math]::Round($_.Progress.ProcessedUsedSize/1GB,2)}},
@{Name="Data Read (GB)"; Expression = {[Math]::Round($_.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Progress.TransferedSize/1GB,2)}},
@{Name="Dedupe"; Expression = {
If ($_.Progress.ReadSize -eq 0) {0}
Else {([string][Math]::Round($_.BackupStats.GetDedupeX(),1)) +"x"}}},
@{Name="Compression"; Expression = {
If ($_.Progress.ReadSize -eq 0) {0}
Else {([string][Math]::Round($_.BackupStats.GetCompressX(),1)) +"x"}}},
@{Name="Details"; Expression = {($_.GetDetails()).Replace("
","ZZbrZZ")}}, Result
$bodyAllSessBk = $arrAllSessBk | select 'Job Name','State','Start Time','Stop Time','Duration (HH:MM:SS)','Result' |ConvertTo-csv
} Else {
$arrAllSessBk = $sessListBk | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="State"; Expression = {$_.State}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {If ($_.EndTime -eq "1/1/1900 12:00:00 AM"){"-"} Else {$_.EndTime}}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Details"; Expression = {($_.GetDetails()).Replace("
","ZZbrZZ")}}, Result
$bodyAllSessBk = $arrAllSessBk | select 'Job Name','State','Start Time','Stop Time','Duration (HH:MM:SS)','Result' | ConvertTo-csv
}
}
}
# Get Running Backup Jobs
$bodyRunningBk = $null
If ($showRunningBk) {
If ($runningSessionsBk.count -gt 0) {
$bodyRunningBk = $runningSessionsBk | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Progress.AvgSpeed/1MB,2)}},
@{Name="Read (GB)"; Expression = {[Math]::Round([Decimal]$_.Progress.ReadSize/1GB, 2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round([Decimal]$_.Progress.TransferedSize/1GB, 2)}},
@{Name="% Complete"; Expression = {$_.Progress.Percents}} | ConvertTo-HTML -Fragment
$bodyRunningBk = $subHead01 + "Running Backup Jobs" + $subHead02 + $bodyRunningBk
}
}
# Get Backup Sessions with Warnings or Failures
$bodySessWFBk = $null
If ($showWarnFailBk) {
$sessWF = @($warningSessionsBk + $failsSessionsBk)
If ($sessWF.count -gt 0) {
If ($onlyLastBk) {
$headerWF = "Backup Jobs with Warnings or Failures"
} Else {
$headerWF = "Backup Sessions with Warnings or Failures"
}
If ($showDetailedBk) {
$arrSessWFBk = $sessWF | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {$_.EndTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Progress.AvgSpeed/1MB,2)}},
@{Name="Total (GB)"; Expression = {[Math]::Round($_.Progress.ProcessedSize/1GB,2)}},
@{Name="Processed (GB)"; Expression = {[Math]::Round($_.Progress.ProcessedUsedSize/1GB,2)}},
@{Name="Data Read (GB)"; Expression = {[Math]::Round($_.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Progress.TransferedSize/1GB,2)}},
@{Name="Dedupe"; Expression = {
If ($_.Progress.ReadSize -eq 0) {0}
Else {([string][Math]::Round($_.BackupStats.GetDedupeX(),1)) +"x"}}},
@{Name="Compression"; Expression = {
If ($_.Progress.ReadSize -eq 0) {0}
Else {([string][Math]::Round($_.BackupStats.GetCompressX(),1)) +"x"}}},
@{Name="Details"; Expression = {
If ($_.GetDetails() -eq ""){$_ | Get-VBRTaskSession | %{If ($_.GetDetails()){$_.Name + ": " + ($_.GetDetails()).Replace("
","ZZbrZZ")}}}
Else {($_.GetDetails()).Replace("
","ZZbrZZ")}}}, Result
$bodySessWFBk = $arrSessWFBk | ConvertTo-HTML -Fragment
If ($arrSessWFBk.Result -match "Failed") {
$sessWFBkHead = $subHead01err
} ElseIf ($arrSessWFBk.Result -match "Warning") {
$sessWFBkHead = $subHead01war
} ElseIf ($arrSessWFBk.Result -match "Success") {
$sessWFBkHead = $subHead01suc
} Else {
$sessWFBkHead = $subHead01
}
$bodySessWFBk = $sessWFBkHead + $headerWF + $subHead02 + $bodySessWFBk
} Else {
$arrSessWFBk = $sessWF | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {$_.EndTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Details"; Expression = {
If ($_.GetDetails() -eq ""){$_ | Get-VBRTaskSession | %{If ($_.GetDetails()){$_.Name + ": " + ($_.GetDetails()).Replace("
","ZZbrZZ")}}}
Else {($_.GetDetails()).Replace("
","ZZbrZZ")}}}, Result
$bodySessWFBk = $arrSessWFBk | ConvertTo-HTML -Fragment
If ($arrSessWFBk.Result -match "Failed") {
$sessWFBkHead = $subHead01err
} ElseIf ($arrSessWFBk.Result -match "Warning") {
$sessWFBkHead = $subHead01war
} ElseIf ($arrSessWFBk.Result -match "Success") {
$sessWFBkHead = $subHead01suc
} Else {
$sessWFBkHead = $subHead01
}
$bodySessWFBk = $sessWFBkHead + $headerWF + $subHead02 + $bodySessWFBk
}
}
}
# Get Successful Backup Sessions
$bodySessSuccBk = $null
If ($showSuccessBk) {
If ($successSessionsBk.count -gt 0) {
If ($onlyLastBk) {
$headerSucc = "Successful Backup Jobs"
} Else {
$headerSucc = "Successful Backup Sessions"
}
If ($showDetailedBk) {
$bodySessSuccBk = $successSessionsBk | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {$_.EndTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Progress.AvgSpeed/1MB,2)}},
@{Name="Total (GB)"; Expression = {[Math]::Round($_.Progress.ProcessedSize/1GB,2)}},
@{Name="Processed (GB)"; Expression = {[Math]::Round($_.Progress.ProcessedUsedSize/1GB,2)}},
@{Name="Data Read (GB)"; Expression = {[Math]::Round($_.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Progress.TransferedSize/1GB,2)}},
@{Name="Dedupe"; Expression = {
If ($_.Progress.ReadSize -eq 0) {0}
Else {([string][Math]::Round($_.BackupStats.GetDedupeX(),1)) +"x"}}},
@{Name="Compression"; Expression = {
If ($_.Progress.ReadSize -eq 0) {0}
Else {([string][Math]::Round($_.BackupStats.GetCompressX(),1)) +"x"}}},
Result | ConvertTo-HTML -Fragment
$bodySessSuccBk = $subHead01suc + $headerSucc + $subHead02 + $bodySessSuccBk
} Else {
$bodySessSuccBk = $successSessionsBk | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {$_.EndTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
Result | ConvertTo-HTML -Fragment
$bodySessSuccBk = $subHead01suc + $headerSucc + $subHead02 + $bodySessSuccBk
}
}
}
## Gathering tasks after session info has been recorded due to Veeam issue
# Gather all Backup Tasks from Sessions within time frame
$taskListBk = @()
$taskListBk += $sessListBk | Get-VBRTaskSession
$successTasksBk = @($taskListBk | ?{$_.Status -eq "Success"})
$wfTasksBk = @($taskListBk | ?{$_.Status -match "Warning|Failed"})
$runningTasksBk = @()
$runningTasksBk += $runningSessionsBk | Get-VBRTaskSession | ?{$_.Status -match "Pending|InProgress"}
# Get all Backup Tasks
$bodyAllTasksBk = $null
If ($showAllTasksBk) {
If ($taskListBk.count -gt 0) {
If ($showDetailedBk) {
$arrAllTasksBk = $taskListBk | Select @{Name="VM Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Progress.StartTimeLocal}},
@{Name="Stop Time"; Expression = {If ($_.Progress.StopTimeLocal -eq "1/1/1900 12:00:00 AM"){"-"} Else {$_.Progress.StopTimeLocal}}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Progress.AvgSpeed/1MB,2)}},
@{Name="Total (GB)"; Expression = {[Math]::Round($_.Progress.ProcessedSize/1GB,2)}},
@{Name="Processed (GB)"; Expression = {[Math]::Round($_.Progress.ProcessedUsedSize/1GB,2)}},
@{Name="Data Read (GB)"; Expression = {[Math]::Round($_.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Progress.TransferedSize/1GB,2)}},
@{Name="Details"; Expression = {($_.GetDetails()).Replace("
","ZZbrZZ")}}, Status
$bodyAllTasksBk = $arrAllTasksBk | Sort "Start Time" | ConvertTo-csv
} Else {
$arrAllTasksBk = $taskListBk | Select @{Name="VM Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Progress.StartTimeLocal}},
@{Name="Stop Time"; Expression = {If ($_.Progress.StopTimeLocal -eq "1/1/1900 12:00:00 AM"){"-"} Else {$_.Progress.StopTimeLocal}}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Details"; Expression = {($_.GetDetails()).Replace("
","ZZbrZZ")}}, Status
$bodyAllTasksBk = $arrAllTasksBk | Sort "Start Time" | ConvertTo-csv
}
}
}
# Get Running Backup Tasks
$bodyTasksRunningBk = $null
If ($showRunningTasksBk) {
If ($runningTasksBk.count -gt 0) {
$bodyTasksRunningBk = $runningTasksBk | Select @{Name="VM Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Info.Progress.StartTimeLocal}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Progress.AvgSpeed/1MB,2)}},
@{Name="Read (GB)"; Expression = {[Math]::Round($_.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Progress.TransferedSize/1GB,2)}},
Status | Sort "Start Time" | ConvertTo-HTML -Fragment
$bodyTasksRunningBk = $subHead01 + "Running Backup Tasks" + $subHead02 + $bodyTasksRunningBk
}
}
# Get Backup Tasks with Warnings or Failures
$bodyTaskWFBk = $null
If ($showTaskWFBk) {
If ($wfTasksBk.count -gt 0) {
If ($showDetailedBk) {
$arrTaskWFBk = $wfTasksBk | Select @{Name="VM Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Progress.StartTimeLocal}},
@{Name="Stop Time"; Expression = {$_.Progress.StopTimeLocal}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Progress.AvgSpeed/1MB,2)}},
@{Name="Total (GB)"; Expression = {[Math]::Round($_.Progress.ProcessedSize/1GB,2)}},
@{Name="Processed (GB)"; Expression = {[Math]::Round($_.Progress.ProcessedUsedSize/1GB,2)}},
@{Name="Data Read (GB)"; Expression = {[Math]::Round($_.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Progress.TransferedSize/1GB,2)}},
@{Name="Details"; Expression = {($_.GetDetails()).Replace("
","ZZbrZZ")}}, Status
$bodyTaskWFBk = $arrTaskWFBk | Sort "Start Time" | ConvertTo-HTML -Fragment
If ($arrTaskWFBk.Status -match "Failed") {
$taskWFBkHead = $subHead01err
} ElseIf ($arrTaskWFBk.Status -match "Warning") {
$taskWFBkHead = $subHead01war
} ElseIf ($arrTaskWFBk.Status -match "Success") {
$taskWFBkHead = $subHead01suc
} Else {
$taskWFBkHead = $subHead01
}
$bodyTaskWFBk = $taskWFBkHead + "Backup Tasks with Warnings or Failures" + $subHead02 + $bodyTaskWFBk
} Else {
$arrTaskWFBk = $wfTasksBk | Select @{Name="VM Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Progress.StartTimeLocal}},
@{Name="Stop Time"; Expression = {$_.Progress.StopTimeLocal}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Details"; Expression = {($_.GetDetails()).Replace("
","ZZbrZZ")}}, Status
$bodyTaskWFBk = $arrTaskWFBk | Sort "Start Time" | ConvertTo-HTML -Fragment
If ($arrTaskWFBk.Status -match "Failed") {
$taskWFBkHead = $subHead01err
} ElseIf ($arrTaskWFBk.Status -match "Warning") {
$taskWFBkHead = $subHead01war
} ElseIf ($arrTaskWFBk.Status -match "Success") {
$taskWFBkHead = $subHead01suc
} Else {
$taskWFBkHead = $subHead01
}
$bodyTaskWFBk = $taskWFBkHead + "Backup Tasks with Warnings or Failures" + $subHead02 + $bodyTaskWFBk
}
}
}
# Get Successful Backup Tasks
$bodyTaskSuccBk = $null
If ($showTaskSuccessBk) {
If ($successTasksBk.count -gt 0) {
If ($showDetailedBk) {
$bodyTaskSuccBk = $successTasksBk | Select @{Name="VM Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Progress.StartTimeLocal}},
@{Name="Stop Time"; Expression = {$_.Progress.StopTimeLocal}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Progress.AvgSpeed/1MB,2)}},
@{Name="Total (GB)"; Expression = {[Math]::Round($_.Progress.ProcessedSize/1GB,2)}},
@{Name="Processed (GB)"; Expression = {[Math]::Round($_.Progress.ProcessedUsedSize/1GB,2)}},
@{Name="Data Read (GB)"; Expression = {[Math]::Round($_.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Progress.TransferedSize/1GB,2)}},
Status | Sort "Start Time" | ConvertTo-HTML -Fragment
$bodyTaskSuccBk = $subHead01suc + "Successful Backup Tasks" + $subHead02 + $bodyTaskSuccBk
} Else {
$bodyTaskSuccBk = $successTasksBk | Select @{Name="VM Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Progress.StartTimeLocal}},
@{Name="Stop Time"; Expression = {$_.Progress.StopTimeLocal}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
Status | Sort "Start Time" | ConvertTo-HTML -Fragment
$bodyTaskSuccBk = $subHead01suc + "Successful Backup Tasks" + $subHead02 + $bodyTaskSuccBk
}
}
}
# Get Running VM Restore Sessions
$bodyRestoRunVM = $null
If ($showRestoRunVM) {
If ($($runningResto).count -gt 0) {
$bodyRestoRunVM = $runningResto | Sort CreationTime | Select @{Name="VM Name"; Expression = {$_.Info.VmDisplayName}},
@{Name="Restore Type"; Expression = {$_.JobTypeString}}, @{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Initiator"; Expression = {$_.Info.Initiator.Name}},
@{Name="Reason"; Expression = {$_.Info.Reason}} | ConvertTo-HTML -Fragment
$bodyRestoRunVM = $subHead01 + "Running VM Restore Sessions" + $subHead02 + $bodyRestoRunVM
}
}
# Get Completed VM Restore Sessions
$bodyRestoreVM = $null
If ($showRestoreVM) {
If ($($completeResto).count -gt 0) {
$arrRestoreVM = $completeResto | Sort CreationTime | Select @{Name="VM Name"; Expression = {$_.Info.VmDisplayName}},
@{Name="Restore Type"; Expression = {$_.JobTypeString}},
@{Name="Start Time"; Expression = {$_.CreationTime}}, @{Name="Stop Time"; Expression = {$_.EndTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $(New-TimeSpan $_.CreationTime $_.EndTime)}},
@{Name="Initiator"; Expression = {$_.Info.Initiator.Name}}, @{Name="Reason"; Expression = {$_.Info.Reason}},
@{Name="Result"; Expression = {$_.Info.Result}}
$bodyRestoreVM = $arrRestoreVM | ConvertTo-HTML -Fragment
If ($arrRestoreVM.Result -match "Failed") {
$restoreVMHead = $subHead01err
} ElseIf ($arrRestoreVM.Result -match "Warning") {
$restoreVMHead = $subHead01war
} ElseIf ($arrRestoreVM.Result -match "Success") {
$restoreVMHead = $subHead01suc
} Else {
$restoreVMHead = $subHead01
}
$bodyRestoreVM = $restoreVMHead + "Completed VM Restore Sessions" + $subHead02 + $bodyRestoreVM
}
}
# Get Replication Summary Info
$bodySummaryRp = $null
If ($showSummaryRp) {
$vbrMasterHash = @{
"Failed" = @($failedSessionsRp).Count
"Sessions" = If ($sessListRp) {@($sessListRp).Count} Else {0}
"Read" = $totalReadRp
"Transferred" = $totalXferRp
"Successful" = @($successSessionsRp).Count
"Warning" = @($warningSessionsRp).Count
"Fails" = @($failsSessionsRp).Count
"Running" = @($runningSessionsRp).Count
}
$vbrMasterObj = New-Object -TypeName PSObject -Property $vbrMasterHash
If ($onlyLastRp) {
$total = "Jobs Run"
} Else {
$total = "Total Sessions"
}
$arrSummaryRp = $vbrMasterObj | Select @{Name=$total; Expression = {$_.Sessions}},
@{Name="Read (GB)"; Expression = {$_.Read}}, @{Name="Transferred (GB)"; Expression = {$_.Transferred}},
@{Name="Running"; Expression = {$_.Running}}, @{Name="Successful"; Expression = {$_.Successful}},
@{Name="Warnings"; Expression = {$_.Warning}},
@{Name="Failed"; Expression = {$_.Failed}}
$bodySummaryRp = $arrSummaryRp | ConvertTo-HTML -Fragment
If ($arrSummaryRp.Failed -gt 0) {
$summaryRpHead = $subHead01err
} ElseIf ($arrSummaryRp.Warnings -gt 0) {
$summaryRpHead = $subHead01war
} ElseIf ($arrSummaryRp.Successful -gt 0) {
$summaryRpHead = $subHead01suc
} Else {
$summaryRpHead = $subHead01
}
$bodySummaryRp = $summaryRpHead + "Replication Results Summary" + $subHead02 + $bodySummaryRp
}
# Get Replication Job Status
$bodyJobsRp = $null
If ($showJobsRp) {
If ($allJobsRp.count -gt 0) {
$bodyJobsRp = @()
Foreach($rpJob in $allJobsRp) {
$bodyJobsRp += $rpJob | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Enabled"; Expression = {$_.Info.IsScheduleEnabled}},
@{Name="Status"; Expression = {
If ($rpJob.IsRunning) {
$currentSess = $runningSessionsRp | ?{$_.JobName -eq $rpJob.Name}
$csessPercent = $currentSess.Progress.Percents
$csessSpeed = [Math]::Round($currentSess.Info.Progress.AvgSpeed/1MB,2)
$cStatus = "$($csessPercent)% completed at $($csessSpeed) MB/s"
$cStatus
} Else {
"Stopped"
}
}},
@{Name="Target"; Expression = {$(Get-VBRServer | Where {$_.Id -eq $rpJob.Info.TargetHostId}).Name}},
@{Name="Target Repo"; Expression = {
If ($($repoList | Where {$_.Id -eq $rpJob.Info.TargetRepositoryId}).Name) {$($repoList | Where {$_.Id -eq $rpJob.Info.TargetRepositoryId}).Name}
Else {$($repoListSo | Where {$_.Id -eq $rpJob.Info.TargetRepositoryId}).Name}}},
@{Name="Next Run"; Expression = {
If ($_.IsScheduleEnabled -eq $false) {""}
ElseIf ($_.Options.JobOptions.RunManually) {""}
ElseIf ($_.ScheduleOptions.IsContinious) {""}
ElseIf ($_.ScheduleOptions.OptionsScheduleAfterJob.IsEnabled) {"After [" + $(($allJobs + $allJobsTp) | Where {$_.Id -eq $rpJob.Info.ParentScheduleId}).Name + "]"}
Else {$_.ScheduleOptions.NextRun}}},
@{Name="Last Result"; Expression = {If ($_.Info.LatestStatus -eq "None"){""}Else{$_.Info.LatestStatus}}}
}
$bodyJobsRp = $bodyJobsRp | Sort "Next Run" | ConvertTo-HTML -Fragment
$bodyJobsRp = $subHead01 + "Replication Job Status" + $subHead02 + $bodyJobsRp
}
}
# Get Replication Sessions
$bodyAllSessRp = $null
If ($showAllSessRp) {
If ($sessListRp.count -gt 0) {
If ($showDetailedRp) {
$arrAllSessRp = $sessListRp | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="State"; Expression = {$_.State}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {If ($_.EndTime -eq "1/1/1900 12:00:00 AM"){"-"} Else {$_.EndTime}}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Info.Progress.AvgSpeed/1MB,2)}},
@{Name="Total (GB)"; Expression = {[Math]::Round($_.Info.Progress.ProcessedSize/1GB,2)}},
@{Name="Processed (GB)"; Expression = {[Math]::Round($_.Info.Progress.ProcessedUsedSize/1GB,2)}},
@{Name="Data Read (GB)"; Expression = {[Math]::Round($_.Info.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Info.Progress.TransferedSize/1GB,2)}},
@{Name="Dedupe"; Expression = {
If ($_.Progress.ReadSize -eq 0) {0}
Else {([string][Math]::Round($_.BackupStats.GetDedupeX(),1)) +"x"}}},
@{Name="Compression"; Expression = {
If ($_.Progress.ReadSize -eq 0) {0}
Else {([string][Math]::Round($_.BackupStats.GetCompressX(),1)) +"x"}}},
@{Name="Details"; Expression = {($_.GetDetails()).Replace("
","ZZbrZZ")}}, Result
$bodyAllSessRp = $arrAllSessRp | ConvertTo-HTML -Fragment
If ($arrAllSessRp.Result -match "Failed") {
$allSessRpHead = $subHead01err
} ElseIf ($arrAllSessRp.Result -match "Warning") {
$allSessRpHead = $subHead01war
} ElseIf ($arrAllSessRp.Result -match "Success") {
$allSessRpHead = $subHead01suc
} Else {
$allSessRpHead = $subHead01
}
$bodyAllSessRp = $allSessRpHead + "Replication Sessions" + $subHead02 + $bodyAllSessRp
} Else {
$arrAllSessRp = $sessListRp | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="State"; Expression = {$_.State}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {If ($_.EndTime -eq "1/1/1900 12:00:00 AM"){"-"} Else {$_.EndTime}}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Details"; Expression = {($_.GetDetails()).Replace("
","ZZbrZZ")}}, Result
$bodyAllSessRp = $arrAllSessRp | ConvertTo-HTML -Fragment
If ($arrAllSessRp.Result -match "Failed") {
$allSessRpHead = $subHead01err
} ElseIf ($arrAllSessRp.Result -match "Warning") {
$allSessRpHead = $subHead01war
} ElseIf ($arrAllSessRp.Result -match "Success") {
$allSessRpHead = $subHead01suc
} Else {
$allSessRpHead = $subHead01
}
$bodyAllSessRp = $allSessRpHead + "Replication Sessions" + $subHead02 + $bodyAllSessRp
}
}
}
# Get Running Replication Jobs
$bodyRunningRp = $null
If ($showRunningRp) {
If ($runningSessionsRp.count -gt 0) {
$bodyRunningRp = $runningSessionsRp | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Info.Progress.AvgSpeed/1MB,2)}},
@{Name="Read (GB)"; Expression = {[Math]::Round([Decimal]$_.Progress.ReadSize/1GB, 2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round([Decimal]$_.Progress.TransferedSize/1GB, 2)}},
@{Name="% Complete"; Expression = {$_.Progress.Percents}} | ConvertTo-HTML -Fragment
$bodyRunningRp = $subHead01 + "Running Replication Jobs" + $subHead02 + $bodyRunningRp
}
}
# Get Replication Sessions with Warnings or Failures
$bodySessWFRp = $null
If ($showWarnFailRp) {
$sessWF = @($warningSessionsRp + $failsSessionsRp)
If ($sessWF.count -gt 0) {
If ($onlyLastRp) {
$headerWF = "Replication Jobs with Warnings or Failures"
} Else {
$headerWF = "Replication Sessions with Warnings or Failures"
}
If ($showDetailedRp) {
$arrSessWFRp = $sessWF | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {$_.EndTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Info.Progress.AvgSpeed/1MB,2)}},
@{Name="Total (GB)"; Expression = {[Math]::Round($_.Info.Progress.ProcessedSize/1GB,2)}},
@{Name="Processed (GB)"; Expression = {[Math]::Round($_.Info.Progress.ProcessedUsedSize/1GB,2)}},
@{Name="Data Read (GB)"; Expression = {[Math]::Round($_.Info.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Info.Progress.TransferedSize/1GB,2)}},
@{Name="Dedupe"; Expression = {
If ($_.Progress.ReadSize -eq 0) {0}
Else {([string][Math]::Round($_.BackupStats.GetDedupeX(),1)) +"x"}}},
@{Name="Compression"; Expression = {
If ($_.Progress.ReadSize -eq 0) {0}
Else {([string][Math]::Round($_.BackupStats.GetCompressX(),1)) +"x"}}},
@{Name="Details"; Expression = {
If ($_.GetDetails() -eq ""){$_ | Get-VBRTaskSession | %{If ($_.GetDetails()){$_.Name + ": " + ($_.GetDetails()).Replace("
","ZZbrZZ")}}}
Else {($_.GetDetails()).Replace("
","ZZbrZZ")}}}, Result
$bodySessWFRp = $arrSessWFRp | ConvertTo-HTML -Fragment
If ($arrSessWFRp.Result -match "Failed") {
$sessWFRpHead = $subHead01err
} ElseIf ($arrSessWFRp.Result -match "Warning") {
$sessWFRpHead = $subHead01war
} ElseIf ($arrSessWFRp.Result -match "Success") {
$sessWFRpHead = $subHead01suc
} Else {
$sessWFRpHead = $subHead01
}
$bodySessWFRp = $sessWFRpHead + $headerWF + $subHead02 + $bodySessWFRp
} Else {
$arrSessWFRp = $sessWF | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {$_.EndTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Details"; Expression = {
If ($_.GetDetails() -eq ""){$_ | Get-VBRTaskSession | %{If ($_.GetDetails()){$_.Name + ": " + ($_.GetDetails()).Replace("
","ZZbrZZ")}}}
Else {($_.GetDetails()).Replace("
","ZZbrZZ")}}}, Result
$bodySessWFRp = $arrSessWFRp | ConvertTo-HTML -Fragment
If ($arrSessWFRp.Result -match "Failed") {
$sessWFRpHead = $subHead01err
} ElseIf ($arrSessWFRp.Result -match "Warning") {
$sessWFRpHead = $subHead01war
} ElseIf ($arrSessWFRp.Result -match "Success") {
$sessWFRpHead = $subHead01suc
} Else {
$sessWFRpHead = $subHead01
}
$bodySessWFRp = $sessWFRpHead + $headerWF + $subHead02 + $bodySessWFRp
}
}
}
# Get Successful Replication Sessions
$bodySessSuccRp = $null
If ($showSuccessRp) {
If ($successSessionsRp.count -gt 0) {
If ($onlyLastRp) {
$headerSucc = "Successful Replication Jobs"
} Else {
$headerSucc = "Successful Replication Sessions"
}
If ($showDetailedRp) {
$bodySessSuccRp = $successSessionsRp | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {$_.EndTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Info.Progress.AvgSpeed/1MB,2)}},
@{Name="Total (GB)"; Expression = {[Math]::Round($_.Info.Progress.ProcessedSize/1GB,2)}},
@{Name="Processed (GB)"; Expression = {[Math]::Round($_.Info.Progress.ProcessedUsedSize/1GB,2)}},
@{Name="Data Read (GB)"; Expression = {[Math]::Round($_.Info.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Info.Progress.TransferedSize/1GB,2)}},
@{Name="Dedupe"; Expression = {
If ($_.Progress.ReadSize -eq 0) {0}
Else {([string][Math]::Round($_.BackupStats.GetDedupeX(),1)) +"x"}}},
@{Name="Compression"; Expression = {
If ($_.Progress.ReadSize -eq 0) {0}
Else {([string][Math]::Round($_.BackupStats.GetCompressX(),1)) +"x"}}},
Result | ConvertTo-HTML -Fragment
$bodySessSuccRp = $subHead01suc + $headerSucc + $subHead02 + $bodySessSuccRp
} Else {
$bodySessSuccRp = $successSessionsRp | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {$_.EndTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
Result | ConvertTo-HTML -Fragment
$bodySessSuccRp = $subHead01suc + $headerSucc + $subHead02 + $bodySessSuccRp
}
}
}
## Gathering tasks after session info has been recorded due to Veeam issue
# Gather all Replication Tasks from Sessions within time frame
$taskListRp = @()
$taskListRp += $sessListRp | Get-VBRTaskSession
$successTasksRp = @($taskListRp | ?{$_.Status -eq "Success"})
$wfTasksRp = @($taskListRp | ?{$_.Status -match "Warning|Failed"})
$runningTasksRp = @()
$runningTasksRp += $runningSessionsRp | Get-VBRTaskSession | ?{$_.Status -match "Pending|InProgress"}
# Get Replication Tasks
$bodyAllTasksRp = $null
If ($showAllTasksRp) {
If ($taskListRp.count -gt 0) {
If ($showDetailedRp) {
$arrAllTasksRp = $taskListRp | Select @{Name="VM Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Progress.StartTimeLocal}},
@{Name="Stop Time"; Expression = {If ($_.Progress.StopTimeLocal -eq "1/1/1900 12:00:00 AM"){"-"} Else {$_.Progress.StopTimeLocal}}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Progress.AvgSpeed/1MB,2)}},
@{Name="Total (GB)"; Expression = {[Math]::Round($_.Progress.ProcessedSize/1GB,2)}},
@{Name="Processed (GB)"; Expression = {[Math]::Round($_.Progress.ProcessedUsedSize/1GB,2)}},
@{Name="Data Read (GB)"; Expression = {[Math]::Round($_.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Progress.TransferedSize/1GB,2)}},
@{Name="Details"; Expression = {($_.GetDetails()).Replace("
","ZZbrZZ")}}, Status
$bodyAllTasksRp = $arrAllTasksRp | Sort "Start Time" | ConvertTo-HTML -Fragment
If ($arrAllTasksRp.Status -match "Failed") {
$allTasksRpHead = $subHead01err
} ElseIf ($arrAllTasksRp.Status -match "Warning") {
$allTasksRpHead = $subHead01war
} ElseIf ($arrAllTasksRp.Status -match "Success") {
$allTasksRpHead = $subHead01suc
} Else {
$allTasksRpHead = $subHead01
}
$bodyAllTasksRp = $allTasksRpHead + "Replication Tasks" + $subHead02 + $bodyAllTasksRp
} Else {
$arrAllTasksRp = $taskListRp | Select @{Name="VM Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Progress.StartTimeLocal}},
@{Name="Stop Time"; Expression = {If ($_.Progress.StopTimeLocal -eq "1/1/1900 12:00:00 AM"){"-"} Else {$_.Progress.StopTimeLocal}}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Details"; Expression = {($_.GetDetails()).Replace("
","ZZbrZZ")}}, Status
$bodyAllTasksRp = $arrAllTasksRp | Sort "Start Time" | ConvertTo-HTML -Fragment
If ($arrAllTasksRp.Status -match "Failed") {
$allTasksRpHead = $subHead01err
} ElseIf ($arrAllTasksRp.Status -match "Warning") {
$allTasksRpHead = $subHead01war
} ElseIf ($arrAllTasksRp.Status -match "Success") {
$allTasksRpHead = $subHead01suc
} Else {
$allTasksRpHead = $subHead01
}
$bodyAllTasksRp = $allTasksRpHead + "Replication Tasks" + $subHead02 + $bodyAllTasksRp
}
}
}
# Get Running Replication Tasks
$bodyTasksRunningRp = $null
If ($showRunningTasksRp) {
If ($runningTasksRp.count -gt 0) {
$bodyTasksRunningRp = $runningTasksRp | Select @{Name="VM Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Info.Progress.StartTimeLocal}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Progress.AvgSpeed/1MB,2)}},
@{Name="Read (GB)"; Expression = {[Math]::Round($_.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Progress.TransferedSize/1GB,2)}},
Status | Sort "Start Time" | ConvertTo-HTML -Fragment
$bodyTasksRunningRp = $subHead01 + "Running Replication Tasks" + $subHead02 + $bodyTasksRunningRp
}
}
# Get Replication Tasks with Warnings or Failures
$bodyTaskWFRp = $null
If ($showTaskWFRp) {
If ($wfTasksRp.count -gt 0) {
If ($showDetailedRp) {
$arrTaskWFRp = $wfTasksRp | Select @{Name="VM Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Progress.StartTimeLocal}},
@{Name="Stop Time"; Expression = {$_.Progress.StopTimeLocal}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Progress.AvgSpeed/1MB,2)}},
@{Name="Total (GB)"; Expression = {[Math]::Round($_.Progress.ProcessedSize/1GB,2)}},
@{Name="Processed (GB)"; Expression = {[Math]::Round($_.Progress.ProcessedUsedSize/1GB,2)}},
@{Name="Data Read (GB)"; Expression = {[Math]::Round($_.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Progress.TransferedSize/1GB,2)}},
@{Name="Details"; Expression = {($_.GetDetails()).Replace("
","ZZbrZZ")}}, Status
$bodyTaskWFRp = $arrTaskWFRp | Sort "Start Time" | ConvertTo-HTML -Fragment
If ($arrTaskWFRp.Status -match "Failed") {
$taskWFRpHead = $subHead01err
} ElseIf ($arrTaskWFRp.Status -match "Warning") {
$taskWFRpHead = $subHead01war
} ElseIf ($arrTaskWFRp.Status -match "Success") {
$taskWFRpHead = $subHead01suc
} Else {
$taskWFRpHead = $subHead01
}
$bodyTaskWFRp = $taskWFRpHead + "Replication Tasks with Warnings or Failures" + $subHead02 + $bodyTaskWFRp
} Else {
$arrTaskWFRp = $wfTasksRp | Select @{Name="VM Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Progress.StartTimeLocal}},
@{Name="Stop Time"; Expression = {$_.Progress.StopTimeLocal}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Details"; Expression = {($_.GetDetails()).Replace("
","ZZbrZZ")}}, Status
$bodyTaskWFRp = $arrTaskWFRp | Sort "Start Time" | ConvertTo-HTML -Fragment
If ($arrTaskWFRp.Status -match "Failed") {
$taskWFRpHead = $subHead01err
} ElseIf ($arrTaskWFRp.Status -match "Warning") {
$taskWFRpHead = $subHead01war
} ElseIf ($arrTaskWFRp.Status -match "Success") {
$taskWFRpHead = $subHead01suc
} Else {
$taskWFRpHead = $subHead01
}
$bodyTaskWFRp = $taskWFRpHead + "Replication Tasks with Warnings or Failures" + $subHead02 + $bodyTaskWFRp
}
}
}
# Get Successful Replication Tasks
$bodyTaskSuccRp = $null
If ($showTaskSuccessRp) {
If ($successTasksRp.count -gt 0) {
If ($showDetailedRp) {
$bodyTaskSuccRp = $successTasksRp | Select @{Name="VM Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Progress.StartTimeLocal}},
@{Name="Stop Time"; Expression = {$_.Progress.StopTimeLocal}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Progress.AvgSpeed/1MB,2)}},
@{Name="Total (GB)"; Expression = {[Math]::Round($_.Progress.ProcessedSize/1GB,2)}},
@{Name="Processed (GB)"; Expression = {[Math]::Round($_.Progress.ProcessedUsedSize/1GB,2)}},
@{Name="Data Read (GB)"; Expression = {[Math]::Round($_.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Progress.TransferedSize/1GB,2)}},
Status | Sort "Start Time" | ConvertTo-HTML -Fragment
$bodyTaskSuccRp = $subHead01suc + "Successful Replication Tasks" + $subHead02 + $bodyTaskSuccRp
} Else {
$bodyTaskSuccRp = $successTasksRp | Select @{Name="VM Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Progress.StartTimeLocal}},
@{Name="Stop Time"; Expression = {$_.Progress.StopTimeLocal}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
Status | Sort "Start Time" | ConvertTo-HTML -Fragment
$bodyTaskSuccRp = $subHead01suc + "Successful Replication Tasks" + $subHead02 + $bodyTaskSuccRp
}
}
}
# Get Backup Copy Summary Info
$bodySummaryBc = $null
If ($showSummaryBc) {
$vbrMasterHash = @{
"Sessions" = If ($sessListBc) {@($sessListBc).Count} Else {0}
"Read" = $totalReadBc
"Transferred" = $totalXferBc
"Successful" = @($successSessionsBc).Count
"Warning" = @($warningSessionsBc).Count
"Fails" = @($failsSessionsBc).Count
"Working" = @($workingSessionsBc).Count
"Idle" = @($idleSessionsBc).Count
}
$vbrMasterObj = New-Object -TypeName PSObject -Property $vbrMasterHash
If ($onlyLastBc) {
$total = "Jobs Run"
} Else {
$total = "Total Sessions"
}
$arrSummaryBc = $vbrMasterObj | Select @{Name=$total; Expression = {$_.Sessions}},
@{Name="Read (GB)"; Expression = {$_.Read}}, @{Name="Transferred (GB)"; Expression = {$_.Transferred}},
@{Name="Idle"; Expression = {$_.Idle}},
@{Name="Working"; Expression = {$_.Working}}, @{Name="Successful"; Expression = {$_.Successful}},
@{Name="Warnings"; Expression = {$_.Warning}}, @{Name="Failures"; Expression = {$_.Fails}}
$bodySummaryBc = $arrSummaryBc | ConvertTo-HTML -Fragment
If ($arrSummaryBc.Failures -gt 0) {
$summaryBcHead = $subHead01err
} ElseIf ($arrSummaryBc.Warnings -gt 0) {
$summaryBcHead = $subHead01war
} ElseIf ($arrSummaryBc.Successful -gt 0) {
$summaryBcHead = $subHead01suc
} Else {
$summaryBcHead = $subHead01
}
$bodySummaryBc = $summaryBcHead + "Backup Copy Results Summary" + $subHead02 + $bodySummaryBc
}
# Get Backup Copy Job Status
$bodyJobsBc = $null
If ($showJobsBc) {
If ($allJobsBc.count -gt 0) {
$bodyJobsBc = @()
Foreach($BcJob in $allJobsBc) {
$bodyJobsBc += $BcJob | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Enabled"; Expression = {$_.Info.IsScheduleEnabled}},
@{Name="Type"; Expression = {$_.TypeToString}},
@{Name="Status"; Expression = {
If ($BcJob.IsRunning) {
$currentSess = $BcJob.FindLastSession()
If ($currentSess.State -eq "Working") {
$csessPercent = $currentSess.Progress.Percents
$csessSpeed = [Math]::Round($currentSess.Progress.AvgSpeed/1MB,2)
$cStatus = "$($csessPercent)% completed at $($csessSpeed) MB/s"
$cStatus
} Else {
$currentSess.State
}
} Else {
"Stopped"
}
}},
@{Name="Target Repo"; Expression = {
If ($($repoList | Where {$_.Id -eq $BcJob.Info.TargetRepositoryId}).Name) {$($repoList | Where {$_.Id -eq $BcJob.Info.TargetRepositoryId}).Name}
Else {$($repoListSo | Where {$_.Id -eq $BcJob.Info.TargetRepositoryId}).Name}}},
@{Name="Next Run"; Expression = {
If ($_.IsScheduleEnabled -eq $false) {""}
ElseIf ($_.Options.JobOptions.RunManually) {""}
ElseIf ($_.ScheduleOptions.IsContinious) {""}
ElseIf ($_.ScheduleOptions.OptionsScheduleAfterJob.IsEnabled) {"After [" + $(($allJobs + $allJobsTp) | Where {$_.Id -eq $BcJob.Info.ParentScheduleId}).Name + "]"}
Else {$_.ScheduleOptions.NextRun}}},
@{Name="Last Result"; Expression = {If ($_.Info.LatestStatus -eq "None"){""}Else{$_.Info.LatestStatus}}}
}
$bodyJobsBc = $bodyJobsBc | Sort "Next Run", "Job Name" | ConvertTo-HTML -Fragment
$bodyJobsBc = $subHead01 + "Backup Copy Job Status" + $subHead02 + $bodyJobsBc
}
}
# Get Backup Copy Job Size
$bodyJobSizeBc = $null
If ($showBackupSizeBc) {
If ($backupsBc.count -gt 0) {
$bodyJobSizeBc = Get-BackupSize -backups $backupsBc | Sort JobName | Select @{Name="Job Name"; Expression = {$_.JobName}},
@{Name="VM Count"; Expression = {$_.VMCount}},
@{Name="Repository"; Expression = {$_.Repo}},
@{Name="Data Size (GB)"; Expression = {$_.DataSize}},
@{Name="Backup Size (GB)"; Expression = {$_.BackupSize}} | ConvertTo-HTML -Fragment
$bodyJobSizeBc = $subHead01 + "Backup Copy Job Size" + $subHead02 + $bodyJobSizeBc
}
}
# Get All Backup Copy Sessions
$bodyAllSessBc = $null
If ($showAllSessBc) {
If ($sessListBc.count -gt 0) {
If ($showDetailedBc) {
$arrAllSessBc = $sessListBc | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="State"; Expression = {$_.State}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {If ($_.EndTime -eq "1/1/1900 12:00:00 AM"){"-"} Else {$_.EndTime}}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Info.Progress.AvgSpeed/1MB,2)}},
@{Name="Total (GB)"; Expression = {[Math]::Round($_.Info.Progress.ProcessedSize/1GB,2)}},
@{Name="Processed (GB)"; Expression = {[Math]::Round($_.Info.Progress.ProcessedUsedSize/1GB,2)}},
@{Name="Data Read (GB)"; Expression = {[Math]::Round($_.Info.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Info.Progress.TransferedSize/1GB,2)}},
@{Name="Dedupe"; Expression = {
If ($_.Progress.ReadSize -eq 0) {0}
Else {([string][Math]::Round($_.BackupStats.GetDedupeX(),1)) +"x"}}},
@{Name="Compression"; Expression = {
If ($_.Progress.ReadSize -eq 0) {0}
Else {([string][Math]::Round($_.BackupStats.GetCompressX(),1)) +"x"}}},
@{Name="Details"; Expression = {($_.GetDetails()).Replace("
","ZZbrZZ")}}, Result
$bodyAllSessBc = $arrAllSessBc | ConvertTo-HTML -Fragment
If ($arrAllSessBc.Result -match "Failed") {
$allSessBcHead = $subHead01err
} ElseIf ($arrAllSessBc.Result -match "Warning") {
$allSessBcHead = $subHead01war
} ElseIf ($arrAllSessBc.Result -match "Success") {
$allSessBcHead = $subHead01suc
} Else {
$allSessBcHead = $subHead01
}
$bodyAllSessBc = $allSessBcHead + "Backup Copy Sessions" + $subHead02 + $bodyAllSessBc
} Else {
$arrAllSessBc = $sessListBc | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="State"; Expression = {$_.State}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {If ($_.EndTime -eq "1/1/1900 12:00:00 AM"){"-"} Else {$_.EndTime}}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Details"; Expression = {($_.GetDetails()).Replace("
","ZZbrZZ")}}, Result
$bodyAllSessBc = $arrAllSessBc | ConvertTo-HTML -Fragment
If ($arrAllSessBc.Result -match "Failed") {
$allSessBcHead = $subHead01err
} ElseIf ($arrAllSessBc.Result -match "Warning") {
$allSessBcHead = $subHead01war
} ElseIf ($arrAllSessBc.Result -match "Success") {
$allSessBcHead = $subHead01suc
} Else {
$allSessBcHead = $subHead01
}
$bodyAllSessBc = $allSessBcHead + "Backup Copy Sessions" + $subHead02 + $bodyAllSessBc
}
}
}
# Get Idle Backup Copy Sessions
$bodySessIdleBc = $null
If ($showIdleBc) {
If ($idleSessionsBc.count -gt 0) {
If ($onlyLastBc) {
$headerIdle = "Idle Backup Copy Jobs"
} Else {
$headerIdle = "Idle Backup Copy Sessions"
}
If ($showDetailedBc) {
$bodySessIdleBc = $idleSessionsBc | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $(New-TimeSpan $_.CreationTime $(Get-Date))}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Info.Progress.AvgSpeed/1MB,2)}},
@{Name="Total (GB)"; Expression = {[Math]::Round($_.Info.Progress.ProcessedSize/1GB,2)}},
@{Name="Processed (GB)"; Expression = {[Math]::Round($_.Info.Progress.ProcessedUsedSize/1GB,2)}},
@{Name="Data Read (GB)"; Expression = {[Math]::Round($_.Info.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Info.Progress.TransferedSize/1GB,2)}},
@{Name="Dedupe"; Expression = {
If ($_.Progress.ReadSize -eq 0) {0}
Else {([string][Math]::Round($_.BackupStats.GetDedupeX(),1)) +"x"}}},
@{Name="Compression"; Expression = {
If ($_.Progress.ReadSize -eq 0) {0}
Else {([string][Math]::Round($_.BackupStats.GetCompressX(),1)) +"x"}}} | ConvertTo-HTML -Fragment
$bodySessIdleBc = $subHead01 + $headerIdle + $subHead02 + $bodySessIdleBc
} Else {
$bodySessIdleBc = $idleSessionsBc | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $(New-TimeSpan $_.CreationTime $(Get-Date))}} | ConvertTo-HTML -Fragment
$bodySessIdleBc = $subHead01 + $headerIdle + $subHead02 + $bodySessIdleBc
}
}
}
# Get Working Backup Copy Jobs
$bodyRunningBc = $null
If ($showRunningBc) {
If ($workingSessionsBc.count -gt 0) {
$bodyRunningBc = $workingSessionsBc | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $(New-TimeSpan $_.Progress.StartTimeLocal $(Get-Date))}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Progress.AvgSpeed/1MB,2)}},
@{Name="Read (GB)"; Expression = {[Math]::Round([Decimal]$_.Progress.ReadSize/1GB, 2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round([Decimal]$_.Progress.TransferedSize/1GB, 2)}},
@{Name="% Complete"; Expression = {$_.Progress.Percents}} | ConvertTo-HTML -Fragment
$bodyRunningBc = $subHead01 + "Working Backup Copy Sessions" + $subHead02 + $bodyRunningBc
}
}
# Get Backup Copy Sessions with Warnings or Failures
$bodySessWFBc = $null
If ($showWarnFailBc) {
$sessWF = @($warningSessionsBc + $failsSessionsBc)
If ($sessWF.count -gt 0) {
If ($onlyLastBc) {
$headerWF = "Backup Copy Jobs with Warnings or Failures"
} Else {
$headerWF = "Backup Copy Sessions with Warnings or Failures"
}
If ($showDetailedBc) {
$arrSessWFBc = $sessWF | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {$_.EndTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Info.Progress.AvgSpeed/1MB,2)}},
@{Name="Total (GB)"; Expression = {[Math]::Round($_.Info.Progress.ProcessedSize/1GB,2)}},
@{Name="Processed (GB)"; Expression = {[Math]::Round($_.Info.Progress.ProcessedUsedSize/1GB,2)}},
@{Name="Data Read (GB)"; Expression = {[Math]::Round($_.Info.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Info.Progress.TransferedSize/1GB,2)}},
@{Name="Dedupe"; Expression = {
If ($_.Progress.ReadSize -eq 0) {0}
Else {([string][Math]::Round($_.BackupStats.GetDedupeX(),1)) +"x"}}},
@{Name="Compression"; Expression = {
If ($_.Progress.ReadSize -eq 0) {0}
Else {([string][Math]::Round($_.BackupStats.GetCompressX(),1)) +"x"}}},
@{Name="Details"; Expression = {
If ($_.GetDetails() -eq ""){$_ | Get-VBRTaskSession | %{If ($_.GetDetails()){$_.Name + ": " + ($_.GetDetails()).Replace("
","ZZbrZZ")}}}
Else {($_.GetDetails()).Replace("
","ZZbrZZ")}}}, Result
$bodySessWFBc = $arrSessWFBc | ConvertTo-HTML -Fragment
If ($arrSessWFBc.Result -match "Failed") {
$sessWFBcHead = $subHead01err
} ElseIf ($arrSessWFBc.Result -match "Warning") {
$sessWFBcHead = $subHead01war
} ElseIf ($arrSessWFBc.Result -match "Success") {
$sessWFBcHead = $subHead01suc
} Else {
$sessWFBcHead = $subHead01
}
$bodySessWFBc = $sessWFBcHead + $headerWF + $subHead02 + $bodySessWFBc
} Else {
$arrSessWFBc = $sessWF | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {$_.EndTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Details"; Expression = {
If ($_.GetDetails() -eq ""){$_ | Get-VBRTaskSession | %{If ($_.GetDetails()){$_.Name + ": " + ($_.GetDetails()).Replace("
","ZZbrZZ")}}}
Else {($_.GetDetails()).Replace("
","ZZbrZZ")}}}, Result
$bodySessWFBc = $arrSessWFBc | ConvertTo-HTML -Fragment
If ($arrSessWFBc.Result -match "Failed") {
$sessWFBcHead = $subHead01err
} ElseIf ($arrSessWFBc.Result -match "Warning") {
$sessWFBcHead = $subHead01war
} ElseIf ($arrSessWFBc.Result -match "Success") {
$sessWFBcHead = $subHead01suc
} Else {
$sessWFBcHead = $subHead01
}
$bodySessWFBc = $sessWFBcHead + $headerWF + $subHead02 + $bodySessWFBc
}
}
}
# Get Successful Backup Copy Sessions
$bodySessSuccBc = $null
If ($showSuccessBc) {
If ($successSessionsBc.count -gt 0) {
If ($onlyLastBc) {
$headerSucc = "Successful Backup Copy Jobs"
} Else {
$headerSucc = "Successful Backup Copy Sessions"
}
If ($showDetailedBc) {
$bodySessSuccBc = $successSessionsBc | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {$_.EndTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Info.Progress.AvgSpeed/1MB,2)}},
@{Name="Total (GB)"; Expression = {[Math]::Round($_.Info.Progress.ProcessedSize/1GB,2)}},
@{Name="Processed (GB)"; Expression = {[Math]::Round($_.Info.Progress.ProcessedUsedSize/1GB,2)}},
@{Name="Data Read (GB)"; Expression = {[Math]::Round($_.Info.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Info.Progress.TransferedSize/1GB,2)}},
@{Name="Dedupe"; Expression = {
If ($_.Progress.ReadSize -eq 0) {0}
Else {([string][Math]::Round($_.BackupStats.GetDedupeX(),1)) +"x"}}},
@{Name="Compression"; Expression = {
If ($_.Progress.ReadSize -eq 0) {0}
Else {([string][Math]::Round($_.BackupStats.GetCompressX(),1)) +"x"}}},
Result | ConvertTo-HTML -Fragment
$bodySessSuccBc = $subHead01suc + $headerSucc + $subHead02 + $bodySessSuccBc
} Else {
$bodySessSuccBc = $successSessionsBc | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {$_.EndTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
Result | ConvertTo-HTML -Fragment
$bodySessSuccBc = $subHead01suc + $headerSucc + $subHead02 + $bodySessSuccBc
}
}
}
## Gathering tasks after session info has been recorded due to Veeam issue
# Gather all Backup Copy Tasks from Sessions within time frame
$taskListBc = @()
$taskListBc += $sessListBc | Get-VBRTaskSession
$successTasksBc = @($taskListBc | ?{$_.Status -eq "Success"})
$wfTasksBc = @($taskListBc | ?{$_.Status -match "Warning|Failed"})
$pendingTasksBc = @($taskListBc | ?{$_.Status -eq "Pending"})
$runningTasksBc = @($taskListBc | ?{$_.Status -eq "InProgress"})
# Get All Backup Copy Tasks
$bodyAllTasksBc = $null
If ($showAllTasksBc) {
If ($taskListBc.count -gt 0) {
If ($showDetailedBc) {
$arrAllTasksBc = $taskListBc | Select @{Name="VM Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Progress.StartTimeLocal}},
@{Name="Stop Time"; Expression = {If ($_.Progress.StopTimeLocal -eq "1/1/1900 12:00:00 AM"){"-"} Else {$_.Progress.StopTimeLocal}}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Progress.AvgSpeed/1MB,2)}},
@{Name="Total (GB)"; Expression = {[Math]::Round($_.Progress.ProcessedSize/1GB,2)}},
@{Name="Processed (GB)"; Expression = {[Math]::Round($_.Progress.ProcessedUsedSize/1GB,2)}},
@{Name="Data Read (GB)"; Expression = {[Math]::Round($_.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Progress.TransferedSize/1GB,2)}},
@{Name="Details"; Expression = {($_.GetDetails()).Replace("
","ZZbrZZ")}}, Status
$bodyAllTasksBc = $arrAllTasksBc | Sort "Start Time" | ConvertTo-HTML -Fragment
If ($arrAllTasksBc.Status -match "Failed") {
$allTasksBcHead = $subHead01err
} ElseIf ($arrAllTasksBc.Status -match "Warning") {
$allTasksBcHead = $subHead01war
} ElseIf ($arrAllTasksBc.Status -match "Success") {
$allTasksBcHead = $subHead01suc
} Else {
$allTasksBcHead = $subHead01
}
$bodyAllTasksBc = $allTasksBcHead + "Backup Copy Tasks" + $subHead02 + $bodyAllTasksBc
} Else {
$arrAllTasksBc = $taskListBc | Select @{Name="VM Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Progress.StartTimeLocal}},
@{Name="Stop Time"; Expression = {If ($_.Progress.StopTimeLocal -eq "1/1/1900 12:00:00 AM"){"-"} Else {$_.Progress.StopTimeLocal}}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Details"; Expression = {($_.GetDetails()).Replace("
","ZZbrZZ")}}, Status
$bodyAllTasksBc = $arrAllTasksBc | Sort "Start Time" | ConvertTo-HTML -Fragment
If ($arrAllTasksBc.Status -match "Failed") {
$allTasksBcHead = $subHead01err
} ElseIf ($arrAllTasksBc.Status -match "Warning") {
$allTasksBcHead = $subHead01war
} ElseIf ($arrAllTasksBc.Status -match "Success") {
$allTasksBcHead = $subHead01suc
} Else {
$allTasksBcHead = $subHead01
}
$bodyAllTasksBc = $allTasksBcHead + "Backup Copy Tasks" + $subHead02 + $bodyAllTasksBc
}
}
}
# Get Pending Backup Copy Tasks
$bodyTasksPendingBc = $null
If ($showPendingTasksBc) {
If ($pendingTasksBc.count -gt 0) {
$bodyTasksPendingBc = $pendingTasksBc | Select @{Name="VM Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Info.Progress.StartTimeLocal}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Progress.AvgSpeed/1MB,2)}},
@{Name="Read (GB)"; Expression = {[Math]::Round($_.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Progress.TransferedSize/1GB,2)}},
Status | Sort "Start Time" | ConvertTo-HTML -Fragment
$bodyTasksPendingBc = $subHead01 + "Pending Backup Copy Tasks" + $subHead02 + $bodyTasksPendingBc
}
}
# Get Working Backup Copy Tasks
$bodyTasksRunningBc = $null
If ($showRunningTasksBc) {
If ($runningTasksBc.count -gt 0) {
$bodyTasksRunningBc = $runningTasksBc | Select @{Name="VM Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Info.Progress.StartTimeLocal}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Progress.AvgSpeed/1MB,2)}},
@{Name="Read (GB)"; Expression = {[Math]::Round($_.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Progress.TransferedSize/1GB,2)}},
Status | Sort "Start Time" | ConvertTo-HTML -Fragment
$bodyTasksRunningBc = $subHead01 + "Working Backup Copy Tasks" + $subHead02 + $bodyTasksRunningBc
}
}
# Get Backup Copy Tasks with Warnings or Failures
$bodyTaskWFBc = $null
If ($showTaskWFBc) {
If ($wfTasksBc.count -gt 0) {
If ($showDetailedBc) {
$arrTaskWFBc = $wfTasksBc | Select @{Name="VM Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Progress.StartTimeLocal}},
@{Name="Stop Time"; Expression = {$_.Progress.StopTimeLocal}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Progress.AvgSpeed/1MB,2)}},
@{Name="Total (GB)"; Expression = {[Math]::Round($_.Progress.ProcessedSize/1GB,2)}},
@{Name="Processed (GB)"; Expression = {[Math]::Round($_.Progress.ProcessedUsedSize/1GB,2)}},
@{Name="Data Read (GB)"; Expression = {[Math]::Round($_.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Progress.TransferedSize/1GB,2)}},
@{Name="Details"; Expression = {($_.GetDetails()).Replace("
","ZZbrZZ")}}, Status
$bodyTaskWFBc = $arrTaskWFBc | Sort "Start Time" | ConvertTo-HTML -Fragment
If ($arrTaskWFBc.Status -match "Failed") {
$taskWFBcHead = $subHead01err
} ElseIf ($arrTaskWFBc.Status -match "Warning") {
$taskWFBcHead = $subHead01war
} ElseIf ($arrTaskWFBc.Status -match "Success") {
$taskWFBcHead = $subHead01suc
} Else {
$taskWFBcHead = $subHead01
}
$bodyTaskWFBc = $taskWFBcHead + "Backup Copy Tasks with Warnings or Failures" + $subHead02 + $bodyTaskWFBc
} Else {
$arrTaskWFBc = $wfTasksBc | Select @{Name="VM Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Progress.StartTimeLocal}},
@{Name="Stop Time"; Expression = {$_.Progress.StopTimeLocal}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Details"; Expression = {($_.GetDetails()).Replace("
","ZZbrZZ")}}, Status
$bodyTaskWFBc = $arrTaskWFBc | Sort "Start Time" | ConvertTo-HTML -Fragment
If ($arrTaskWFBc.Status -match "Failed") {
$taskWFBcHead = $subHead01err
} ElseIf ($arrTaskWFBc.Status -match "Warning") {
$taskWFBcHead = $subHead01war
} ElseIf ($arrTaskWFBc.Status -match "Success") {
$taskWFBcHead = $subHead01suc
} Else {
$taskWFBcHead = $subHead01
}
$bodyTaskWFBc = $taskWFBcHead + "Backup Copy Tasks with Warnings or Failures" + $subHead02 + $bodyTaskWFBc
}
}
}
# Get Successful Backup Copy Tasks
$bodyTaskSuccBc = $null
If ($showTaskSuccessBc) {
If ($successTasksBc.count -gt 0) {
If ($showDetailedBc) {
$bodyTaskSuccBc = $successTasksBc | Select @{Name="VM Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Progress.StartTimeLocal}},
@{Name="Stop Time"; Expression = {
If ($_.Progress.StopTimeLocal -eq "1/1/1900 12:00:00 AM") {"-"}
Else {$_.Progress.StopTimeLocal}
}},
@{Name="Duration (HH:MM:SS)"; Expression = {
If ($_.Progress.StopTimeLocal -eq "1/1/1900 12:00:00 AM") {"-"}
Else {Get-Duration -ts $_.Progress.Duration}
}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Progress.AvgSpeed/1MB,2)}},
@{Name="Total (GB)"; Expression = {[Math]::Round($_.Progress.ProcessedSize/1GB,2)}},
@{Name="Processed (GB)"; Expression = {[Math]::Round($_.Progress.ProcessedUsedSize/1GB,2)}},
@{Name="Data Read (GB)"; Expression = {[Math]::Round($_.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Progress.TransferedSize/1GB,2)}},
Status | Sort "Start Time" | ConvertTo-HTML -Fragment
$bodyTaskSuccBc = $subHead01suc + "Successful Backup Copy Tasks" + $subHead02 + $bodyTaskSuccBc
} Else {
$bodyTaskSuccBc = $successTasksBc | Select @{Name="VM Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Progress.StartTimeLocal}},
@{Name="Stop Time"; Expression = {
If ($_.Progress.StopTimeLocal -eq "1/1/1900 12:00:00 AM") {"-"}
Else {$_.Progress.StopTimeLocal}
}},
@{Name="Duration (HH:MM:SS)"; Expression = {
If ($_.Progress.StopTimeLocal -eq "1/1/1900 12:00:00 AM") {"-"}
Else {Get-Duration -ts $_.Progress.Duration}
}},
Status | Sort "Start Time" | ConvertTo-HTML -Fragment
$bodyTaskSuccBc = $subHead01suc + "Successful Backup Copy Tasks" + $subHead02 + $bodyTaskSuccBc
}
}
}
# Get Tape Backup Summary Info
$bodySummaryTp = $null
If ($showSummaryTp) {
$vbrMasterHash = @{
"Sessions" = If ($sessListTp) {@($sessListTp).Count} Else {0}
"Read" = $totalReadTp
"Transferred" = $totalXferTp
"Successful" = @($successSessionsTp).Count
"Warning" = @($warningSessionsTp).Count
"Fails" = @($failsSessionsTp).Count
"Working" = @($workingSessionsTp).Count
"Idle" = @($idleSessionsTp).Count
"Waiting" = @($waitingSessionsTp).Count
}
$vbrMasterObj = New-Object -TypeName PSObject -Property $vbrMasterHash
If ($onlyLastTp) {
$total = "Jobs Run"
} Else {
$total = "Total Sessions"
}
$arrSummaryTp = $vbrMasterObj | Select @{Name=$total; Expression = {$_.Sessions}},
@{Name="Read (GB)"; Expression = {$_.Read}}, @{Name="Transferred (GB)"; Expression = {$_.Transferred}},
@{Name="Idle"; Expression = {$_.Idle}}, @{Name="Waiting"; Expression = {$_.Waiting}},
@{Name="Working"; Expression = {$_.Working}}, @{Name="Successful"; Expression = {$_.Successful}},
@{Name="Warnings"; Expression = {$_.Warning}}, @{Name="Failures"; Expression = {$_.Fails}}
$bodySummaryTp = $arrSummaryTp | ConvertTo-HTML -Fragment
If ($arrSummaryTp.Failures -gt 0) {
$summaryTpHead = $subHead01err
} ElseIf ($arrSummaryTp.Warnings -gt 0 -or $arrSummaryTp.Waiting -gt 0) {
$summaryTpHead = $subHead01war
} ElseIf ($arrSummaryTp.Successful -gt 0) {
$summaryTpHead = $subHead01suc
} Else {
$summaryTpHead = $subHead01
}
$bodySummaryTp = $summaryTpHead + "Tape Backup Results Summary" + $subHead02 + $bodySummaryTp
}
# Get Tape Backup Job Status
$bodyJobsTp = $null
If ($showJobsTp) {
If ($allJobsTp.count -gt 0) {
$bodyJobsTp = @()
Foreach($tpJob in $allJobsTp) {
$bodyJobsTp += $tpJob | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Job Type"; Expression = {$_.Type}},@{Name="Media Pool"; Expression = {$_.Target}},
@{Name="Status"; Expression = {$_.LastState}},
@{Name="Next Run"; Expression = {
If ($_.ScheduleOptions.Type -eq "AfterNewBackup") {""}
ElseIf ($_.ScheduleOptions.Type -eq "AfterJob") {"After [" + $(($allJobs + $allJobsTp) | Where {$_.Id -eq $tpJob.ScheduleOptions.JobId}).Name + "]"}
ElseIf ($_.NextRun) {$_.NextRun}
Else {""}}},
@{Name="Last Result"; Expression = {If ($_.LastResult -eq "None"){""}Else{$_.LastResult}}}
}
$bodyJobsTp = $bodyJobsTp | Sort "Next Run", "Job Name" | ConvertTo-HTML -Fragment
$bodyJobsTp = $subHead01 + "Tape Backup Job Status" + $subHead02 + $bodyJobsTp
}
}
# Get Tape Backup Sessions
$bodyAllSessTp = $null
If ($showAllSessTp) {
If ($sessListTp.count -gt 0) {
If ($showDetailedTp) {
$arrAllSessTp = $sessListTp | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="State"; Expression = {$_.State}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {If ($_.EndTime -eq "1/1/1900 12:00:00 AM"){"-"} Else {$_.EndTime}}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Info.Progress.AvgSpeed/1MB,2)}},
@{Name="Total (GB)"; Expression = {[Math]::Round($_.Info.Progress.ProcessedSize/1GB,2)}},
@{Name="Data Read (GB)"; Expression = {[Math]::Round($_.Info.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Info.Progress.TransferedSize/1GB,2)}},
@{Name="Details"; Expression = {($_.GetDetails()).Replace("
","ZZbrZZ")}}, Result
$bodyAllSessTp = $arrAllSessTp | ConvertTo-HTML -Fragment
If ($arrAllSessTp.Result -match "Failed") {
$allSessTpHead = $subHead01err
} ElseIf ($arrAllSessTp.Result -match "Warning" -or $arrAllSessTp.State -match "WaitingTape") {
$allSessTpHead = $subHead01war
} ElseIf ($arrAllSessTp.Result -match "Success") {
$allSessTpHead = $subHead01suc
} Else {
$allSessTpHead = $subHead01
}
$bodyAllSessTp = $allSessTpHead + "Tape Backup Sessions" + $subHead02 + $bodyAllSessTp
} Else {
$arrAllSessTp = $sessListTp | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="State"; Expression = {$_.State}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {If ($_.EndTime -eq "1/1/1900 12:00:00 AM"){"-"} Else {$_.EndTime}}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Details"; Expression = {($_.GetDetails()).Replace("
","ZZbrZZ")}}, Result
$bodyAllSessTp = $arrAllSessTp | ConvertTo-HTML -Fragment
If ($arrAllSessTp.Result -match "Failed") {
$allSessTpHead = $subHead01err
} ElseIf ($arrAllSessTp.Result -match "Warning" -or $arrAllSessTp.State -match "WaitingTape") {
$allSessTpHead = $subHead01war
} ElseIf ($arrAllSessTp.Result -match "Success") {
$allSessTpHead = $subHead01suc
} Else {
$allSessTpHead = $subHead01
}
$bodyAllSessTp = $allSessTpHead + "Tape Backup Sessions" + $subHead02 + $bodyAllSessTp
}
# Due to issue with getting details on tape sessions, we may need to get session info again :-(
If (($showWaitingTp -or $showIdleTp -or $showRunningTp -or $showWarnFailTp -or $showSuccessTp) -and $showDetailedTp) {
# Get all Tape Backup Sessions
$allSessTp = @()
Foreach ($tpJob in $allJobsTp){
$tpSessions = [veeam.backup.core.cbackupsession]::GetByJob($tpJob.id)
$allSessTp += $tpSessions
}
# Gather all Tape Backup Sessions within timeframe
$sessListTp = @($allSessTp | ?{$_.EndTime -ge (Get-Date).AddHours(-$HourstoCheck) -or $_.CreationTime -ge (Get-Date).AddHours(-$HourstoCheck) -or $_.State -match "Working|Idle"})
If ($tapeJob -ne $null -and $tapeJob -ne "") {
$allJobsTpTmp = @()
$sessListTpTmp = @()
Foreach ($tpJob in $tapeJob) {
$allJobsTpTmp += $allJobsTp | ?{$_.Name -like $tpJob}
$sessListTpTmp += $sessListTp | ?{$_.JobName -like $tpJob}
}
$allJobsTp = $allJobsTpTmp | sort Id -Unique
$sessListTp = $sessListTpTmp | sort Id -Unique
}
If ($onlyLastTp) {
$tempSessListTp = $sessListTp
$sessListTp = @()
Foreach($job in $allJobsTp) {
$sessListTp += $tempSessListTp | ?{$_.Jobname -eq $job.name} | Sort-Object EndTime -Descending | Select-Object -First 1
}
}
# Get Tape Backup Session information
$idleSessionsTp = @($sessListTp | ?{$_.State -eq "Idle"})
$successSessionsTp = @($sessListTp | ?{$_.Result -eq "Success"})
$warningSessionsTp = @($sessListTp | ?{$_.Result -eq "Warning"})
$failsSessionsTp = @($sessListTp | ?{$_.Result -eq "Failed"})
$workingSessionsTp = @($sessListTp | ?{$_.State -eq "Working"})
$waitingSessionsTp = @($sessListTp | ?{$_.State -eq "WaitingTape"})
}
}
}
# Get Waiting Tape Backup Jobs
$bodyWaitingTp = $null
If ($showWaitingTp) {
If ($waitingSessionsTp.count -gt 0) {
$bodyWaitingTp = $waitingSessionsTp | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $(New-TimeSpan $_.Progress.StartTimeLocal $(Get-Date))}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Progress.AvgSpeed/1MB,2)}},
@{Name="Read (GB)"; Expression = {[Math]::Round([Decimal]$_.Progress.ReadSize/1GB, 2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round([Decimal]$_.Progress.TransferedSize/1GB, 2)}},
@{Name="% Complete"; Expression = {$_.Progress.Percents}} | ConvertTo-HTML -Fragment
$bodyWaitingTp = $subHead01war + "Waiting Tape Backup Sessions" + $subHead02 + $bodyWaitingTp
}
}
# Get Idle Tape Backup Sessions
$bodySessIdleTp = $null
If ($showIdleTp) {
If ($idleSessionsTp.count -gt 0) {
If ($onlyLastTp) {
$headerIdle = "Idle Tape Backup Jobs"
} Else {
$headerIdle = "Idle Tape Backup Sessions"
}
If ($showDetailedTp) {
$bodySessIdleTp = $idleSessionsTp | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $(New-TimeSpan $_.CreationTime $(Get-Date))}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Info.Progress.AvgSpeed/1MB,2)}},
@{Name="Total (GB)"; Expression = {[Math]::Round($_.Info.Progress.ProcessedSize/1GB,2)}},
@{Name="Data Read (GB)"; Expression = {[Math]::Round($_.Info.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Info.Progress.TransferedSize/1GB,2)}} | ConvertTo-HTML -Fragment
$bodySessIdleTp = $subHead01 + $headerIdle + $subHead02 + $bodySessIdleTp
} Else {
$bodySessIdleTp = $idleSessionsTp | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $(New-TimeSpan $_.CreationTime $(Get-Date))}} | ConvertTo-HTML -Fragment
$bodySessIdleTp = $subHead01 + $headerIdle + $subHead02 + $bodySessIdleTp
}
}
}
# Get Working Tape Backup Jobs
$bodyRunningTp = $null
If ($showRunningTp) {
If ($workingSessionsTp.count -gt 0) {
$bodyRunningTp = $workingSessionsTp | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $(New-TimeSpan $_.Progress.StartTimeLocal $(Get-Date))}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Progress.AvgSpeed/1MB,2)}},
@{Name="Read (GB)"; Expression = {[Math]::Round([Decimal]$_.Progress.ReadSize/1GB, 2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round([Decimal]$_.Progress.TransferedSize/1GB, 2)}},
@{Name="% Complete"; Expression = {$_.Progress.Percents}} | ConvertTo-HTML -Fragment
$bodyRunningTp = $subHead01 + "Working Tape Backup Sessions" + $subHead02 + $bodyRunningTp
}
}
# Get Tape Backup Sessions with Warnings or Failures
$bodySessWFTp = $null
If ($showWarnFailTp) {
$sessWF = @($warningSessionsTp + $failsSessionsTp)
If ($sessWF.count -gt 0) {
If ($onlyLastTp) {
$headerWF = "Tape Backup Jobs with Warnings or Failures"
} Else {
$headerWF = "Tape Backup Sessions with Warnings or Failures"
}
If ($showDetailedTp) {
$arrSessWFTp = $sessWF | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {$_.EndTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Info.Progress.AvgSpeed/1MB,2)}},
@{Name="Total (GB)"; Expression = {[Math]::Round($_.Info.Progress.ProcessedSize/1GB,2)}},
@{Name="Data Read (GB)"; Expression = {[Math]::Round($_.Info.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Info.Progress.TransferedSize/1GB,2)}},
@{Name="Details"; Expression = {
If ($_.GetDetails() -eq ""){$_ | Get-VBRTaskSession | %{If ($_.GetDetails()){$_.Name + ": " + ($_.GetDetails()).Replace("
","ZZbrZZ")}}}
Else {($_.GetDetails()).Replace("
","ZZbrZZ")}}}, Result
$bodySessWFTp = $arrSessWFTp | ConvertTo-HTML -Fragment
If ($arrSessWFTp.Result -match "Failed") {
$sessWFTpHead = $subHead01err
} ElseIf ($arrSessWFTp.Result -match "Warning") {
$sessWFTpHead = $subHead01war
} ElseIf ($arrSessWFTp.Result -match "Success") {
$sessWFTpHead = $subHead01suc
} Else {
$sessWFTpHead = $subHead01
}
$bodySessWFTp = $sessWFTpHead + $headerWF + $subHead02 + $bodySessWFTp
} Else {
$arrSessWFTp = $sessWF | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {$_.EndTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Details"; Expression = {
If ($_.GetDetails() -eq ""){$_ | Get-VBRTaskSession | %{If ($_.GetDetails()){$_.Name + ": " + ($_.GetDetails()).Replace("
","ZZbrZZ")}}}
Else {($_.GetDetails()).Replace("
","ZZbrZZ")}}}, Result
$bodySessWFTp = $arrSessWFTp | ConvertTo-HTML -Fragment
If ($arrSessWFTp.Result -match "Failed") {
$sessWFTpHead = $subHead01err
} ElseIf ($arrSessWFTp.Result -match "Warning") {
$sessWFTpHead = $subHead01war
} ElseIf ($arrSessWFTp.Result -match "Success") {
$sessWFTpHead = $subHead01suc
} Else {
$sessWFTpHead = $subHead01
}
$bodySessWFTp = $sessWFTpHead + $headerWF + $subHead02 + $bodySessWFTp
}
}
}
# Get Successful Tape Backup Sessions
$bodySessSuccTp = $null
If ($showSuccessTp) {
If ($successSessionsTp.count -gt 0) {
If ($onlyLastTp) {
$headerSucc = "Successful Tape Backup Jobs"
} Else {
$headerSucc = "Successful Tape Backup Sessions"
}
If ($showDetailedTp) {
$bodySessSuccTp = $successSessionsTp | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {$_.EndTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Info.Progress.AvgSpeed/1MB,2)}},
@{Name="Total (GB)"; Expression = {[Math]::Round($_.Info.Progress.ProcessedSize/1GB,2)}},
@{Name="Data Read (GB)"; Expression = {[Math]::Round($_.Info.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Info.Progress.TransferedSize/1GB,2)}},
@{Name="Details"; Expression = {
If ($_.GetDetails() -eq ""){$_ | Get-VBRTaskSession | %{If ($_.GetDetails()){$_.Name + ": " + ($_.GetDetails()).Replace("
","ZZbrZZ")}}}
Else {($_.GetDetails()).Replace("
","ZZbrZZ")}}},
Result | ConvertTo-HTML -Fragment
$bodySessSuccTp = $subHead01suc + $headerSucc + $subHead02 + $bodySessSuccTp
} Else {
$bodySessSuccTp = $successSessionsTp | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {$_.EndTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Details"; Expression = {
If ($_.GetDetails() -eq ""){$_ | Get-VBRTaskSession | %{If ($_.GetDetails()){$_.Name + ": " + ($_.GetDetails()).Replace("
","ZZbrZZ")}}}
Else {($_.GetDetails()).Replace("
","ZZbrZZ")}}},
Result | ConvertTo-HTML -Fragment
$bodySessSuccTp = $subHead01suc + $headerSucc + $subHead02 + $bodySessSuccTp
}
}
}
## Gathering tasks after session info has been recorded due to Veeam issue
# Gather all Tape Backup Tasks from Sessions within time frame
$taskListTp = @()
$taskListTp += $sessListTp | Get-VBRTaskSession
$successTasksTp = @($taskListTp | ?{$_.Status -eq "Success"})
$wfTasksTp = @($taskListTp | ?{$_.Status -match "Warning|Failed"})
$pendingTasksTp = @($taskListTp | ?{$_.Status -eq "Pending"})
$runningTasksTp = @($taskListTp | ?{$_.Status -eq "InProgress"})
# Get Tape Backup Tasks
$bodyAllTasksTp = $null
If ($showAllTasksTp) {
If ($taskListTp.count -gt 0) {
If ($showDetailedTp) {
$arrAllTasksTp = $taskListTp | Select @{Name="Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Progress.StartTimeLocal}},
@{Name="Stop Time"; Expression = {If ($_.Progress.StopTimeLocal -eq "1/1/1900 12:00:00 AM"){"-"} Else {$_.Progress.StopTimeLocal}}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Progress.AvgSpeed/1MB,2)}},
@{Name="Total (GB)"; Expression = {[Math]::Round($_.Progress.ProcessedSize/1GB,2)}},
@{Name="Data Read (GB)"; Expression = {[Math]::Round($_.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Progress.TransferedSize/1GB,2)}},
@{Name="Details"; Expression = {($_.GetDetails()).Replace("
","ZZbrZZ")}}, Status
$bodyAllTasksTp = $arrAllTasksTp | Sort "Start Time" | ConvertTo-HTML -Fragment
If ($arrAllTasksTp.Status -match "Failed") {
$allTasksTpHead = $subHead01err
} ElseIf ($arrAllTasksTp.Status -match "Warning") {
$allTasksTpHead = $subHead01war
} ElseIf ($arrAllTasksTp.Status -match "Success") {
$allTasksTpHead = $subHead01suc
} Else {
$allTasksTpHead = $subHead01
}
$bodyAllTasksTp = $allTasksTpHead + "Tape Backup Tasks" + $subHead02 + $bodyAllTasksTp
} Else {
$arrAllTasksTp = $taskListTp | Select @{Name="Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Progress.StartTimeLocal}},
@{Name="Stop Time"; Expression = {If ($_.Progress.StopTimeLocal -eq "1/1/1900 12:00:00 AM"){"-"} Else {$_.Progress.StopTimeLocal}}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Details"; Expression = {($_.GetDetails()).Replace("
","ZZbrZZ")}}, Status
$bodyAllTasksTp = $arrAllTasksTp | Sort "Start Time" | ConvertTo-HTML -Fragment
If ($arrAllTasksTp.Status -match "Failed") {
$allTasksTpHead = $subHead01err
} ElseIf ($arrAllTasksTp.Status -match "Warning") {
$allTasksTpHead = $subHead01war
} ElseIf ($arrAllTasksTp.Status -match "Success") {
$allTasksTpHead = $subHead01suc
} Else {
$allTasksTpHead = $subHead01
}
$bodyAllTasksTp = $allTasksTpHead + "Tape Backup Tasks" + $subHead02 + $bodyAllTasksTp
}
}
}
# Get Pending Tape Backup Tasks
$bodyTasksPendingTp = $null
If ($showPendingTasksTp) {
If ($pendingTasksTp.count -gt 0) {
$bodyTasksPendingTp = $pendingTasksTp | Select @{Name="Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Info.Progress.StartTimeLocal}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Progress.AvgSpeed/1MB,2)}},
@{Name="Read (GB)"; Expression = {[Math]::Round($_.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Progress.TransferedSize/1GB,2)}},
Status | Sort "Start Time" | ConvertTo-HTML -Fragment
$bodyTasksPendingTp = $subHead01 + "Pending Tape Backup Tasks" + $subHead02 + $bodyTasksPendingTp
}
}
# Get Working Tape Backup Tasks
$bodyTasksRunningTp = $null
If ($showRunningTasksTp) {
If ($runningTasksTp.count -gt 0) {
$bodyTasksRunningTp = $runningTasksTp | Select @{Name="Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Info.Progress.StartTimeLocal}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Progress.AvgSpeed/1MB,2)}},
@{Name="Read (GB)"; Expression = {[Math]::Round($_.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Progress.TransferedSize/1GB,2)}},
Status | Sort "Start Time" | ConvertTo-HTML -Fragment
$bodyTasksRunningTp = $subHead01 + "Working Tape Backup Tasks" + $subHead02 + $bodyTasksRunningTp
}
}
# Get Tape Backup Tasks with Warnings or Failures
$bodyTaskWFTp = $null
If ($showTaskWFTp) {
If ($wfTasksTp.count -gt 0) {
If ($showDetailedTp) {
$arrTaskWFTp = $wfTasksTp | Select @{Name="Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Progress.StartTimeLocal}},
@{Name="Stop Time"; Expression = {$_.Progress.StopTimeLocal}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Progress.AvgSpeed/1MB,2)}},
@{Name="Total (GB)"; Expression = {[Math]::Round($_.Progress.ProcessedSize/1GB,2)}},
@{Name="Data Read (GB)"; Expression = {[Math]::Round($_.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Progress.TransferedSize/1GB,2)}},
@{Name="Details"; Expression = {($_.GetDetails()).Replace("
","ZZbrZZ")}}, Status
$bodyTaskWFTp = $arrTaskWFTp | Sort "Start Time" | ConvertTo-HTML -Fragment
If ($arrTaskWFTp.Status -match "Failed") {
$taskWFTpHead = $subHead01err
} ElseIf ($arrTaskWFTp.Status -match "Warning") {
$taskWFTpHead = $subHead01war
} ElseIf ($arrTaskWFTp.Status -match "Success") {
$taskWFTpHead = $subHead01suc
} Else {
$taskWFTpHead = $subHead01
}
$bodyTaskWFTp = $taskWFTpHead + "Tape Backup Tasks with Warnings or Failures" + $subHead02 + $bodyTaskWFTp
} Else {
$arrTaskWFTp = $wfTasksTp | Select @{Name="Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Progress.StartTimeLocal}},
@{Name="Stop Time"; Expression = {$_.Progress.StopTimeLocal}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $_.Progress.Duration}},
@{Name="Details"; Expression = {($_.GetDetails()).Replace("
","ZZbrZZ")}}, Status
$bodyTaskWFTp = $arrTaskWFTp | Sort "Start Time" | ConvertTo-HTML -Fragment
If ($arrTaskWFTp.Status -match "Failed") {
$taskWFTpHead = $subHead01err
} ElseIf ($arrTaskWFTp.Status -match "Warning") {
$taskWFTpHead = $subHead01war
} ElseIf ($arrTaskWFTp.Status -match "Success") {
$taskWFTpHead = $subHead01suc
} Else {
$taskWFTpHead = $subHead01
}
$bodyTaskWFTp = $taskWFTpHead + "Tape Backup Tasks with Warnings or Failures" + $subHead02 + $bodyTaskWFTp
}
}
}
# Get Successful Tape Backup Tasks
$bodyTaskSuccTp = $null
If ($showTaskSuccessTp) {
If ($successTasksTp.count -gt 0) {
If ($showDetailedTp) {
$bodyTaskSuccTp = $successTasksTp | Select @{Name="Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Progress.StartTimeLocal}},
@{Name="Stop Time"; Expression = {
If ($_.Progress.StopTimeLocal -eq "1/1/1900 12:00:00 AM") {"-"}
Else {$_.Progress.StopTimeLocal}
}},
@{Name="Duration (HH:MM:SS)"; Expression = {
If ($_.Progress.StopTimeLocal -eq "1/1/1900 12:00:00 AM") {"-"}
Else {Get-Duration -ts $_.Progress.Duration}
}},
@{Name="Avg Speed (MB/s)"; Expression = {[Math]::Round($_.Progress.AvgSpeed/1MB,2)}},
@{Name="Total (GB)"; Expression = {[Math]::Round($_.Progress.ProcessedSize/1GB,2)}},
@{Name="Data Read (GB)"; Expression = {[Math]::Round($_.Progress.ReadSize/1GB,2)}},
@{Name="Transferred (GB)"; Expression = {[Math]::Round($_.Progress.TransferedSize/1GB,2)}},
Status | Sort "Start Time" | ConvertTo-HTML -Fragment
$bodyTaskSuccTp = $subHead01suc + "Successful Tape Backup Tasks" + $subHead02 + $bodyTaskSuccTp
} Else {
$bodyTaskSuccTp = $successTasksTp | Select @{Name="Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSess.Name}},
@{Name="Start Time"; Expression = {$_.Progress.StartTimeLocal}},
@{Name="Stop Time"; Expression = {
If ($_.Progress.StopTimeLocal -eq "1/1/1900 12:00:00 AM") {"-"}
Else {$_.Progress.StopTimeLocal}
}},
@{Name="Duration (HH:MM:SS)"; Expression = {
If ($_.Progress.StopTimeLocal -eq "1/1/1900 12:00:00 AM") {"-"}
Else {Get-Duration -ts $_.Progress.Duration}
}},
Status | Sort "Start Time" | ConvertTo-HTML -Fragment
$bodyTaskSuccTp = $subHead01suc + "Successful Tape Backup Tasks" + $subHead02 + $bodyTaskSuccTp
}
}
}
# Get all Tapes
$bodyTapes = $null
If ($showTapes) {
$expTapes = @($mediaTapes)
if($expTapes.Count -gt 0) {
$expTapes = $expTapes | Select Name, Barcode,
@{Name="Media Pool"; Expression = {
$poolId = $_.MediaPoolId
($mediaPools | ?{$_.Id -eq $poolId}).Name
}},
@{Name="Media Set"; Expression = {$_.MediaSet}}, @{Name="Sequence #"; Expression = {$_.SequenceNumber}},
@{Name="Location"; Expression = {
switch ($_.Location) {
"None" {"Offline"}
"Slot" {
$lId = $_.LibraryId
$lName = $($mediaLibs | ?{$_.Id -eq $lId}).Name
[int]$slot = $_.SlotAddress + 1
"{0} : {1} {2}" -f $lName,$_,$slot
}
"Drive" {
$lId = $_.LibraryId
$dId = $_.DriveId
$lName = $($mediaLibs | ?{$_.Id -eq $lId}).Name
$dName = $($mediaDrives | ?{$_.Id -eq $dId}).Name
[int]$dNum = $_.Location.DriveAddress + 1
"{0} : {1} {2} (Drive ID: {3})" -f $lName,$_,$dNum,$dName
}
"Vault" {
$vId = $_.VaultId
$vName = $($mediaVaults | ?{$_.Id -eq $vId}).Name
"{0}: {1}" -f $_,$vName}
default {"Lost in Space"}
}
}},
@{Name="Capacity (GB)"; Expression = {[Math]::Round([Decimal]$_.Capacity/1GB, 2)}},
@{Name="Free (GB)"; Expression = {[Math]::Round([Decimal]$_.Free/1GB, 2)}},
@{Name="Last Write"; Expression = {$_.LastWriteTime}},
@{Name="Expiration Date"; Expression = {
If ($(Get-Date $_.ExpirationDate) -lt $(Get-Date)) {
"Expired"
} Else {
$_.ExpirationDate
}
}} | Sort Name | ConvertTo-HTML -Fragment
$bodyTapes = $subHead01 + "All Tapes" + $subHead02 + $expTapes
}
}
# Get all Tapes in each Custom Media Pool
$bodyTpPool = $null
If ($showTpMp) {
ForEach ($mp in ($mediaPools | ?{$_.Type -eq "Custom"} | Sort Name)) {
$expTapes = @($mediaTapes | where {($_.MediaPoolId -eq $mp.Id)})
if($expTapes.Count -gt 0) {
$expTapes = $expTapes | Select Name, Barcode,
@{Name="Media Set"; Expression = {$_.MediaSet}}, @{Name="Sequence #"; Expression = {$_.SequenceNumber}},
@{Name="Location"; Expression = {
switch ($_.Location) {
"None" {"Offline"}
"Slot" {
$lId = $_.LibraryId
$lName = $($mediaLibs | ?{$_.Id -eq $lId}).Name
[int]$slot = $_.SlotAddress + 1
"{0} : {1} {2}" -f $lName,$_,$slot
}
"Drive" {
$lId = $_.LibraryId
$dId = $_.DriveId
$lName = $($mediaLibs | ?{$_.Id -eq $lId}).Name
$dName = $($mediaDrives | ?{$_.Id -eq $dId}).Name
[int]$dNum = $_.Location.DriveAddress + 1
"{0} : {1} {2} (Drive ID: {3})" -f $lName,$_,$dNum,$dName
}
"Vault" {
$vId = $_.VaultId
$vName = $($mediaVaults | ?{$_.Id -eq $vId}).Name
"{0}: {1}" -f $_,$vName}
default {"Lost in Space"}
}
}},
@{Name="Capacity (GB)"; Expression = {[Math]::Round([Decimal]$_.Capacity/1GB, 2)}},
@{Name="Free (GB)"; Expression = {[Math]::Round([Decimal]$_.Free/1GB, 2)}},
@{Name="Last Write"; Expression = {$_.LastWriteTime}},
@{Name="Expiration Date"; Expression = {
If ($(Get-Date $_.ExpirationDate) -lt $(Get-Date)) {
"Expired"
} Else {
$_.ExpirationDate
}
}} | Sort "Last Write" | ConvertTo-HTML -Fragment
$bodyTpPool += $subHead01 + "All Tapes in Media Pool: " + $mp.Name + $subHead02 + $expTapes
}
}
}
# Get all Tapes in each Vault
$bodyTpVlt = $null
If ($showTpVlt) {
ForEach ($vlt in ($mediaVaults | Sort Name)) {
$expTapes = @($mediaTapes | where {($_.Location.VaultId -eq $vlt.Id)})
if($expTapes.Count -gt 0) {
$expTapes = $expTapes | Select Name, Barcode,
@{Name="Media Pool"; Expression = {
$poolId = $_.MediaPoolId
($mediaPools | ?{$_.Id -eq $poolId}).Name
}},
@{Name="Media Set"; Expression = {$_.MediaSet}}, @{Name="Sequence #"; Expression = {$_.SequenceNumber}},
@{Name="Capacity (GB)"; Expression = {[Math]::Round([Decimal]$_.Capacity/1GB, 2)}},
@{Name="Free (GB)"; Expression = {[Math]::Round([Decimal]$_.Free/1GB, 2)}},
@{Name="Last Write"; Expression = {$_.LastWriteTime}},
@{Name="Expiration Date"; Expression = {
If ($(Get-Date $_.ExpirationDate) -lt $(Get-Date)) {
"Expired"
} Else {
$_.ExpirationDate
}
}} | Sort Name | ConvertTo-HTML -Fragment
$bodyTpVlt += $subHead01 + "All Tapes in Vault: " + $vlt.Name + $subHead02 + $expTapes
}
}
}
# Get all Expired Tapes
$bodyExpTp = $null
If ($showExpTp) {
$expTapes = @($mediaTapes | where {($_.IsExpired -eq $True)})
if($expTapes.Count -gt 0) {
$expTapes = $expTapes | Select Name, Barcode,
@{Name="Media Pool"; Expression = {
$poolId = $_.MediaPoolId
($mediaPools | ?{$_.Id -eq $poolId}).Name
}},
@{Name="Media Set"; Expression = {$_.MediaSet}}, @{Name="Sequence #"; Expression = {$_.SequenceNumber}},
@{Name="Location"; Expression = {
switch ($_.Location) {
"None" {"Offline"}
"Slot" {
$lId = $_.LibraryId
$lName = $($mediaLibs | ?{$_.Id -eq $lId}).Name
[int]$slot = $_.SlotAddress + 1
"{0} : {1} {2}" -f $lName,$_,$slot
}
"Drive" {
$lId = $_.LibraryId
$dId = $_.DriveId
$lName = $($mediaLibs | ?{$_.Id -eq $lId}).Name
$dName = $($mediaDrives | ?{$_.Id -eq $dId}).Name
[int]$dNum = $_.Location.DriveAddress + 1
"{0} : {1} {2} (Drive ID: {3})" -f $lName,$_,$dNum,$dName
}
"Vault" {
$vId = $_.VaultId
$vName = $($mediaVaults | ?{$_.Id -eq $vId}).Name
"{0}: {1}" -f $_,$vName}
default {"Lost in Space"}
}
}},
@{Name="Capacity (GB)"; Expression = {[Math]::Round([Decimal]$_.Capacity/1GB, 2)}},
@{Name="Free (GB)"; Expression = {[Math]::Round([Decimal]$_.Free/1GB, 2)}},
@{Name="Last Write"; Expression = {$_.LastWriteTime}} | Sort Name | ConvertTo-HTML -Fragment
$bodyExpTp = $subHead01 + "All Expired Tapes" + $subHead02 + $expTapes
}
}
# Get Expired Tapes in each Custom Media Pool
$bodyTpExpPool = $null
If ($showExpTpMp) {
ForEach ($mp in ($mediaPools | ?{$_.Type -eq "Custom"} | Sort Name)) {
$expTapes = @($mediaTapes | where {($_.MediaPoolId -eq $mp.Id -and $_.IsExpired -eq $True)})
if($expTapes.Count -gt 0) {
$expTapes = $expTapes | Select Name, Barcode,
@{Name="Media Set"; Expression = {$_.MediaSet}}, @{Name="Sequence #"; Expression = {$_.SequenceNumber}},
@{Name="Location"; Expression = {
switch ($_.Location) {
"None" {"Offline"}
"Slot" {
$lId = $_.LibraryId
$lName = $($mediaLibs | ?{$_.Id -eq $lId}).Name
[int]$slot = $_.SlotAddress + 1
"{0} : {1} {2}" -f $lName,$_,$slot
}
"Drive" {
$lId = $_.LibraryId
$dId = $_.DriveId
$lName = $($mediaLibs | ?{$_.Id -eq $lId}).Name
$dName = $($mediaDrives | ?{$_.Id -eq $dId}).Name
[int]$dNum = $_.Location.DriveAddress + 1
"{0} : {1} {2} (Drive ID: {3})" -f $lName,$_,$dNum,$dName
}
"Vault" {
$vId = $_.VaultId
$vName = $($mediaVaults | ?{$_.Id -eq $vId}).Name
"{0}: {1}" -f $_,$vName}
default {"Lost in Space"}
}
}},
@{Name="Capacity (GB)"; Expression = {[Math]::Round([Decimal]$_.Capacity/1GB, 2)}},
@{Name="Free (GB)"; Expression = {[Math]::Round([Decimal]$_.Free/1GB, 2)}},
@{Name="Last Write"; Expression = {$_.LastWriteTime}} | Sort "Last Write" | ConvertTo-HTML -Fragment
$bodyTpExpPool += $subHead01 + "Expired Tapes in Media Pool: " + $mp.Name + $subHead02 + $expTapes
}
}
}
# Get Expired Tapes in each Vault
$bodyTpExpVlt = $null
If ($showExpTpVlt) {
ForEach ($vlt in ($mediaVaults | Sort Name)) {
$expTapes = @($mediaTapes | where {($_.Location.VaultId -eq $vlt.Id -and $_.IsExpired -eq $True)})
if($expTapes.Count -gt 0) {
$expTapes = $expTapes | Select Name, Barcode,
@{Name="Media Pool"; Expression = {
$poolId = $_.MediaPoolId
($mediaPools | ?{$_.Id -eq $poolId}).Name
}},
@{Name="Media Set"; Expression = {$_.MediaSet}}, @{Name="Sequence #"; Expression = {$_.SequenceNumber}},
@{Name="Capacity (GB)"; Expression = {[Math]::Round([Decimal]$_.Capacity/1GB, 2)}},
@{Name="Free (GB)"; Expression = {[Math]::Round([Decimal]$_.Free/1GB, 2)}},
@{Name="Last Write"; Expression = {$_.LastWriteTime}} | Sort "Last Write" | ConvertTo-HTML -Fragment
$bodyTpExpVlt += $subHead01 + "Expired Tapes in Vault: " + $vlt.Name + $subHead02 + $expTapes
}
}
}
# Get all Tapes written to within time frame
$bodyTpWrt = $null
If ($showTpWrt) {
$expTapes = @($mediaTapes | ?{$_.LastWriteTime -ge (Get-Date).AddHours(-$HourstoCheck)})
if($expTapes.Count -gt 0) {
$expTapes = $expTapes | Select Name, Barcode,
@{Name="Media Pool"; Expression = {
$poolId = $_.MediaPoolId
($mediaPools | ?{$_.Id -eq $poolId}).Name
}},
@{Name="Media Set"; Expression = {$_.MediaSet}}, @{Name="Sequence #"; Expression = {$_.SequenceNumber}},
@{Name="Location"; Expression = {
switch ($_.Location) {
"None" {"Offline"}
"Slot" {
$lId = $_.LibraryId
$lName = $($mediaLibs | ?{$_.Id -eq $lId}).Name
[int]$slot = $_.SlotAddress + 1
"{0} : {1} {2}" -f $lName,$_,$slot
}
"Drive" {
$lId = $_.LibraryId
$dId = $_.DriveId
$lName = $($mediaLibs | ?{$_.Id -eq $lId}).Name
$dName = $($mediaDrives | ?{$_.Id -eq $dId}).Name
[int]$dNum = $_.Location.DriveAddress + 1
"{0} : {1} {2} (Drive ID: {3})" -f $lName,$_,$dNum,$dName
}
"Vault" {
$vId = $_.VaultId
$vName = $($mediaVaults | ?{$_.Id -eq $vId}).Name
"{0}: {1}" -f $_,$vName}
default {"Lost in Space"}
}
}},
@{Name="Capacity (GB)"; Expression = {[Math]::Round([Decimal]$_.Capacity/1GB, 2)}},
@{Name="Free (GB)"; Expression = {[Math]::Round([Decimal]$_.Free/1GB, 2)}},
@{Name="Last Write"; Expression = {$_.LastWriteTime}},
@{Name="Expiration Date"; Expression = {
If ($(Get-Date $_.ExpirationDate) -lt $(Get-Date)) {
"Expired"
} Else {
$_.ExpirationDate
}
}} | Sort "Last Write" | ConvertTo-HTML -Fragment
$bodyTpWrt = $subHead01 + "All Tapes Written" + $subHead02 + $expTapes
}
}
# Get Agent Backup Summary Info
$bodySummaryEp = $null
If ($showSummaryEp) {
$vbrEpHash = @{
"Sessions" = If ($sessListEp) {@($sessListEp).Count} Else {0}
"Successful" = @($successSessionsEp).Count
"Warning" = @($warningSessionsEp).Count
"Fails" = @($failsSessionsEp).Count
"Running" = @($runningSessionsEp).Count
}
$vbrEPObj = New-Object -TypeName PSObject -Property $vbrEpHash
If ($onlyLastEp) {
$total = "Jobs Run"
} Else {
$total = "Total Sessions"
}
$arrSummaryEp = $vbrEPObj | Select @{Name=$total; Expression = {$_.Sessions}},
@{Name="Running"; Expression = {$_.Running}}, @{Name="Successful"; Expression = {$_.Successful}},
@{Name="Warnings"; Expression = {$_.Warning}}, @{Name="Failures"; Expression = {$_.Fails}}
$bodySummaryEp = $arrSummaryEp | ConvertTo-HTML -Fragment
If ($arrSummaryEp.Failures -gt 0) {
$summaryEpHead = $subHead01err
} ElseIf ($arrSummaryEp.Warnings -gt 0) {
$summaryEpHead = $subHead01war
} ElseIf ($arrSummaryEp.Successful -gt 0) {
$summaryEpHead = $subHead01suc
} Else {
$summaryEpHead = $subHead01
}
$bodySummaryEp = $summaryEpHead + "Agent Backup Results Summary" + $subHead02 + $bodySummaryEp
}
# Get Agent Backup Job Status
$bodyJobsEp = $null
If ($showJobsEp) {
If ($allJobsEp.count -gt 0) {
$bodyJobsEp = $allJobsEp | Sort Name | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Description"; Expression = {$_.Description}},
@{Name="Enabled"; Expression = {$_.IsEnabled}},@{Name="Status"; Expression = {$_.LastState}},
@{Name="Target Repo"; Expression = {$_.Target}}, @{Name="Next Run"; Expression = {$_.NextRun}},
@{Name="Last Result"; Expression = {If ($_.LastResult -eq "None"){""}Else{$_.LastResult}}} | ConvertTo-HTML -Fragment
$bodyJobsEp = $subHead01 + "Agent Backup Job Status" + $subHead02 + $bodyJobsEp
}
}
# Get Agent Backup Job Size
$bodyJobSizeEp = $null
If ($showBackupSizeEp) {
If ($backupsEp.count -gt 0) {
$bodyJobSizeEp = Get-BackupSize -backups $backupsEp | Sort JobName | Select @{Name="Job Name"; Expression = {$_.JobName}},
@{Name="VM Count"; Expression = {$_.VMCount}},
@{Name="Repository"; Expression = {$_.Repo}},
@{Name="Data Size (GB)"; Expression = {$_.DataSize}},
@{Name="Backup Size (GB)"; Expression = {$_.BackupSize}} | ConvertTo-HTML -Fragment
$bodyJobSizeEp = $subHead01 + "Agent Backup Job Size" + $subHead02 + $bodyJobSizeEp
}
}
# Get Agent Backup Sessions
$bodyAllSessEp = @()
$arrAllSessEp = @()
If ($showAllSessEp) {
If ($sessListEp.count -gt 0) {
Foreach($job in $allJobsEp) {
$arrAllSessEp += $sessListEp | ?{$_.JobId -eq $job.Id} | Select @{Name="Job Name"; Expression = {$job.Name}},
@{Name="State"; Expression = {$_.State}},@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {If ($_.EndTime -eq "1/1/1900 12:00:00 AM"){"-"} Else {$_.EndTime}}},
@{Name="Duration (HH:MM:SS)"; Expression = {
If ($_.EndTime -eq "1/1/1900 12:00:00 AM") {
Get-Duration -ts $(New-TimeSpan $_.CreationTime $(Get-Date))
} Else {
Get-Duration -ts $(New-TimeSpan $_.CreationTime $_.EndTime)
}
}}, Result
}
$bodyAllSessEp = $arrAllSessEp | Sort-Object "Start Time" | ConvertTo-HTML -Fragment
If ($arrAllSessEp.Result -match "Failed") {
$allSessEpHead = $subHead01err
} ElseIf ($arrAllSessEp.Result -match "Warning") {
$allSessEpHead = $subHead01war
} ElseIf ($arrAllSessEp.Result -match "Success") {
$allSessEpHead = $subHead01suc
} Else {
$allSessEpHead = $subHead01
}
$bodyAllSessEp = $allSessEpHead + "Agent Backup Sessions" + $subHead02 + $bodyAllSessEp
}
}
# Get Running Agent Backup Jobs
$bodyRunningEp = @()
If ($showRunningEp) {
If ($runningSessionsEp.count -gt 0) {
Foreach($job in $allJobsEp) {
$bodyRunningEp += $runningSessionsEp | ?{$_.JobId -eq $job.Id} | Select @{Name="Job Name"; Expression = {$job.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $(New-TimeSpan $_.CreationTime $(Get-Date))}}
}
$bodyRunningEp = $bodyRunningEp | Sort-Object "Start Time" | ConvertTo-HTML -Fragment
$bodyRunningEp = $subHead01 + "Running Agent Backup Jobs" + $subHead02 + $bodyRunningEp
}
}
# Get Agent Backup Sessions with Warnings or Failures
$bodySessWFEp = @()
$arrSessWFEp = @()
If ($showWarnFailEp) {
$sessWFEp = @($warningSessionsEp + $failsSessionsEp)
If ($sessWFEp.count -gt 0) {
If ($onlyLastEp) {
$headerWFEp = "Agent Backup Jobs with Warnings or Failures"
} Else {
$headerWFEp = "Agent Backup Sessions with Warnings or Failures"
}
Foreach($job in $allJobsEp) {
$arrSessWFEp += $sessWFEp | ?{$_.JobId -eq $job.Id} | Select @{Name="Job Name"; Expression = {$job.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}}, @{Name="Stop Time"; Expression = {$_.EndTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $(New-TimeSpan $_.CreationTime $_.EndTime)}},
Result
}
$bodySessWFEp = $arrSessWFEp | Sort-Object "Start Time" | ConvertTo-HTML -Fragment
If ($arrSessWFEp.Result -match "Failed") {
$sessWFEpHead = $subHead01err
} ElseIf ($arrSessWFEp.Result -match "Warning") {
$sessWFEpHead = $subHead01war
} ElseIf ($arrSessWFEp.Result -match "Success") {
$sessWFEpHead = $subHead01suc
} Else {
$sessWFEpHead = $subHead01
}
$bodySessWFEp = $sessWFEpHead + $headerWFEp + $subHead02 + $bodySessWFEp
}
}
# Get Successful Agent Backup Sessions
$bodySessSuccEp = @()
If ($showSuccessEp) {
If ($successSessionsEp.count -gt 0) {
If ($onlyLastEp) {
$headerSuccEp = "Successful Agent Backup Jobs"
} Else {
$headerSuccEp = "Successful Agent Backup Sessions"
}
Foreach($job in $allJobsEp) {
$bodySessSuccEp += $successSessionsEp | ?{$_.JobId -eq $job.Id} | Select @{Name="Job Name"; Expression = {$job.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}}, @{Name="Stop Time"; Expression = {$_.EndTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $(New-TimeSpan $_.CreationTime $_.EndTime)}},
Result
}
$bodySessSuccEp = $bodySessSuccEp | Sort-Object "Start Time" | ConvertTo-HTML -Fragment
$bodySessSuccEp = $subHead01suc + $headerSuccEp + $subHead02 + $bodySessSuccEp
}
}
# Get SureBackup Summary Info
$bodySummarySb = $null
If ($showSummarySb) {
$vbrMasterHash = @{
"Sessions" = If ($sessListSb) {@($sessListSb).Count} Else {0}
"Successful" = @($successSessionsSb).Count
"Warning" = @($warningSessionsSb).Count
"Fails" = @($failsSessionsSb).Count
"Running" = @($runningSessionsSb).Count
}
$vbrMasterObj = New-Object -TypeName PSObject -Property $vbrMasterHash
If ($onlyLastSb) {
$total = "Jobs Run"
} Else {
$total = "Total Sessions"
}
$arrSummarySb = $vbrMasterObj | Select @{Name=$total; Expression = {$_.Sessions}},
@{Name="Running"; Expression = {$_.Running}}, @{Name="Successful"; Expression = {$_.Successful}},
@{Name="Warnings"; Expression = {$_.Warning}}, @{Name="Failures"; Expression = {$_.Fails}}
$bodySummarySb = $arrSummarySb | ConvertTo-HTML -Fragment
If ($arrSummarySb.Failures -gt 0) {
$summarySbHead = $subHead01err
} ElseIf ($arrSummarySb.Warnings -gt 0) {
$summarySbHead = $subHead01war
} ElseIf ($arrSummarySb.Successful -gt 0) {
$summarySbHead = $subHead01suc
} Else {
$summarySbHead = $subHead01
}
$bodySummarySb = $summarySbHead + "SureBackup Results Summary" + $subHead02 + $bodySummarySb
}
# Get SureBackup Job Status
$bodyJobsSb = $null
If ($showJobsSb) {
If ($allJobsSb.count -gt 0) {
$bodyJobsSb = @()
Foreach($SbJob in $allJobsSb) {
$bodyJobsSb += $SbJob | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Enabled"; Expression = {$_.IsScheduleEnabled}},
@{Name="Status"; Expression = {
If ($_.GetLastState() -eq "Working") {
$currentSess = $_.FindLastSession()
$csessPercent = $currentSess.CompletionPercentage
$cStatus = "$($csessPercent)% completed"
$cStatus
} Else {
$_.GetLastState()
}
}},
@{Name="Virtual Lab"; Expression = {$(Get-VSBVirtualLab | Where {$_.Id -eq $SbJob.VirtualLabId}).Name}},
@{Name="Linked Jobs"; Expression = {$($_.GetLinkedJobs()).Name -join ","}},
@{Name="Next Run"; Expression = {
If ($_.IsScheduleEnabled -eq $false) {""}
ElseIf ($_.JobOptions.RunManually) {""}
ElseIf ($_.ScheduleOptions.IsContinious) {""}
ElseIf ($_.ScheduleOptions.OptionsScheduleAfterJob.IsEnabled) {"After [" + $(($allJobs + $allJobsTp) | Where {$_.Id -eq $SbJob.Info.ParentScheduleId}).Name + "]"}
Else {$_.ScheduleOptions.NextRun}}},
@{Name="Last Result"; Expression = {If ($_.GetLastResult() -eq "None"){""}Else{$_.GetLastResult()}}}
}
$bodyJobsSb = $bodyJobsSb | Sort "Next Run" | ConvertTo-HTML -Fragment
$bodyJobsSb = $subHead01 + "SureBackup Job Status" + $subHead02 + $bodyJobsSb
}
}
# Get SureBackup Sessions
$bodyAllSessSb = $null
If ($showAllSessSb) {
If ($sessListSb.count -gt 0) {
$arrAllSessSb = $sessListSb | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="State"; Expression = {$_.State}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {If ($_.EndTime -eq "1/1/1900 12:00:00 AM"){"-"} Else {$_.EndTime}}},
@{Name="Duration (HH:MM:SS)"; Expression = {
If ($_.EndTime -eq "1/1/1900 12:00:00 AM") {
Get-Duration -ts $(New-TimeSpan $_.CreationTime $(Get-Date))
} Else {
Get-Duration -ts $(New-TimeSpan $_.CreationTime $_.EndTime)
}
}}, Result
$bodyAllSessSb = $arrAllSessSb | ConvertTo-HTML -Fragment
If ($arrAllSessSb.Result -match "Failed") {
$allSessSbHead = $subHead01err
} ElseIf ($arrAllSessSb.Result -match "Warning") {
$allSessSbHead = $subHead01war
} ElseIf ($arrAllSessSb.Result -match "Success") {
$allSessSbHead = $subHead01suc
} Else {
$allSessSbHead = $subHead01
}
$bodyAllSessSb = $allSessSbHead + "SureBackup Sessions" + $subHead02 + $bodyAllSessSb
}
}
# Get Running SureBackup Jobs
$bodyRunningSb = $null
If ($showRunningSb) {
If ($runningSessionsSb.count -gt 0) {
$bodyRunningSb = $runningSessionsSb | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $(New-TimeSpan $_.CreationTime $(Get-Date))}},
@{Name="% Complete"; Expression = {$_.Progress}} | ConvertTo-HTML -Fragment
$bodyRunningSb = $subHead01 + "Running SureBackup Jobs" + $subHead02 + $bodyRunningSb
}
}
# Get SureBackup Sessions with Warnings or Failures
$bodySessWFSb = $null
If ($showWarnFailSb) {
$sessWF = @($warningSessionsSb + $failsSessionsSb)
If ($sessWF.count -gt 0) {
If ($onlyLastSb) {
$headerWF = "SureBackup Jobs with Warnings or Failures"
} Else {
$headerWF = "SureBackup Sessions with Warnings or Failures"
}
$arrSessWFSb = $sessWF | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {$_.EndTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $(New-TimeSpan $_.CreationTime $_.EndTime)}}, Result
$bodySessWFSb = $arrSessWFSb | ConvertTo-HTML -Fragment
If ($arrSessWFSb.Result -match "Failed") {
$sessWFSbHead = $subHead01err
} ElseIf ($arrSessWFSb.Result -match "Warning") {
$sessWFSbHead = $subHead01war
} ElseIf ($arrSessWFSb.Result -match "Success") {
$sessWFSbHead = $subHead01suc
} Else {
$sessWFSbHead = $subHead01
}
$bodySessWFSb = $sessWFSbHead + $headerWF + $subHead02 + $bodySessWFSb
}
}
# Get Successful SureBackup Sessions
$bodySessSuccSb = $null
If ($showSuccessSb) {
If ($successSessionsSb.count -gt 0) {
If ($onlyLastSb) {
$headerSucc = "Successful SureBackup Jobs"
} Else {
$headerSucc = "Successful SureBackup Sessions"
}
$bodySessSuccSb = $successSessionsSb | Sort Creationtime | Select @{Name="Job Name"; Expression = {$_.Name}},
@{Name="Start Time"; Expression = {$_.CreationTime}},
@{Name="Stop Time"; Expression = {$_.EndTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $(New-TimeSpan $_.CreationTime $_.EndTime)}},
Result | ConvertTo-HTML -Fragment
$bodySessSuccSb = $subHead01suc + $headerSucc + $subHead02 + $bodySessSuccSb
}
}
## Gathering tasks after session info has been recorded due to Veeam issue
# Gather all SureBackup Tasks from Sessions within time frame
$taskListSb = @()
$taskListSb += $sessListSb | Get-VSBTaskSession
$successTasksSb = @($taskListSb | ?{$_.Info.Result -eq "Success"})
$wfTasksSb = @($taskListSb | ?{$_.Info.Result -match "Warning|Failed"})
$runningTasksSb = @()
$runningTasksSb += $runningSessionsSb | Get-VSBTaskSession | ?{$_.Status -ne "Stopped"}
# Get SureBackup Tasks
$bodyAllTasksSb = $null
If ($showAllTasksSb) {
If ($taskListSb.count -gt 0) {
$arrAllTasksSb = $taskListSb | Select @{Name="VM Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSession.JobName}},
@{Name="Status"; Expression = {$_.Status}},
@{Name="Start Time"; Expression = {$_.Info.StartTime}},
@{Name="Stop Time"; Expression = {If ($_.Info.FinishTime -eq "1/1/1900 12:00:00 AM"){"-"} Else {$_.Info.FinishTime}}},
@{Name="Duration (HH:MM:SS)"; Expression = {
If ($_.Info.FinishTime -eq "1/1/1900 12:00:00 AM") {
Get-Duration -ts $(New-TimeSpan $_.Info.StartTime $(Get-Date))
} Else {
Get-Duration -ts $(New-TimeSpan $_.Info.StartTime $_.Info.FinishTime)
}
}},
@{Name="Heartbeat Test"; Expression = {$_.HeartbeatStatus}},
@{Name="Ping Test"; Expression = {$_.PingStatus}},
@{Name="Script Test"; Expression = {$_.TestScriptStatus}},
@{Name="Validation Test"; Expression = {$_.VadiationTestStatus}},
@{Name="Result"; Expression = {
If ($_.Info.Result -eq "notrunning") {
"None"
} Else {
$_.Info.Result
}
}}
$bodyAllTasksSb = $arrAllTasksSb | Sort "Start Time" | ConvertTo-HTML -Fragment
If ($arrAllTasksSb.Result -match "Failed") {
$allTasksSbHead = $subHead01err
} ElseIf ($arrAllTasksSb.Result -match "Warning") {
$allTasksSbHead = $subHead01war
} ElseIf ($arrAllTasksSb.Result -match "Success") {
$allTasksSbHead = $subHead01suc
} Else {
$allTasksSbHead = $subHead01
}
$bodyAllTasksSb = $allTasksSbHead + "SureBackup Tasks" + $subHead02 + $bodyAllTasksSb
}
}
# Get Running SureBackup Tasks
$bodyTasksRunningSb = $null
If ($showRunningTasksSb) {
If ($runningTasksSb.count -gt 0) {
$bodyTasksRunningSb = $runningTasksSb | Select @{Name="VM Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSession.JobName}},
@{Name="Start Time"; Expression = {$_.Info.StartTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $(New-TimeSpan $_.Info.StartTime $(Get-Date))}},
@{Name="Heartbeat Test"; Expression = {$_.HeartbeatStatus}},
@{Name="Ping Test"; Expression = {$_.PingStatus}},
@{Name="Script Test"; Expression = {$_.TestScriptStatus}},
@{Name="Validation Test"; Expression = {$_.VadiationTestStatus}},
Status | Sort "Start Time" | ConvertTo-HTML -Fragment
$bodyTasksRunningSb = $subHead01 + "Running SureBackup Tasks" + $subHead02 + $bodyTasksRunningSb
}
}
# Get SureBackup Tasks with Warnings or Failures
$bodyTaskWFSb = $null
If ($showTaskWFSb) {
If ($wfTasksSb.count -gt 0) {
$arrTaskWFSb = $wfTasksSb | Select @{Name="VM Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSession.JobName}},
@{Name="Start Time"; Expression = {$_.Info.StartTime}},
@{Name="Stop Time"; Expression = {$_.Info.FinishTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $(New-TimeSpan $_.Info.StartTime $_.Info.FinishTime)}},
@{Name="Heartbeat Test"; Expression = {$_.HeartbeatStatus}},
@{Name="Ping Test"; Expression = {$_.PingStatus}},
@{Name="Script Test"; Expression = {$_.TestScriptStatus}},
@{Name="Validation Test"; Expression = {$_.VadiationTestStatus}},
@{Name="Result"; Expression = {$_.Info.Result}}
$bodyTaskWFSb = $arrTaskWFSb | Sort "Start Time" | ConvertTo-HTML -Fragment
If ($arrTaskWFSb.Result -match "Failed") {
$taskWFSbHead = $subHead01err
} ElseIf ($arrTaskWFSb.Result -match "Warning") {
$taskWFSbHead = $subHead01war
} ElseIf ($arrTaskWFSb.Result -match "Success") {
$taskWFSbHead = $subHead01suc
} Else {
$taskWFSbHead = $subHead01
}
$bodyTaskWFSb = $taskWFSbHead + "SureBackup Tasks with Warnings or Failures" + $subHead02 + $bodyTaskWFSb
}
}
# Get Successful SureBackup Tasks
$bodyTaskSuccSb = $null
If ($showTaskSuccessSb) {
If ($successTasksSb.count -gt 0) {
$bodyTaskSuccSb = $successTasksSb | Select @{Name="VM Name"; Expression = {$_.Name}},
@{Name="Job Name"; Expression = {$_.JobSession.JobName}},
@{Name="Start Time"; Expression = {$_.Info.StartTime}},
@{Name="Stop Time"; Expression = {$_.Info.FinishTime}},
@{Name="Duration (HH:MM:SS)"; Expression = {Get-Duration -ts $(New-TimeSpan $_.Info.StartTime $_.Info.FinishTime)}},
@{Name="Heartbeat Test"; Expression = {$_.HeartbeatStatus}},
@{Name="Ping Test"; Expression = {$_.PingStatus}},
@{Name="Script Test"; Expression = {$_.TestScriptStatus}},
@{Name="Validation Test"; Expression = {$_.VadiationTestStatus}},
@{Name="Result"; Expression = {$_.Info.Result}} | Sort "Start Time" | ConvertTo-HTML -Fragment
$bodyTaskSuccSb = $subHead01suc + "Successful SureBackup Tasks" + $subHead02 + $bodyTaskSuccSb
}
}
# Get Configuration Backup Summary Info
$bodySummaryConfig = $null
If ($showSummaryConfig) {
$vbrConfigHash = @{
"Enabled" = $configBackup.Enabled
"Status" = $configBackup.LastState
"Target" = $configBackup.Target
"Schedule" = $configBackup.ScheduleOptions
"Restore Points" = $configBackup.RestorePointsToKeep
"Encrypted" = $configBackup.EncryptionOptions.Enabled
"Last Result" = $configBackup.LastResult
"Next Run" = $configBackup.NextRun
}
$vbrConfigObj = New-Object -TypeName PSObject -Property $vbrConfigHash
$bodySummaryConfig = $vbrConfigObj | Select Enabled, Status, Target, Schedule, "Restore Points", "Next Run", Encrypted, "Last Result" | ConvertTo-HTML -Fragment
If ($configBackup.LastResult -eq "Warning" -or !$configBackup.Enabled) {
$configHead = $subHead01war
} ElseIf ($configBackup.LastResult -eq "Success") {
$configHead = $subHead01suc
} ElseIf ($configBackup.LastResult -eq "Failed") {
$configHead = $subHead01err
} Else {
$configHead = $subHead01
}
$bodySummaryConfig = $configHead + "Configuration Backup Status" + $subHead02 + $bodySummaryConfig
}
# Get Proxy Info
$bodyProxy = $null
If ($showProxy) {
If ($proxyList -ne $null) {
$arrProxy = $proxyList | Get-VBRProxyInfo | Select @{Name="Proxy Name"; Expression = {$_.ProxyName}},
@{Name="Transport Mode"; Expression = {$_.tMode}}, @{Name="Max Tasks"; Expression = {$_.MaxTasks}},
@{Name="Proxy Host"; Expression = {$_.RealName}}, @{Name="Host Type"; Expression = {$_.pType}},
Enabled, @{Name="IP Address"; Expression = {$_.IP}},
@{Name="RT (ms)"; Expression = {$_.Response}}, Status
$bodyProxy = $arrProxy | Sort "Proxy Host" | ConvertTo-HTML -Fragment
If ($arrProxy.Status -match "Dead") {
$proxyHead = $subHead01err
} ElseIf ($arrProxy -match "Alive") {
$proxyHead = $subHead01suc
} Else {
$proxyHead = $subHead01
}
$bodyProxy = $proxyHead + "Proxy Details" + $subHead02 + $bodyProxy
}
}
# Get Repository Info
$bodyRepo = $null
If ($showRepo) {
If ($repoList -ne $null) {
$arrRepo = $repoList | Get-VBRRepoInfo | Select @{Name="Repository Name"; Expression = {$_.Target}},
@{Name="Type"; Expression = {$_.rType}}, @{Name="Max Tasks"; Expression = {$_.MaxTasks}},
@{Name="Host"; Expression = {$_.RepoHost}}, @{Name="Path"; Expression = {$_.Storepath}},
@{Name="Free (GB)"; Expression = {$_.StorageFree}}, @{Name="Total (GB)"; Expression = {$_.StorageTotal}},
@{Name="Free (%)"; Expression = {$_.FreePercentage}},
@{Name="Status"; Expression = {
If ($_.FreePercentage -lt $repoCritical) {"Critical"}
ElseIf ($_.StorageTotal -eq 0) {"Warning"}
ElseIf ($_.FreePercentage -lt $repoWarn) {"Warning"}
ElseIf ($_.FreePercentage -eq "Unknown") {"Unknown"}
Else {"OK"}}
}
$bodyRepo = $arrRepo | Sort "Repository Name" | ConvertTo-HTML -Fragment
If ($arrRepo.status -match "Critical") {
$repoHead = $subHead01err
} ElseIf ($arrRepo.status -match "Warning|Unknown") {
$repoHead = $subHead01war
} ElseIf ($arrRepo.status -match "OK") {
$repoHead = $subHead01suc
} Else {
$repoHead = $subHead01
}
$bodyRepo = $repoHead + "Repository Details" + $subHead02 + $bodyRepo
}
}
# Get Scale Out Repository Info
$bodySORepo = $null
If ($showRepo) {
If ($repoListSo -ne $null) {
$arrSORepo = $repoListSo | Get-VBRSORepoInfo | Select @{Name="Scale Out Repository Name"; Expression = {$_.SOTarget}},
@{Name="Member Repository Name"; Expression = {$_.Target}}, @{Name="Type"; Expression = {$_.rType}},
@{Name="Max Tasks"; Expression = {$_.MaxTasks}}, @{Name="Host"; Expression = {$_.RepoHost}},
@{Name="Path"; Expression = {$_.Storepath}}, @{Name="Free (GB)"; Expression = {$_.StorageFree}},
@{Name="Total (GB)"; Expression = {$_.StorageTotal}}, @{Name="Free (%)"; Expression = {$_.FreePercentage}},
@{Name="Status"; Expression = {
If ($_.FreePercentage -lt $repoCritical) {"Critical"}
ElseIf ($_.StorageTotal -eq 0) {"Warning"}
ElseIf ($_.FreePercentage -lt $repoWarn) {"Warning"}
ElseIf ($_.FreePercentage -eq "Unknown") {"Unknown"}
Else {"OK"}}
}
$bodySORepo = $arrSORepo | Sort "Scale Out Repository Name", "Member Repository Name" | ConvertTo-HTML -Fragment
If ($arrSORepo.status -match "Critical") {
$sorepoHead = $subHead01err
} ElseIf ($arrSORepo.status -match "Warning|Unknown") {
$sorepoHead = $subHead01war
} ElseIf ($arrSORepo.status -match "OK") {
$sorepoHead = $subHead01suc
} Else {
$sorepoHead = $subHead01
}
$bodySORepo = $sorepoHead + "Scale Out Repository Details" + $subHead02 + $bodySORepo
}
}
# Get Repository Agent User Permissions
$bodyRepoPerms = $null
If ($showRepoPerms){
If ($repoList -ne $null -or $repoListSo -ne $null) {
$bodyRepoPerms = Get-RepoPermissions | Select Name, "Encryption Enabled", "Permission Type", Users | Sort Name | ConvertTo-HTML -Fragment
$bodyRepoPerms = $subHead01 + "Repository Permissions for Agent Jobs" + $subHead02 + $bodyRepoPerms
}
}
# Get Replica Target Info
$bodyReplica = $null
If ($showReplicaTarget) {
If ($allJobsRp -ne $null) {
$repTargets = $allJobsRp | Get-VBRReplicaTarget | Select @{Name="Replica Target"; Expression = {$_.Target}}, Datastore,
@{Name="Free (GB)"; Expression = {$_.StorageFree}}, @{Name="Total (GB)"; Expression = {$_.StorageTotal}},
@{Name="Free (%)"; Expression = {$_.FreePercentage}},
@{Name="Status"; Expression = {
If ($_.FreePercentage -lt $replicaCritical) {"Critical"}
ElseIf ($_.StorageTotal -eq 0) {"Warning"}
ElseIf ($_.FreePercentage -lt $replicaWarn) {"Warning"}
ElseIf ($_.FreePercentage -eq "Unknown") {"Unknown"}
Else {"OK"}
}
} | Sort "Replica Target"
$bodyReplica = $repTargets | ConvertTo-HTML -Fragment
If ($repTargets.status -match "Critical") {
$reptarHead = $subHead01err
} ElseIf ($repTargets.status -match "Warning|Unknown") {
$reptarHead = $subHead01war
} ElseIf ($repTargets.status -match "OK") {
$reptarHead = $subHead01suc
} Else {
$reptarHead = $subHead01
}
$bodyReplica = $reptarHead + "Replica Target Details" + $subHead02 + $bodyReplica
}
}
# Get Veeam Services Info
$bodyServices = $null
If ($showServices) {
$vServers = Get-VeeamWinServers
$vServices = Get-VeeamServices $vServers
If ($hideRunningSvc) {$vServices = $vServices | ?{$_.Status -ne "Running"}}
If ($vServices -ne $null) {
$vServices = $vServices | Select "Server Name", "Service Name",
@{Name="Status"; Expression = {If ($_.Status -eq "Stopped"){"Not Running"} Else {$_.Status}}}
$bodyServices = $vServices | Sort "Server Name", "Service Name" | ConvertTo-HTML -Fragment
If ($vServices.status -match "Not Running") {
$svcHead = $subHead01err
} ElseIf ($vServices.status -notmatch "Running") {
$svcHead = $subHead01war
} ElseIf ($vServices.status -match "Running") {
$svcHead = $subHead01suc
} Else {
$svcHead = $subHead01
}
$bodyServices = $svcHead + "Veeam Services (Windows)" + $subHead02 + $bodyServices
}
}
# Get License Info
$bodyLicense = $null
If ($showLicExp) {
$arrLicense = Get-VeeamSupportDate $vbrServer | Select @{Name="Expiry Date"; Expression = {$_.ExpDate}},
@{Name="Days Remaining"; Expression = {$_.DaysRemain}}, `
@{Name="Status"; Expression = {
If ($_.DaysRemain -lt $licenseCritical) {"Critical"}
ElseIf ($_.DaysRemain -lt $licenseWarn) {"Warning"}
ElseIf ($_.DaysRemain -eq "Failed") {"Failed"}
Else {"OK"}}
}
$bodyLicense = $arrLicense | ConvertTo-HTML -Fragment
If ($arrLicense.Status -eq "OK") {
$licHead = $subHead01suc
} ElseIf ($arrLicense.Status -eq "Warning") {
$licHead = $subHead01war
} Else {
$licHead = $subHead01err
}
$bodyLicense = $licHead + "License/Support Renewal Date" + $subHead02 + $bodyLicense
}
#endregion
#$htmlOutput = $bodyAllTasksBk
$htmlOutput = $bodyAllSessBk
#region Output
# Send Report via Email
If ($sendEmail) {
$smtp = New-Object System.Net.Mail.SmtpClient($emailHost, $emailPort)
$smtp.Credentials = New-Object System.Net.NetworkCredential($emailUser, $emailPass)
$smtp.EnableSsl = $emailEnableSSL
$msg = New-Object System.Net.Mail.MailMessage($emailFrom, $emailTo)
$msg.Subject = $emailSubject
If ($emailAttach) {
$body = "Veeam Report Attached"
$msg.Body = $body
$tempFile = "$env:TEMP\$($rptTitle)_$(Get-Date -format MMddyyyy_hhmmss).htm"
$htmlOutput | Out-File $tempFile
$attachment = new-object System.Net.Mail.Attachment $tempFile
$msg.Attachments.Add($attachment)
} Else {
$body = $htmlOutput
$msg.Body = $body
$msg.isBodyhtml = $true
}
$smtp.send($msg)
If ($emailAttach) {
$attachment.dispose()
Remove-Item $tempFile
}
}
# Save HTML Report to File
If ($saveHTML) {
$htmlOutput | Out-File $pathHTML
If ($launchHTML) {
Invoke-Item $pathHTML
}
}
$Date | Select-Object $date | Export-Csv -Path "\\wigo4it.local\dfs\Documentatie\TBW\scripts output\Wigo4it_VeeamDate_log.csv" -NoTypeInformation
#endregion | | |