Detail Failure Report

PowerShell script exchange

Detail Failure Report

Veeam Logoby jkcouch » Fri Aug 12, 2011 4:32 pm

We are backing up around 1000 VMs with Veeam. We just got them all added in and we are trying to sift through and determine why specific VMs within jobs are failing. Has anyone created a script to pull a detailed failure report so i don’t spend hours tracking them down? Enterprise manager is great, but it just doesn’t have good filtering options to get the information you want quickly. I was thinking PowerShell was the way to go, but cannot find what cmdlet houses the information about job history.

I hope in future revisions there is a way to look at backup nodes and jobs in enterprise manager without seeing all the retries as individual sessions. For instance, when you look at the reports tab, you see Backup server name/status/job count/VM count/Source Data Size. The VM count and source data size are not accurate since its only reporting on the last job run, which in our case is the retry job. So when 20 machines are successful and 1 VM is failed it’s not correct. The same thing goes for the Jobs tab. Yes, now you see the jobs listed out, but you don’t get any good information in the columns. Here is where we should have the option of exporting an excel sheet with all the detail error information for successes and failures for ALL jobs on ALL backup nodes. We have 13 virtual nodes each with 4 jobs so going server by server and gathering this information daily is very tedious.

Any help would be awesome as we are adding another 500 VMs to Veeam this next week.

Thanks,
Jeff
jkcouch
Enthusiast
 
Posts: 30
Liked: never
Joined: Sun Jun 26, 2011 7:02 pm
Full Name: Jeff Couch

Re: Detail Failure Report

Veeam Logoby Sethbartlett » Fri Aug 12, 2011 6:17 pm

Please check out the following forum article:
Retreive VM failure or warning info via Powershell

This shows how to get warning/error messages for the jobs. In powershell, you can do Get-VBRCommand to get a list of our cmdlets. If you need further help, please detail what kind of filtering you need.
Skype: Sethbartlett88 - Make sure to label who you are and why you want to add me ;)
Twitter: @sethbartlett
If my post was helpful, please like it. Sometimes twitter is quicker to hit me up if you need me.
Sethbartlett
Expert
 
Posts: 282
Liked: 25 times
Joined: Wed Nov 10, 2010 6:51 pm
Full Name: Seth Bartlett

Re: Detail Failure Report

Veeam Logoby jkcouch » Sat Aug 13, 2011 1:44 am

Great Seth! I have been using the powershell module from veeam for a few months, but didnt know where exactly you stored this information. This looks like it is a popular request. I hope this feature in future revisions in a more supported manor.

Here is what I put together based on your previous post in case someone else needs this. I just created a secheduled task so it will run daily. Thanks again for the assistance!

Code: Select all
Add-PSSnapin veeampssnapin

$Date = Get-Date
$Filename = "\\Serverxxx\sharexxx\Veeam\reporting\FailedBackups" + "_" + "$env:computername" + "_" + $Date.Month + "-" + $Date.Day + "-" + $Date.Year + ".csv"

$Sessions = Get-VBRBackupSession

$report = @()
foreach ($session in $sessions){
   $Info = [Veeam.Backup.Core.CBackupTaskSession]::GetByJobSession($session.id)
   $report += $Info
   }

$FailedBackups = $report | where {$_.status -eq "Failed"}
$FailedBackups | Export-Csv $Filename -NoTypeInformation
jkcouch
Enthusiast
 
Posts: 30
Liked: never
Joined: Sun Jun 26, 2011 7:02 pm
Full Name: Jeff Couch

Re: Detail Failure Report

Veeam Logoby Sethbartlett » Sat Aug 13, 2011 3:30 am

Very nice! I love seeing stuff like this. Really neat to see some bigger powershell scripts. I script for fun but to see uses for hundreds of VM's is awesome.
Skype: Sethbartlett88 - Make sure to label who you are and why you want to add me ;)
Twitter: @sethbartlett
If my post was helpful, please like it. Sometimes twitter is quicker to hit me up if you need me.
Sethbartlett
Expert
 
Posts: 282
Liked: 25 times
Joined: Wed Nov 10, 2010 6:51 pm
Full Name: Seth Bartlett


Return to PowerShell



Who is online

Users browsing this forum: No registered users and 6 guests