Management reporting and documentation
Post Reply
EmpTee
Novice
Posts: 9
Liked: never
Joined: Feb 04, 2016 2:14 am
Contact:

Report - available restore points for last 30 days

Post by 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.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Report - available restore points for last 30 days

Post by 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
Novice
Posts: 9
Liked: never
Joined: Feb 04, 2016 2:14 am
Contact:

Re: Report - available restore points for last 30 days

Post by 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.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Report - available restore points for last 30 days

Post by Vitaliy S. »

No, it's not. There is another report you can take a look at > VM Backup Status
ccatlett1984
Enthusiast
Posts: 83
Liked: 9 times
Joined: Oct 31, 2013 5:11 pm
Full Name: Chris Catlett
Contact:

Re: Report - available restore points for last 30 days

Post by 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.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Report - available restore points for last 30 days

Post by Vitaliy S. »

Thanks for sharing, Chris!
Post Reply

Who is online

Users browsing this forum: No registered users and 8 guests