SysAdmin Modular Reporting (SAMReport) for Veeam

PowerShell script exchange

SysAdmin Modular Reporting (SAMReport) for Veeam

Veeam Logoby Gav@GH » Sun Sep 09, 2012 7:17 am 13 people like this post

I'm just a regular Veeam user and love the product. A while back I came to this forum to find some information on some enhanced Powershell reporting. Things like a list of the results from all my jobs or a summary of storage free space and so on. There was a pretty good collection of posts, but there was no single report that meet my needs. I originally started to make one, but soon realised that in this environment of sharing and collaboration, there was no real point in developing a personal report as it would probably not suit anybody else. Our environments and requirements are all completely different.

So I went away and started to develop a series of individual scripts that could be added to or customised (by anyone) and then joined together to form a single report. I also wanted a quick way to alert me to anything that wasn't normal or outside a threshold. The project grew and grew to the point where I realised it wasn't just Veeam that this could be used for, but any system that used powershell. In the end it has become known as SysAdmin Modular Reporting or SAMReports for short. I've put up a whole post on it with links to source code on my blog http://www.theagreeablecow.com/2012/09/sysadmin-modular-reporting-samreports.html

However, it all started here with Veeam! So I wanted you guys to be first to have a look. Currently there are eight child scripts for Veeam, which report on the following:

- Veeam_Get-JobStatusSummary.ps1 (Summary of the most recent session for all jobs)
- Veeam_Get-JobStatusDetails.ps1 (Details of the most recent session for all jobs)
- Veeam_Get-BackupStorageStatus.ps1 (Storage data and any alerts for Veeam Backup repositories)
- Veeam_Get-ReplicaStorageStatus.ps1 (Storage data and any alerts for Veeam Replica repositories)
- Veeam_Get-AllUnprotectedVMs.ps1 (Checks vCenter for any machines not protected)
- Veeam_Get-ServicesStatus.ps1 (Checks the current Status of Veeam Services)
- Veeam_Get-LicenseStatus.ps1 (Checks the licensing status and expiration period)
- Veeam_Gent-EventLogs.ps1 (Gathers event logs based on specified queries)

The whole project is very much open source, so I would love to get some feedback or even better some plugins! Anything submitted will be fully acknowledged and then shared for others to use.

Here is a sample of the output

Image

Cheers,

Gav
Gav@GH
Influencer
 
Posts: 21
Liked: 15 times
Joined: Fri Jul 20, 2012 12:27 am

Re: SysAdmin Modular Reporting (SAMReport) for Veeam

Veeam Logoby Gostev » Wed Sep 12, 2012 10:44 am

Incredible report. Thank you so much for sharing!
Gostev
Veeam Software
 
Posts: 21396
Liked: 2349 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: SysAdmin Modular Reporting (SAMReport) for Veeam

Veeam Logoby tsightler » Thu Sep 13, 2012 1:10 pm

These scripts are absolutely amazing. Excellent work!
tsightler
Veeam Software
 
Posts: 4769
Liked: 1737 times
Joined: Fri Jun 05, 2009 12:57 pm
Full Name: Tom Sightler

Re: SysAdmin Modular Reporting (SAMReport) for Veeam

Veeam Logoby Gav@GH » Thu Sep 13, 2012 9:09 pm

Thanks Tom,

Credit to you too for the "get-unprotectedVMs" base code. This initial problem and your script is pretty much where it all started!

I hade some anomalies in the results using just VBR calls, so ended up going back to comparing using the vcenter plugin.
Gav@GH
Influencer
 
Posts: 21
Liked: 15 times
Joined: Fri Jul 20, 2012 12:27 am

Re: SysAdmin Modular Reporting (SAMReport) for Veeam

Veeam Logoby Gav@GH » Sun Dec 02, 2012 10:53 pm 1 person likes this post

For those that have upgraded to Veeam version 6.5, you make find that it broke the Veeam powershell plugins.

The quick fix is to run "C:\Program Files\Veeam\Backup and Replication\Install-VeeamToolkit.ps1", which installs the .Net4 configuration files for powershell V2.
Gav@GH
Influencer
 
Posts: 21
Liked: 15 times
Joined: Fri Jul 20, 2012 12:27 am

Re: SysAdmin Modular Reporting (SAMReport) for Veeam

Veeam Logoby alex.nunley » Fri Jan 18, 2013 3:37 pm

I was wondering if you could provide any guidance about running these reports from a remote client.


Very useful, and due cheers!
alex.nunley
Influencer
 
Posts: 19
Liked: never
Joined: Fri Jan 18, 2013 3:36 pm
Full Name: Alex Nunley

Re: SysAdmin Modular Reporting (SAMReport) for Veeam

Veeam Logoby Vitaliy S. » Sun Jan 20, 2013 12:42 pm

I'm not a PowerShell expert, but can't you run this report via PowerShell remoting?
Vitaliy S.
Veeam Software
 
Posts: 19564
Liked: 1104 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: SysAdmin Modular Reporting (SAMReport) for Veeam

Veeam Logoby organic.dog » Thu Feb 21, 2013 12:18 pm

