{"id":690,"date":"2015-11-07T12:50:39","date_gmt":"2015-11-07T12:50:39","guid":{"rendered":"http:\/\/virtualworlduk.co.uk\/?p=690"},"modified":"2015-11-07T12:50:39","modified_gmt":"2015-11-07T12:50:39","slug":"3-day-veeam-backup-report-powercli","status":"publish","type":"post","link":"https:\/\/www.virtualworlduk.co.uk\/wordp\/3-day-veeam-backup-report-powercli\/","title":{"rendered":"3 day Veeam Backup Report – Powercli"},"content":{"rendered":"

Just to confirm that I am, by no means, a Powercli (PowerShell) expert and would still class myself as a novice. \u00a0With this in mind there are probably tips and better ways to perform some of the items involved in my scripts… but the items that I have done seem to work for me and may help someone else in the process.<\/p>\n

The script enclosed below is a a module that can be added to the ‘SysAdmin Modular Report’ that was created by ‘TheAgreeableCow’ and featured on Veeams community forums… links below:<\/p>\n

http:\/\/www.theagreeablecow.com\/2012\/09\/sysadmin-modular-reporting-samreports.html<\/a><\/p>\n

http:\/\/forums.veeam.com\/powershell-f26\/sysadmin-modular-reporting-samreport-for-veeam-t13422.html<\/a><\/p>\n

The concept behind SAMReport is taken from some of the work done by Alan Renouf with his vCheck Report: \u00a0http:\/\/www.virtu-al.net\/vcheck-pluginsheaders\/vcheck\/<\/a><\/p>\n

Due to wanting to create a table which is colour coded to show whether backups have been successful or failed, I have also utilised code from Martin Pugh called Set-CellColor, this can be found here: \u00a0http:\/\/community.spiceworks.com\/scripts\/show\/2450-change-cell-color-in-html-table-with-powershell-set-cellcolor<\/a><\/p>\n

 <\/p>\n

Idea behind the report<\/strong><\/p>\n

So the idea behind the report was to make it easier for our backup administrators to perform their daily backup checks and to see whether there had been a failure of a backup over multiple days. \u00a0As with many companies, we have to abide by some Sarbannes-Oxley requirements, with our backups being subject to some of those checks. \u00a0The report checks the last three or four days of Veeam backups and compares them against your virtual machines to produce a report showing the success or failure of the backup over the previous days. \u00a0When a backup is successful, it turns the cell green with Success written in the cell and when it fails, it turns the cell red with Failed written in the cell.<\/p>\n

There is also an element that excludes VMs… firstly it only checks powered on VMs (powered off VMs do not need to be checked on a daily backup check), secondly I use VMware Tags to create a list of Excluded VMs using a Tag Category of ‘Backup Tags’… this means that any virtual machine which has a Tag assigned to it with the Category ‘Backup Tags’ will also be excluded from the report.<\/p>\n

As this report will run on a Tuesday through to Sunday to check the backups from the previous three or four nights (we do not have any backups that run on a Sunday), I also introduced a way for the script to change the Saturday backup column to read ‘Weekend of date<\/em>‘ and check across both Saturday and Sunday\u00a0(just in case a weekly backup has run through to the Sunday).<\/p>\n

Anyway, that’s enough about the idea behind the report, please find enclosed below a view of how the report comes out and also the script:<\/p>\n

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

[powershell]<\/p>\n

asnp "VeeamPSSnapIn" -ErrorAction SilentlyContinue<\/p>\n

####################################################################
\n# Configuration
\n#
\n# vCenter server
\n$Title = "Veeam Protected Machines in Woking"<\/p>\n

$vcenter = $VMware_Server
\n#
\n# To Exclude VMs from report add VM names to be excluded as fol
\n# simple wildcards are supported:
\n# $excludevms=@("vm1","vm2", "*_replica")<\/p>\n

#$srmvms=@()<\/p>\n

#Connect-SrmServer
\n#$SrmConnection=Connect-SrmServer
\n#$SrmApi=$SrmConnection.ExtensionData
\n#$protectionGroups = $srmApi.Protection.ListProtectionGroups()
\n#$protectionGroups | % {
\n# $protectionGroup = $_<\/p>\n

# $protectionGroupInfo = $protectionGroup.GetInfo()<\/p>\n

# The following command lists the virtual machines associated with a protection group
\n# $protectedVms = $protectionGroup.ListProtectedVms()
\n# The result of the above call is an array of references to the virtual machines at the vSphere API
\n# To populate the data from the vSphere connection, call the UpdateViewData method on each virtual machine view object
\n# $protectedVms | % { $_.Vm.UpdateViewData() }
\n# After the data is populated, use it to generate a report<\/p>\n

# $protectedVms | %{
\n# select VmName
\n# $srmvms+=$_.VM.Name
\n# }
\n#}
\n$excludevms=@()<\/p>\n

$table = ""
\n$TableName = ""
\n$1days = ""
\n$2days = ""
\n$3days = ""
\n$4days = ""
\n$5days = ""
\n$6days = ""
\n$7days = ""
\n$8days = ""
\n$9days = ""
\n####################################################################<\/p>\n

Function Set-CellColor
\n{ &lt;#
\n.SYNOPSIS
\nFunction that allows you to set individual cell colors in an HTML table
\n.DESCRIPTION
\nTo be used inconjunction with ConvertTo-HTML this simple function allows you
\nto set particular colors for cells in an HTML table. You provide the criteria
\nthe script uses to make the determination if a cell should be a particular
\ncolor (property -gt 5, property -like "*Apple*", etc).<\/p>\n

You can add the function to your scripts, dot source it to load into your current
\nPowerShell session or add it to your $Profile so it is always available.<\/p>\n

To dot source:
\n.".\\Set-CellColor.ps1"<\/p>\n

.PARAMETER Property
\nProperty, or column that you will be keying on.
\n.PARAMETER Color
\nName or 6-digit hex value of the color you want the cell to be
\n.PARAMETER InputObject
\nHTML you want the script to process. This can be entered directly into the
\nparameter or piped to the function.
\n.PARAMETER Filter
\nSpecifies a query to determine if a cell should have its color changed. $true
\nresults will make the color change while $false result will return nothing.<\/p>\n

Syntax
\n&lt;Property Name&gt; &lt;Operator&gt; &lt;Value&gt;<\/p>\n

&lt;Property Name&gt;::= the same as $Property. This must match exactly
\n&lt;Operator&gt;::= "-eq" | "-le" | "-ge" | "-ne" | "-lt" | "-gt"| "-approx" | "-like" | "-notlike"
\n&lt;JoinOperator&gt; ::= "-and" | "-or"
\n&lt;NotOperator&gt; ::= "-not"<\/p>\n

The script first attempts to convert the cell to a number, and if it fails it will
\ncast it as a string. So 40 will be a number and you can use -lt, -gt, etc. But 40%
\nwould be cast as a string so you could only use -eq, -ne, -like, etc.
\n.PARAMETER Row
\nInstructs the script to change the entire row to the specified color instead of the individual cell.
\n.INPUTS
\nHTML with table
\n.OUTPUTS
\nHTML
\n.EXAMPLE
\nget-process | convertto-html | set-cellcolor -Propety cpu -Color red -Filter "cpu -gt 1000" | out-file c:\\test\\get-process.html<\/p>\n

Assuming Set-CellColor has been dot sourced, run Get-Process and convert to HTML.
\nThen change the CPU cell to red only if the CPU field is greater than 1000.<\/p>\n

.EXAMPLE
\nget-process | convertto-html | set-cellcolor cpu red -filter "cpu -gt 1000 -and cpu -lt 2000" | out-file c:\\test\\get-process.html<\/p>\n

Same as Example 1, but now we will only turn a cell red if CPU is greater than 100
\nbut less than 2000.<\/p>\n

.EXAMPLE
\n$HTML = $Data | sort server | ConvertTo-html -head $header | Set-CellColor cookedvalue red -Filter "cookedvalue -gt 1"
\nPS C:\\&gt; $HTML = $HTML | Set-CellColor Server green -Filter "server -eq ‘dc2’"
\nPS C:\\&gt; $HTML | Set-CellColor Path Yellow -Filter "Path -like ""*memory*""" | Out-File c:\\Test\\colortest.html<\/p>\n

Takes a collection of objects in $Data, sorts on the property Server and converts to HTML. From there
\nwe set the "CookedValue" property to red if it’s greater then 1. We then send the HTML through Set-CellColor
\nagain, this time setting the Server cell to green if it’s "dc2". One more time through Set-CellColor
\nturns the Path cell to Yellow if it contains the word "memory" in it.<\/p>\n

.EXAMPLE
\n$HTML = $Data | sort server | ConvertTo-html -head $header | Set-CellColor cookedvalue red -Filter "cookedvalue -gt 1" -Row<\/p>\n

Now, if the cookedvalue property is greater than 1 the function will highlight the entire row red.<\/p>\n

.NOTES
\nAuthor: Martin Pugh
\nTwitter: @thesurlyadm1n
\nSpiceworks: Martin9700
\nBlog: www.thesurlyadmin.com<\/p>\n

Changelog:
\n1.5 Added ability to set row color with -Row switch instead of the individual cell
\n1.03 Added error message in case the $Property field cannot be found in the table header
\n1.02 Added some additional text to help. Added some error trapping around $Filter
\ncreation.
\n1.01 Added verbose output
\n1.0 Initial Release
\n.LINK
\nhttp:\/\/community.spiceworks.com\/scripts\/show\/2450-change-cell-color-in-html-table-with-powershell-set-cellcolor
\n#&gt;<\/p>\n

[CmdletBinding()]
\nParam (
\n[Parameter(Mandatory=$true,Position=0)]
\n[string]$Property,
\n[Parameter(Mandatory=$true,Position=1)]
\n[string]$Color,
\n[Parameter(Mandatory=$true,ValueFromPipeline=$true)]
\n[Object[]]$InputObject,
\n[Parameter(Mandatory=$true)]
\n[string]$Filter,
\n[switch]$Row
\n)<\/p>\n

Begin {
\nWrite-Verbose "$(Get-Date): Function Set-CellColor begins"
\nIf ($Filter)
\n{ If ($Filter.ToUpper().IndexOf($Property.ToUpper()) -ge 0)
\n{ $Filter = $Filter.ToUpper().Replace($Property.ToUpper(),"`$Value")
\nTry {
\n[scriptblock]$Filter = [scriptblock]::Create($Filter)
\n}
\nCatch {
\nWrite-Warning "$(Get-Date): ""$Filter"" caused an error, stopping script!"
\nWrite-Warning $Error[0]
\nExit
\n}
\n}
\nElse
\n{ Write-Warning "Could not locate $Property in the Filter, which is required. Filter: $Filter"
\nExit
\n}
\n}
\n}<\/p>\n

Process {
\nForEach ($Line in $InputObject)
\n{ If ($Line.IndexOf("&lt;tr&gt;&lt;th") -ge 0)
\n{ Write-Verbose "$(Get-Date): Processing headers…"
\n$Search = $Line | Select-String -Pattern ‘&lt;th ?[a-z\\-:;"=]*&gt;(.*?)&lt;\\\/th&gt;’ -AllMatches
\n$Index = 0
\nForEach ($Match in $Search.Matches)
\n{ If ($Match.Groups[1].Value -eq $Property)
\n{ Break
\n}
\n$Index ++
\n}
\nIf ($Index -eq $Search.Matches.Count)
\n{ Write-Warning "$(Get-Date): Unable to locate property: $Property in table header"
\nExit
\n}
\nWrite-Verbose "$(Get-Date): $Property column found at index: $Index"
\n}
\nIf ($Line -match "&lt;tr( style=""background-color:.+?"")?&gt;&lt;td")
\n{ $Search = $Line | Select-String -Pattern ‘&lt;td ?[a-z\\-:;"=]*&gt;(.*?)&lt;\\\/td&gt;’ -AllMatches
\n$Value = $Search.Matches[$Index].Groups[1].Value -as [double]
\nIf (-not $Value)
\n{ $Value = $Search.Matches[$Index].Groups[1].Value
\n}
\nIf (Invoke-Command $Filter)
\n{ If ($Row)
\n{ Write-Verbose "$(Get-Date): Criteria met! Changing row to $Color…"
\nIf ($Line -match "&lt;tr style=""background-color:(.+?)""&gt;")
\n{ $Line = $Line -replace "&lt;tr style=""background-color:$($Matches[1])","&lt;tr style=""background-color:$Color"
\n}
\nElse
\n{ $Line = $Line.Replace("&lt;tr&gt;","&lt;tr style=""background-color:$Color""&gt;")
\n}
\n}
\nElse
\n{ Write-Verbose "$(Get-Date): Criteria met! Changing cell to $Color…"
\n$Line = $Line.Replace($Search.Matches[$Index].Value,"&lt;td style=""background-color:$Color""&gt;$Value&lt;\/td&gt;")
\n}
\n}
\n}
\nWrite-Output $Line
\n}
\n}<\/p>\n

End {
\nWrite-Verbose "$(Get-Date): Function Set-CellColor completed"
\n}
\n}<\/p>\n

$vcenterobj = Get-VBRServer -Name $vcenter
\nNew-VIProperty -Name Tag -ObjectType VirtualMachine -Value { Get-TagAssignment -Entity $args[0] -Category "" | select -ExpandProperty Tag }
\n$excludevms=@(get-tagassignment -Category ‘Backup Tags’ | select -property @{N=’VM’;E={$_.Entity}})<\/p>\n

$FullVM = Get-vm | Where-Object {$_.PowerState -eq "PoweredOn" -and $_ -notin $excludevms.VM.Name}<\/p>\n

# Get a list of all VMs from vCenter and add to hash table, assume Unprotected
\n$Result=@()
\nforeach ($vm in ($FullVM | ForEach-Object {$_ | Select-object @{Name="VMname";Expression={$_.Name}}})) {<\/p>\n

$vm | Add-Member -MemberType NoteProperty -Name "backed_up" -Value $False
\n$vm | Add-Member -MemberType NoteProperty -Name "backed_up2" -Value $False
\n$vm | Add-Member -MemberType NoteProperty -Name "backed_up3" -Value $False
\n$vm | Add-Member -MemberType NoteProperty -Name "backed_up4" -Value $False<\/p>\n

$Result += $vm
\n# }
\n}
\n# Find all backup job sessions that have ended in the last week
\n$vbrsessions = ""<\/p>\n

if ([DateTime]::Today.AddDays(-1).DayOfWeek -eq "Saturday") {<\/p>\n

$vbrsessions = Get-VBRBackupSession | Where-Object {$_.JobType -eq "Backup" -or $_.JobType -eq "Replica" -and $_.EndTime -ge [DateTime]::Today.AddDays(-1).AddHours(05) -and $_.EndTime -lt [DateTime]::Today.AddHours(23) -and $_ -notin $excludevms.VM.Name}<\/p>\n

foreach ($session in $vbrsessions) {
\nforeach ($vm in ($session.gettasksessions() | ForEach-Object { $_ | Select-object @{Name="VMname";Expression={$_.Name}}})) {<\/p>\n

$VMObj = $Result | where {$_.VMName -eq $vm.VMname }
\nif ($VMObj){
\n$VMObj.backed_up = $True<\/p>\n

}<\/p>\n

}
\n}<\/p>\n

}<\/p>\n

if ([DateTime]::Today.AddDays(-1).DayOfWeek -eq "Friday") {<\/p>\n

$vbrsessions = Get-VBRBackupSession | Where-Object {$_.JobType -eq "Backup" -or $_.JobType -eq "Replica" -and $_.EndTime -ge [DateTime]::Today.AddDays(-1).AddHours(17) -and $_.EndTime -lt [DateTime]::Today.AddHours(04) -and $_ -notin $excludevms.VM.Name}<\/p>\n

foreach ($session in $vbrsessions) {
\nforeach ($vm in ($session.gettasksessions() | ForEach-Object { $_ | Select-object @{Name="VMname";Expression={$_.Name}}})) {<\/p>\n

$VMObj = $Result | where {$_.VMName -eq $vm.VMname }
\nif ($VMObj){
\n$VMObj.backed_up = $True<\/p>\n

}<\/p>\n

}
\n}<\/p>\n

}<\/p>\n

if ([DateTime]::Today.AddDays(-1).DayOfWeek -eq "Sunday") {<\/p>\n

}<\/p>\n

if ([DateTime]::Today.AddDays(-1).DayOfWeek -ne "Saturday" -or "Sunday"){
\n$vbrsessions = Get-VBRBackupSession | Where-Object {$_.JobType -eq "Backup" -or $_.JobType -eq "Replica" -and $_.EndTime -ge [DateTime]::Today.AddDays(-1).AddHours(17) -and $_.EndTime -lt [DateTime]::Today.AddHours(15) -and $_ -notin $excludevms.VM.Name}<\/p>\n

foreach ($session in $vbrsessions) {
\nforeach ($vm in ($session.gettasksessions() | ForEach-Object { $_ | Select-object @{Name="VMname";Expression={$_.Name}}})) {<\/p>\n

$VMObj = $Result | where {$_.VMName -eq $vm.VMname }
\nif ($VMObj){
\n$VMObj.backed_up = $True<\/p>\n

}<\/p>\n

}
\n}
\n}
\nif ([DateTime]::Today.AddDays(-2).DayOfWeek -eq "Saturday") {<\/p>\n

$vbrsessions = Get-VBRBackupSession | Where-Object {$_.JobType -eq "Backup" -or $_.JobType -eq "Replica" -and $_.EndTime -ge [DateTime]::Today.AddDays(-2).AddHours(05) -and $_.EndTime -lt [DateTime]::Today.AddDays(-1).AddHours(23) -and $_ -notin $excludevms.VM.Name}<\/p>\n

foreach ($session in $vbrsessions) {
\nforeach ($vm in ($session.gettasksessions() | ForEach-Object { $_ | Select-object @{Name="VMname";Expression={$_.Name}}})) {<\/p>\n

$VMObj = $Result | where {$_.VMName -eq $vm.VMname }
\nif ($VMObj){
\n$VMObj.backed_up2 = $True<\/p>\n

}<\/p>\n

}
\n}<\/p>\n

}<\/p>\n

# Find all successfully backed up VMs in selected sessions (i.e. VMs not ending in failure) and update status to "Protected"<\/p>\n

if ([DateTime]::Today.AddDays(-2).DayOfWeek -eq "Friday") {<\/p>\n

$vbrsessions = Get-VBRBackupSession | Where-Object {$_.JobType -eq "Backup" -or $_.JobType -eq "Replica" -and $_.EndTime -ge [DateTime]::Today.AddDays(-2).AddHours(17) -and $_.EndTime -lt [DateTime]::Today.AddDays(-1).AddHours(04) -and $_ -notin $excludevms.VM.Name}<\/p>\n

foreach ($session in $vbrsessions) {
\nforeach ($vm in ($session.gettasksessions() | ForEach-Object { $_ | Select-object @{Name="VMname";Expression={$_.Name}}})) {<\/p>\n

$VMObj = $Result | where {$_.VMName -eq $vm.VMname }
\nif ($VMObj){
\n$VMObj.backed_up2 = $True<\/p>\n

}<\/p>\n

}
\n}<\/p>\n

}<\/p>\n

if ([DateTime]::Today.AddDays(-2).DayOfWeek -eq "Sunday") {<\/p>\n

}<\/p>\n

if ([DateTime]::Today.AddDays(-2).DayOfWeek -ne "Saturday" -or "Sunday"){
\n$vbrsessions = Get-VBRBackupSession | Where-Object {$_.JobType -eq "Backup" -or $_.JobType -eq "Replica" -and $_.EndTime -ge [DateTime]::Today.AddDays(-2).AddHours(17) -and $_.EndTime -lt [DateTime]::Today.AddDays(-1).AddHours(15)-and $_ -notin $excludevms.VM.Name}<\/p>\n

foreach ($session in $vbrsessions) {
\nforeach ($vm in ($session.gettasksessions() | ForEach-Object { $_ | Select-object @{Name="VMname";Expression={$_.Name}}})) {<\/p>\n

$VMObj = $Result | where {$_.VMName -eq $vm.VMname }
\nif ($VMObj){
\n$VMObj.backed_up2 = $True<\/p>\n

}<\/p>\n

}<\/p>\n

}<\/p>\n

}<\/p>\n

$vbrsessions = ""
\nif ([DateTime]::Today.AddDays(-3).DayOfWeek -eq "Saturday") {<\/p>\n

$vbrsessions = Get-VBRBackupSession | Where-Object {$_.JobType -eq "Backup" -or $_.JobType -eq "Replica" -and $_.EndTime -ge [DateTime]::Today.AddDays(-3).AddHours(05) -and $_.EndTime -lt [DateTime]::Today.AddDays(-2).AddHours(23) -and $_ -notin $excludevms.VM.Name}<\/p>\n

foreach ($session in $vbrsessions) {
\nforeach ($vm in ($session.gettasksessions() | ForEach-Object { $_ | Select-object @{Name="VMname";Expression={$_.Name}}})) {<\/p>\n

$VMObj = $Result | where {$_.VMName -eq $vm.VMname }
\nif ($VMObj){
\n$VMObj.backed_up3 = $True<\/p>\n

}<\/p>\n

}
\n}<\/p>\n

}<\/p>\n

if ([DateTime]::Today.AddDays(-3).DayOfWeek -eq "Friday") {<\/p>\n

$vbrsessions = Get-VBRBackupSession | Where-Object {$_.JobType -eq "Backup" -or $_.JobType -eq "Replica" -and $_.EndTime -ge [DateTime]::Today.AddDays(-3).AddHours(17) -and $_.EndTime -lt [DateTime]::Today.AddDays(-2).AddHours(04) -and $_ -notin $excludevms.VM.Name}<\/p>\n

foreach ($session in $vbrsessions) {
\nforeach ($vm in ($session.gettasksessions() | ForEach-Object { $_ | Select-object @{Name="VMname";Expression={$_.Name}}})) {<\/p>\n

$VMObj = $Result | where {$_.VMName -eq $vm.VMname }
\nif ($VMObj){
\n$VMObj.backed_up3 = $True<\/p>\n

}<\/p>\n

}
\n}<\/p>\n

}
\nif ([DateTime]::Today.AddDays(-3).DayOfWeek -eq "Sunday") {<\/p>\n

}<\/p>\n

if ([DateTime]::Today.AddDays(-3).DayOfWeek -ne "Saturday" -or "Sunday"){
\n$vbrsessions = Get-VBRBackupSession | Where-Object {$_.JobType -eq "Backup" -or $_.JobType -eq "Replica" -and $_.EndTime -ge [DateTime]::Today.AddDays(-3).AddHours(17) -and $_.EndTime -lt [DateTime]::Today.AddDays(-2).AddHours(15)-and $_ -notin $excludevms.VM.Name}<\/p>\n

foreach ($session in $vbrsessions) {
\nforeach ($vm in ($session.gettasksessions() | ForEach-Object { $_ | Select-object @{Name="VMname";Expression={$_.Name}}})) {<\/p>\n

$VMObj = $Result | where {$_.VMName -eq $vm.VMname }
\nif ($VMObj){
\n$VMObj.backed_up3 = $True<\/p>\n

}<\/p>\n

}
\n}
\n}<\/p>\n

$vbrsessions = ""<\/p>\n

if ([DateTime]::Today.AddDays(-4).DayOfWeek -eq "Saturday") {<\/p>\n

$vbrsessions = Get-VBRBackupSession | Where-Object {$_.JobType -eq "Backup" -or $_.JobType -eq "Replica" -and $_.EndTime -ge [DateTime]::Today.AddDays(-4).AddHours(05) -and $_.EndTime -lt [DateTime]::Today.AddDays(-3).AddHours(23) -and $_ -notin $excludevms.VM.Name}<\/p>\n

foreach ($session in $vbrsessions) {
\nforeach ($vm in ($session.gettasksessions() | ForEach-Object { $_ | Select-object @{Name="VMname";Expression={$_.Name}}})) {<\/p>\n

$VMObj = $Result | where {$_.VMName -eq $vm.VMname }
\nif ($VMObj){
\n$VMObj.backed_up4 = $True<\/p>\n

}<\/p>\n

}
\n}<\/p>\n

}<\/p>\n

if ([DateTime]::Today.AddDays(-4).DayOfWeek -eq "Friday") {<\/p>\n

$vbrsessions = Get-VBRBackupSession | Where-Object {$_.JobType -eq "Backup" -or $_.JobType -eq "Replica" -and $_.EndTime -ge [DateTime]::Today.AddDays(-4).AddHours(17) -and $_.EndTime -lt [DateTime]::Today.AddDays(-3).AddHours(04) -and $_ -notin $excludevms.VM.Name}<\/p>\n

foreach ($session in $vbrsessions) {
\nforeach ($vm in ($session.gettasksessions() | ForEach-Object { $_ | Select-object @{Name="VMname";Expression={$_.Name}}})) {<\/p>\n

$VMObj = $Result | where {$_.VMName -eq $vm.VMname }
\nif ($VMObj){
\n$VMObj.backed_up4 = $True<\/p>\n

}<\/p>\n

}
\n}<\/p>\n

}
\nif ([DateTime]::Today.AddDays(-4).DayOfWeek -eq "Sunday") {<\/p>\n

}<\/p>\n

if ([DateTime]::Today.AddDays(-4).DayOfWeek -ne "Saturday" -or "Sunday"){
\n$vbrsessions = Get-VBRBackupSession | Where-Object {$_.JobType -eq "Backup" -or $_.JobType -eq "Replica" -and $_.EndTime -ge [DateTime]::Today.AddDays(-4).AddHours(17) -and $_.EndTime -lt [DateTime]::Today.AddDays(-3).AddHours(15)-and $_ -notin $excludevms.VM.Name}<\/p>\n

foreach ($session in $vbrsessions) {
\nforeach ($vm in ($session.gettasksessions() | ForEach-Object { $_ | Select-object @{Name="VMname";Expression={$_.Name}}})) {<\/p>\n

$VMObj = $Result | where {$_.VMName -eq $vm.VMname }
\nif ($VMObj){
\n$VMObj.backed_up4 = $True<\/p>\n

}<\/p>\n

}
\n}
\n}<\/p>\n

$Comments = ‘Comments’<\/p>\n

if ([DateTime]::Today.AddDays(-1).DayOfWeek -eq "Sunday"){
\n$1days = [DateTime]::Today.AddDays(-1).ToString(‘ddd d MMM yyy’)
\n$2days = ‘Weekend of ‘ + [DateTime]::Today.AddDays(-2).ToString(‘d MMM yyy’)
\n$3days = [DateTime]::Today.AddDays(-3).ToString(‘ddd d MMM yyy’)
\n$4days = [DateTime]::Today.AddDays(-4).ToString(‘ddd d MMM yyy’)
\n$TableName = "Backups"
\n$table = New-Object system.Data.DataTable "$TableName"
\n$col2 = New-Object system.Data.DataColumn VM, ([string])
\n$col8 = New-Object system.Data.DataColumn $4days, ([string])
\n$col9 = New-Object system.Data.DataColumn $3days, ([string])
\n$col10 = New-Object system.Data.DataColumn $2days, ([string])
\n$col12 = New-Object system.Data.DataColumn Comments, ([string])<\/p>\n

$table.columns.add($col2)
\n$table.columns.add($col8)
\n$table.columns.add($col9)
\n$table.columns.add($col10)
\n$table.columns.add($col12)
\nforeach ($vm in $Result) {<\/p>\n

$row = $table.NewRow();$row.VM=$vm.VMname;$row.$4days=$vm.backed_up4;$row.$3days=$vm.backed_up3;$row.$2days=$vm.backed_up2;$table.Rows.Add($row)#;$table.Rows.Add($row)<\/p>\n

}<\/p>\n

$datetoday=get-date -format D
\n$reportdate=get-date -format "yyyy-MMM-d"
\n$ResultsText = "The following machines in Woking have been successfully backed up using Veeam in the past " + $AgeAlert + " Day(s)"
\n$ResultsAlert = "Good"<\/p>\n

############################################################################################################
\n# Output #
\n#————————<\/p>\n

$OutText = $ResultsText
\n$OutData = $Table | Select-Object VM,$4days,$3days,$2days,$Comments | Sort-Object VM
\n$OutAlert = $ResultsAlert
\n$Attachment = ""
\n}<\/p>\n

if ([DateTime]::Today.AddDays(-2).DayOfWeek -eq "Sunday"){
\n$1days = [DateTime]::Today.AddDays(-1).ToString(‘ddd d MMM yyy’)
\n$2days = [DateTime]::Today.AddDays(-2).ToString(‘ddd d MMM yyy’)
\n$3days = ‘Weekend of ‘ + [DateTime]::Today.AddDays(-3).ToString(‘d MMM yyy’)
\n$4days = [DateTime]::Today.AddDays(-4).ToString(‘ddd d MMM yyy’)
\n$TableName = "Backups"
\n$table = New-Object system.Data.DataTable "$TableName"
\n$col2 = New-Object system.Data.DataColumn VM, ([string])
\n$col8 = New-Object system.Data.DataColumn $4days, ([string])
\n$col9 = New-Object system.Data.DataColumn $3days, ([string])
\n$col11 = New-Object system.Data.DataColumn $1days, ([string])
\n$col12 = New-Object system.Data.DataColumn Comments, ([string])<\/p>\n

$table.columns.add($col2)
\n$table.columns.add($col8)
\n$table.columns.add($col9)
\n$table.columns.add($col11)
\n$table.columns.add($col12)<\/p>\n

foreach ($vm in $Result) {
\n$row = $table.NewRow();$row.VM=$vm.VMname;$row.$4days=$vm.backed_up4;$row.$3days=$vm.backed_up3;$row.$1days=$vm.backed_up;$table.Rows.Add($row)#;$table.Rows.Add($row)<\/p>\n

}<\/p>\n

$datetoday=get-date -format D
\n$reportdate=get-date -format "yyyy-MMM-d"
\n$ResultsText = "The following machines in Woking have been successfully backed up using Veeam in the past " + $AgeAlert + " Day(s)"
\n$ResultsAlert = "Good"
\n############################################################################################################
\n# Output #
\n#————————<\/p>\n

$OutText = $ResultsText
\n$OutData = $Table | Select-Object VM,$4days,$3days,$1days,$Comments | Sort-Object VM
\n$OutAlert = $ResultsAlert
\n$Attachment = ""
\n}<\/p>\n

if ([DateTime]::Today.AddDays(-3).DayOfWeek -eq "Sunday"){
\n$1days = [DateTime]::Today.AddDays(-1).ToString(‘ddd d MMM yyy’)
\n$2days = [DateTime]::Today.AddDays(-2).ToString(‘ddd d MMM yyy’)
\n$3days = [DateTime]::Today.AddDays(-3).ToString(‘ddd d MMM yyy’)
\n$4days = ‘Weekend of ‘ + [DateTime]::Today.AddDays(-4).ToString(‘d MMM yyy’)
\n$TableName = "Backups"
\n$table = New-Object system.Data.DataTable "$TableName"
\n$col2 = New-Object system.Data.DataColumn VM, ([string])
\n$col8 = New-Object system.Data.DataColumn $4days, ([string])
\n$col10 = New-Object system.Data.DataColumn $2days, ([string])
\n$col11 = New-Object system.Data.DataColumn $1days, ([string])
\n$col12 = New-Object system.Data.DataColumn Comments, ([string])<\/p>\n

$table.columns.add($col2)
\n$table.columns.add($col8)
\n$table.columns.add($col10)
\n$table.columns.add($col11)
\n$table.columns.add($col12)<\/p>\n

foreach ($vm in $Result) {
\n$row = $table.NewRow();$row.VM=$vm.VMname;$row.$4days=$vm.backed_up4;$row.$2days=$vm.backed_up2;$row.$1days=$vm.backed_up;$table.Rows.Add($row)#;$table.Rows.Add($row)<\/p>\n

}
\n$datetoday=get-date -format D
\n$reportdate=get-date -format "yyyy-MMM-d"
\n$ResultsText = "The following machines in Woking have been successfully backed up using Veeam in the past " + $AgeAlert + " Day(s)"
\n$ResultsAlert = "Good"<\/p>\n

############################################################################################################
\n# Output #
\n#————————<\/p>\n

$OutText = $ResultsText
\n$OutData = $Table | Select-Object VM,$4days,$2days,$1days,$Comments | Sort-Object VM
\n$OutAlert = $ResultsAlert
\n$Attachment = ""
\n}<\/p>\n

if ([DateTime]::Today.AddDays(-4).DayOfWeek -eq "Sunday"){
\n$1days = [DateTime]::Today.AddDays(-1).ToString(‘ddd d MMM yyy’)
\n$2days = [DateTime]::Today.AddDays(-2).ToString(‘ddd d MMM yyy’)
\n$3days = [DateTime]::Today.AddDays(-3).ToString(‘ddd d MMM yyy’)
\n$4days = [DateTime]::Today.AddDays(-4).ToString(‘ddd d MMM yyy’)<\/p>\n

$TableName = "Backups"
\n$table = New-Object system.Data.DataTable "$TableName"
\n$col2 = New-Object system.Data.DataColumn VM, ([string])
\n$col9 = New-Object system.Data.DataColumn $3days, ([string])
\n$col10 = New-Object system.Data.DataColumn $2days, ([string])
\n$col11 = New-Object system.Data.DataColumn $1days, ([string])
\n$col12 = New-Object system.Data.DataColumn Comments, ([string])<\/p>\n

$table.columns.add($col2)
\n$table.columns.add($col9)
\n$table.columns.add($col10)
\n$table.columns.add($col11)
\n$table.columns.add($col12)<\/p>\n

foreach ($vm in $Result) {
\n$row = $table.NewRow();$row.VM=$vm.VMname;$row.$3days=$vm.backed_up3;$row.$2days=$vm.backed_up2;$row.$1days=$vm.backed_up;$table.Rows.Add($row)#;$table.Rows.Add($row)<\/p>\n

}
\n$datetoday=get-date -format D
\n$reportdate=get-date -format "yyyy-MMM-d"
\n$ResultsText = "The following machines in Woking have been successfully backed up using Veeam in the past " + $AgeAlert + " Day(s)"
\n$ResultsAlert = "Good"
\n############################################################################################################
\n# Output #
\n#————————<\/p>\n

$OutText = $ResultsText
\n$OutData = $Table | Select-Object VM,$3days,$2days,$1days,$Comments | Sort-Object VM
\n$OutAlert = $ResultsAlert
\n$Attachment = ""
\n}
\n[\/powershell]<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Just to confirm that I am, by no means, a Powercli (PowerShell) expert and would still class myself as a novice. \u00a0With this in mind there are probably tips and better ways to perform some of the items involved in my scripts… but the items that I have done seem to work for me and may help someone else in […]<\/p>\n","protected":false},"author":1,"featured_media":691,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[9],"tags":[],"class_list":["post-690","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-vmware"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/posts\/690","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/comments?post=690"}],"version-history":[{"count":0,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/posts\/690\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/media?parent=690"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/categories?post=690"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/tags?post=690"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}