Report - available restore points for last 30 days

[EmpTee]

Hi,

I'm trying to to see a report showing for each VM available restore points by date from the last 30 days.

This report is to verify that I have at least one restore point per VM per day available for the past 30 days. I can report on successes and failures, but if the job didn't run (job disabled, b&r server shutdown, etc) it's not reported.

The closest I can get to seeing the information is with powershell, but this is not in an easy format to reconcile, and has to be run per job/per vm.

Code: Select all

Get-VBRBackup -Name "BackupJobName" | Get-VBRRestorePoint -name VMNAME | Sort-Object $_.creationtime -Descending | select -first 30 | FL Creationtime,Name

Any ideas?

[Vitaliy S.]

It seems like Protected VMs report is exactly what you're looking for, though I'm not sure how to build it via PowerShell. Maybe it is worth asking in PowerShell sub-forums in B&R forum.

[EmpTee]

Hi Vitaly,

I ran the Protected VM's report and it doesn't show me restore points per day which is what I need. I get total number of restore points, oldest backup and last backup.

If PowerShell is the only way I'll look into that further.

Thanks

[Vitaliy S.]

No, it's not. There is another report you can take a look at > VM Backup Status

[ccatlett1984]

The following shows only Tape Backups.

Just remove that filter from the where-object if you want to see them all.

Code: Select all

asnp "VeeamPSSnapIn"

remove-item "C:\veeam_restore_points_on_tape.csv" -force
$veeam_vms = Find-VBRViEntity | Where-Object {$_.id -like "*_vm*"} | sort name
$backupcheckdate = (get-date).AddDays(-31)
$colrestorepoints= @()
foreach($vm in $veeam_vms)
{
$veeamrestorepoints = $null
$vmname = $vm.name
#write-host "Checking $vmname"
write-host "working on $vmname"
$veeamrestorepoints = Get-VBRRestorePoint -Name $vmname | Where-Object {($_.GetBackup().JobType -eq "VmTapeBackup") -AND ($_.creationtime -ge $backupcheckdate)} | Sort-Object $_.creationtime -Descending
$colrestorepoints += $veeamrestorepoints
}

$colrestorepoints | export-csv "c:\veeam_restore_points_on_tape.csv" -NoTypeInformation

[Vitaliy S.]

Thanks for sharing, Chris!