Hello, this is a very useful script - thanks.

I was wondering if there was any way to make Veeam_Get-JobStatusSummary to run across multiple veeam servers, i.e. to use $serverarray from the global variables? This would allow me to have a single email report for the multiple Veeam instances.
I'm not sure if it's already there and I am missing something ...


Once again, thanks for the hard work & the script!
organic.dog
Novice
 
Posts: 5
Liked: never
Joined: Thu Feb 21, 2013 12:13 pm
Full Name: martin campbell

Re: SysAdmin Modular Reporting (SAMReport) for Veeam

Veeam Logoby organic.dog » Fri Feb 22, 2013 2:55 pm

To expand, what I am looking to do is to make the section that denotes VMs currently not protected by Veeam more useful when there are multiple instances.
As with multiple Veeam instances (one per datacenter for us) that means that Veeam Server A sees all VMs it doesn't backup and triggers alerts, however Veeam Server B may well back them up. So attempting to merge the multiple servers into a holistic view appears to be complex..

Enterprise Manager has this holistic view, but i don't know if we can run powershell against Enterprise Manager - anyone?
organic.dog
Novice
 
Posts: 5
Liked: never
Joined: Thu Feb 21, 2013 12:13 pm
Full Name: martin campbell

Re: SysAdmin Modular Reporting (SAMReport) for Veeam

Veeam Logoby v.Eremin » Fri Feb 22, 2013 3:14 pm

Enterprise Manager has this holistic view, but i don't know if we can run powershell against Enterprise Manager - anyone?

As far as I’m concerned, nothing like this can be done by you. Seems like some modifications to existing script are required in order to meet your expectations.

Hope this helps.
Thanks.
v.Eremin
Veeam Software
 
Posts: 13281
Liked: 970 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: SysAdmin Modular Reporting (SAMReport) for Veeam

Veeam Logoby organic.dog » Fri Feb 22, 2013 3:39 pm

I feared that :(

I'm afraid my powershell skills fall far short of the authors, so I think adapting the script will be beyond me...
organic.dog
Novice
 
Posts: 5
Liked: never
Joined: Thu Feb 21, 2013 12:13 pm
Full Name: martin campbell

Re: SysAdmin Modular Reporting (SAMReport) for Veeam

Veeam Logoby tsightler » Fri Feb 22, 2013 3:40 pm

The biggest challenge is, to run reports from multiple Veeam servers would require Powershell remoting to gather the information from the various Veeam servers. This shouldn't be too difficult to adapt to the current scripts, I've just never taken the time.

You might consider using one of the other scripts that report on unprotected VMs based on parsing the attributes (assumes Veeam is configured to update either the "notes" attribute or some custom attribute of the VM on job completion). This allows for reporting based only on VM state and doesn't require any access to the Veeam servers at all.
tsightler
Veeam Software
 
Posts: 4769
Liked: 1737 times
Joined: Fri Jun 05, 2009 12:57 pm
Full Name: Tom Sightler

Re: SysAdmin Modular Reporting (SAMReport) for Veeam

Veeam Logoby organic.dog » Fri Feb 22, 2013 3:53 pm

an interesting idea, I had originally looked at doing something like that with the "notes" field but bumped into the issue that some VMs, but not others, in our deployment use the notes field for other relevant information. I got the impression from Veeam that it would obliterate the existing "notes". I hadn't considered using a custom field..

ta
organic.dog
Novice
 
Posts: 5
Liked: never
Joined: Thu Feb 21, 2013 12:13 pm
Full Name: martin campbell

Re: SysAdmin Modular Reporting (SAMReport) for Veeam

Veeam Logoby tsightler » Fri Feb 22, 2013 4:18 pm

Yep, you can create a custom attribute, many customers use "Backup Status" or something similar. Then you can report on this field. I wrote my report not to depend on this field because some customers simply didn't want to use a custom attribute, and because I visit a lot of clients and wanted to be able to run the report right away, without requiring any changes to the environment, but if updating a custom attribute is option for you then this may be easier since you have multiple Veeam servers.

The script itself wouldn't have to do anything but pull in all of the VMs, grab the custom attribute and parse out of it's either missing, or hasn't been recently updated. I think there might be an example of a script that does this somewhere on the forum already.
tsightler
Veeam Software
 
Posts: 4769
Liked: 1737 times
Joined: Fri Jun 05, 2009 12:57 pm
Full Name: Tom Sightler

Re: SysAdmin Modular Reporting (SAMReport) for Veeam

Veeam Logoby organic.dog » Fri Feb 22, 2013 4:28 pm

thanks! I have been looking into setting the custom attribute already, looks like it will do the trick.

A quick look around the forum seems to turn up a script by your kind self doing something similar :)
I guess most of this is now demoted to the back of the queue behind Veeam One. Maybe I should be asking for pricing on that..
organic.dog
Novice
 
Posts: 5
Liked: never
Joined: Thu Feb 21, 2013 12:13 pm
Full Name: martin campbell

Next

Return to PowerShell



Who is online

Users browsing this forum: No registered users and 3 guests