Report - available restore points for last 30 days

Management reporting and documentation

Report - available restore points for last 30 days

Veeam Logoby EmpTee » Thu Feb 18, 2016 12:17 am

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?
EmpTee
Novice
 
Posts: 7
Liked: never
Joined: Thu Feb 04, 2016 2:14 am

Re: Report - available restore points for last 30 days

Veeam Logoby Vitaliy S. » Thu Feb 18, 2016 9:48 am

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.
Vitaliy S.
Veeam Software
 
Posts: 19573
Liked: 1104 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Report - available restore points for last 30 days

Veeam Logoby EmpTee » Thu Feb 18, 2016 11:13 pm

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
EmpTee
Novice
 
Posts: 7
Liked: never
Joined: Thu Feb 04, 2016 2:14 am

Re: Report - available restore points for last 30 days

Veeam Logoby Vitaliy S. » Fri Feb 19, 2016 10:12 am

No, it's not. There is another report you can take a look at > VM Backup Status
Vitaliy S.
Veeam Software
 
Posts: 19573
Liked: 1104 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Report - available restore points for last 30 days

Veeam Logoby ccatlett1984 » Tue Apr 05, 2016 9:11 pm

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
ccatlett1984
Enthusiast
 
Posts: 83
Liked: 9 times
Joined: Thu Oct 31, 2013 5:11 pm
Full Name: Chris Catlett

Re: Report - available restore points for last 30 days

Veeam Logoby Vitaliy S. » Wed Apr 06, 2016 11:18 am

Thanks for sharing, Chris!
Vitaliy S.
Veeam Software
 
Posts: 19573
Liked: 1104 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov


Return to Reporting



Who is online

Users browsing this forum: No registered users and 4 guests