Veeam Reporting tool v1.0 released !

[ThierryF]

Hello Friends,

I just released V1.0 of my veeam free reporting tool.

You can download it and use it for free. You can download it from
https://onedrive.live.com/?id=14190B6B5 ... 6B5B8ECCD5

Extract the bin in a folder on the veeam server or on a node where veeam console
is installed.

Look at included readme.txt for how to setup.

1.0 Rev. 2018-06-24 :
---------------------
Note : Initial Release mainly focussing on VmWare-based backups
Far more to come, feel free to post comments to thierry.faidherbe@skynet.be

- Backup Repository Details, including scaled-out repositories.
- Infrastructure Managed Hosts including Datastore Usage Details
- Licensing and Support Renewal Date overview
- Virtual Machine and Operating System Inventory Overview.
- Backup job Details :
- Settings,
- Proxy Selection
- Client Membership and Disk backup selection
- Synthetic Full Weekly Planning Overview
- Scheduled Backup Session Logging, Overview and Statistics
- Scheduled Tape Session Logging, Overview and Statistics
- Scheduled VeeamZip Session Logging, Overview and Statistics
- Restore Session Details
- Tape, Media-Set & Media Changer Inventory and Details
- Detailed Recover Points Inventory

- Added Fast access to Technical Docs (PDF Files) in Tree Structure.
Store yours PDF Documentation for fast access in data\<config>\technical_specs.
- Added Wiki-like repository : Store your documentaion or special backup handling procedures under
data\<config>\hosts\<GROUP-BY>_Veeam_<SERVER>\wiki to have them available all the time at mouse-click.
- ICMP Ping will be used to verify probed nodes reachability.
Create a flag file no_icmp_ping in bin folder to skip ICMP Ping Test
- Known Restore points will be collected for statistics purposes. For big environments,
you may have to create a flag file no_restorepoint in bin folder to skip Restore points collection.
- Job session logs will be collected during probe. For big environments or if not needed,
you may have to create a flag file no_job_logs in bin folder to skip Job session logs collection.
- VeeamZip backups will be collected during probe. For big environments or if not needed,
you may have to create a flag file no_veeamzip in bin folder to skip VeeamZip backups collection.
- Disabled by default, remaining Restore Points sorted by date can be added to reporting.
Create a flag file show_restorepoint_by_date in bin folder to enable it.
- Activitity Ganttcharts(*) including Jobset and Jobset Member, Backup Repository, Recover, VeeamZip, Tape Job...
(*) Depending of the enabled/disabled collected data

PS : Above link also contains reporting tools for MsWindows, Lan Manager, HyperV, Vmware,
IBM Storwize and SAN Brocade-based switches. Feel free !

Comments are welcome !

Th

[ThierryF]

Any feedback or question is welcome !

Th

[Jack1874]

Hello, I get the following error ...

Cannot create 'last_.\cs.log',No such file or directory at D:\code\Analytics\v1.0_20180713\bin\veeam_reporting.exe line 1318.

[ThierryF]

You should have an issue with your config file. Send it to me to thierry.faidherbe@skynet.be
Be also sure you cmd is like
"veeam_reporting.exe sample.cfg" and not like "veeam_reporting.exe .\sample.cfg"

Cheers

TH

[PTide]

Nice reporting tool you got there! If you'd like to see some of the features of that report to be added in Veeam (VeeamONE, MP), I think it's worth posting it accompanied with a feature request on the corresponding sub-forums too.

Thanks!

[albertwt]

thanks for sharing it here Mr. Thierry,

[krayzie1239]

Im able to use this reporting tool however i still failed to see the VEEAM Backup Status eventhough i have extracted and use this inside the VEEAM backup Server.

Can you help?

Below are my logs. It still did not gather VEEAM backup details except for the server hardware info

Code: Select all

                                  __/^\__
                                   (. .)
 ==============================oOOO-(_)-OOOo=================================
 
               WELCOME TO Veeam Backup and Replication Analytics           
 
                             Version 1.1 Rev. 2018-10-07
 
                       Copyright (C) 2012-2016 thierry.faidherbe@skynet.be
 
 ============================================================================
Mon Mar 11 10:59:51 2019 Checking for required external binaries ...
Mon Mar 11 10:59:51 2019          ... Info : Using psexec binary under ..\bin\ms_windows\
Mon Mar 11 10:59:51 2019 Gathiering Config file 'sam.cfg' ...
Mon Mar 11 10:59:51 2019	Info : Missing IP Addr for VEEAM Group-by 'Application' Node 'RMAAS-V01-VEEAM'. Using IP Addr from DNS '192.168.1.71' ...
Mon Mar 11 10:59:51 2019	Registering VEEAM Group-by 'Application' Node 'RMAAS-V01-VEEAM' with IP Addr '192.168.1.71' to 'sam' ...
Mon Mar 11 10:59:51 2019 Gathering previously generated reports for 'sam' ...
Mon Mar 11 10:59:51 2019 Gathering SAN Aliases file '..\data\sam\import\sanalias.txt' ...
Mon Mar 11 10:59:51 2019 Gathering Veeam Version file 'version.log' ...
Mon Mar 11 10:59:51 2019 Gathering Network VLAN IDs file '..\data\sam\import\vlanid.txt' ...

Mon Mar 11 10:59:51 2019 Querying Group 'Application' Host RMAAS-V01-VEEAM - IP Addr 192.168.1.71 ...
Mon Mar 11 10:59:51 2019	... Node RMAAS-V01-VEEAM from farm 'Application' is a valid hostname and reachable ...
Mon Mar 11 10:59:51 2019	... Gathering Services running on VEEAM Node 'RMAAS-V01-VEEAM' ...
Mon Mar 11 10:59:51 2019		... Querying VEEAM Node 'RMAAS-V01-VEEAM' WMI Class WIN32_BIOS ...
Mon Mar 11 10:59:51 2019                         Info : WMI Query returned 1 value(s) ...
Mon Mar 11 10:59:51 2019			... Gathered VEEAM Node 'RMAAS-V01-VEEAM' BIOS '090006 ' ...
Mon Mar 11 10:59:51 2019		... Querying VEEAM Node 'RMAAS-V01-VEEAM' WMI Class WIN32_COMPUTERSYSTEMPRODUCT ...
Mon Mar 11 10:59:51 2019                         Info : WMI Query returned 1 value(s) ...
Mon Mar 11 10:59:51 2019		... Querying VEEAM Node 'RMAAS-V01-VEEAM' WMI Class MSVM_DISKDRIVE ...
Mon Mar 11 10:59:51 2019                         Warning : WMI Query Failed ...
Mon Mar 11 10:59:51 2019		... Querying VEEAM Node 'RMAAS-V01-VEEAM' WMI Class WIN32_PHYSICALMEMORY ...
Mon Mar 11 10:59:52 2019                         Info : WMI Query returned 2 value(s) ...
Mon Mar 11 10:59:52 2019			... Gathered VEEAM Node 'RMAAS-V01-VEEAM' System Memory Simm '3.87' GB...
Mon Mar 11 10:59:52 2019			... Gathered VEEAM Node 'RMAAS-V01-VEEAM' System Memory Simm '8.03' GB...
Mon Mar 11 10:59:52 2019		... Querying VEEAM Node 'RMAAS-V01-VEEAM' WMI Class WIN32_COMPUTERSYSTEM ...
Mon Mar 11 10:59:52 2019                         Info : WMI Query returned 1 value(s) ...
Mon Mar 11 10:59:52 2019			... Gathered VEEAM Node 'RMAAS-V01-VEEAM' System Architecture 'x64-based PC', 1 CPU, LCORE Core 6 Logical Proc ...
Mon Mar 11 10:59:52 2019		... Querying VEEAM Node 'RMAAS-V01-VEEAM' WMI Class WIN32_OPERATINGSYSTEM ...
Mon Mar 11 10:59:52 2019                         Info : WMI Query returned 1 value(s) ...
Mon Mar 11 10:59:52 2019			... Gathered VEEAM Node 'RMAAS-V01-VEEAM' Operating System 'Microsoft Windows Server 2016 Standard' ...
Mon Mar 11 10:59:52 2019			... Gathered VEEAM Node 'RMAAS-V01-VEEAM' Last boot time '2019-03-08 16:15:54' ...
Mon Mar 11 10:59:52 2019			... Gathered VEEAM Node 'RMAAS-V01-VEEAM' Install time '2019-01-09 11:16:49' ...
Mon Mar 11 10:59:52 2019		... Querying VEEAM Node 'RMAAS-V01-VEEAM' WMI Class WIN32_PROCESSOR ...
Mon Mar 11 10:59:53 2019                         Info : WMI Query returned 1 value(s) ...
Mon Mar 11 10:59:53 2019			... Gathered Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz CPU, 6 Threads ...
Mon Mar 11 10:59:53 2019		... Querying VEEAM Node 'RMAAS-V01-VEEAM' WMI Class WIN32_DISKDRIVE ...
Mon Mar 11 10:59:54 2019                         Info : WMI Query returned 2 value(s) ...
Mon Mar 11 10:59:54 2019		... Querying VEEAM Node 'RMAAS-V01-VEEAM' WMI Class WIN32_VOLUME ...
Mon Mar 11 10:59:54 2019                         Info : WMI Query returned 5 value(s) ...
Mon Mar 11 10:59:54 2019			... Detected Logical Partition'\\?\Volume{05493af2-0000-0000-0000-100000000000}\', Size 000000 GB, Free 000000 GB, 69.44 % ...
Mon Mar 11 10:59:54 2019			... Detected Logical Partition'F:\', Size 009999 GB, Free 002762 GB, 72.37 % ...
Mon Mar 11 10:59:54 2019			... Detected Logical Partition'C:\', Size 000292 GB, Free 000273 GB, 6.64 % ...
Mon Mar 11 10:59:54 2019			... Detected Logical Partition'D:\', Size 001207 GB, Free 000905 GB, 24.95 % ...
Mon Mar 11 10:59:54 2019		... Querying VEEAM Node 'RMAAS-V01-VEEAM' WMI Class CIM_STORAGEVOLUME ...
Mon Mar 11 10:59:55 2019                         Info : WMI Query returned 5 value(s) ...
Mon Mar 11 10:59:55 2019		... Querying VEEAM Node 'RMAAS-V01-VEEAM' WMI Class MSFC_FIBREPORTNPIVATTRIBUTES ...
Mon Mar 11 10:59:55 2019                         Info : WMI Query returned no value ...
Mon Mar 11 10:59:55 2019		... Querying VEEAM Node 'RMAAS-V01-VEEAM' WMI Class MSFC_FCADAPTERHBAATTRIBUTES ...
Mon Mar 11 10:59:55 2019                         Info : WMI Query returned no value ...
Mon Mar 11 10:59:55 2019		... Querying VEEAM Node 'RMAAS-V01-VEEAM' WMI Class MSCLUSTER_CLUSTERTONODE ...
Mon Mar 11 10:59:55 2019                         Warning : WMI Query Failed ...
Mon Mar 11 10:59:55 2019		... Querying VEEAM Node 'RMAAS-V01-VEEAM' WMI Class WIN32_LOGICALDISK ...
Mon Mar 11 10:59:55 2019                         Info : WMI Query returned 5 value(s) ...
Mon Mar 11 10:59:55 2019		... Querying VEEAM Node 'RMAAS-V01-VEEAM' WMI Class WIN32_LOGICALDISKTOPARTITION ...
Mon Mar 11 10:59:55 2019                         Info : WMI Query returned 3 value(s) ...
Mon Mar 11 10:59:55 2019		... Querying VEEAM Node 'RMAAS-V01-VEEAM' WMI Class WIN32_DISKDRIVETODISKPARTITION ...
Mon Mar 11 10:59:56 2019                         Info : WMI Query returned 4 value(s) ...
Mon Mar 11 10:59:56 2019		... Querying VEEAM Node 'RMAAS-V01-VEEAM' WMI Class MSFT_STORAGEOBJECT ...
Mon Mar 11 10:59:59 2019                         Info : WMI Query returned 35 value(s) ...
Mon Mar 11 10:59:59 2019		... Querying VEEAM Node 'RMAAS-V01-VEEAM' WMI Class MPIO_GET_DESCRIPTOR ...
Mon Mar 11 10:59:59 2019                         Info : WMI Query returned no value ...
Mon Mar 11 10:59:59 2019		... Querying VEEAM Node 'RMAAS-V01-VEEAM' WMI Class MSVM_COMPUTERSYSTEM ...
Mon Mar 11 10:59:59 2019                         Warning : WMI Query Failed ...
Mon Mar 11 10:59:59 2019		... Querying VEEAM Node 'RMAAS-V01-VEEAM' WMI Class WIN32_PNPSIGNEDDRIVER ...
Mon Mar 11 11:00:05 2019                         Info : WMI Query returned 80 value(s) ...
Mon Mar 11 11:00:05 2019		... Querying VEEAM Node 'RMAAS-V01-VEEAM' WMI Class MSFT_NETLBFOTEAMMEMBER ...
Mon Mar 11 11:00:05 2019                         Info : WMI Query returned no value ...
Mon Mar 11 11:00:05 2019		... Querying VEEAM Node 'RMAAS-V01-VEEAM' WMI Class WIN32_NETWORKADAPTER ...
Mon Mar 11 11:00:06 2019                         Info : WMI Query returned 5 value(s) ...
Mon Mar 11 11:00:06 2019		... Querying VEEAM Node 'RMAAS-V01-VEEAM' WMI Class WIN32_NETWORKADAPTERCONFIGURATION ...
Mon Mar 11 11:00:06 2019                         Info : WMI Query returned 1 value(s) ...
Mon Mar 11 11:00:06 2019			... Gathered VEEAM Node 'RMAAS-V01-VEEAM' IP Addr '192.168.1.71' MAC Addr '00:15:5D:01:13:0C' ...
Mon Mar 11 11:00:06 2019		... Querying VEEAM Node 'RMAAS-V01-VEEAM' WMI Class WIN32_SERVICE ...
Mon Mar 11 11:00:19 2019                         Info : WMI Query returned 211 value(s) ...
Mon Mar 11 11:00:19 2019			... Detected SQL Server Instance 'MSSQL$VEEAMSQL2012' ...
Mon Mar 11 11:00:19 2019			... Querying Cluster Node 'RMAAS-V01-VEEAM' WMI Class WIN32_PERFRAWDATA_MSSQLVEEAMSQL2012_MSSQLVEEAMSQL2012DATABASES for SQL Instance ...
Mon Mar 11 11:00:24 2019                         Info : WMI Query returned 7 value(s) ...
Mon Mar 11 11:00:24 2019					... Detected SQL Server Instance 'MSSQLVEEAMSQL2012' DB 'VEEAMBACKUP' ...
Mon Mar 11 11:00:24 2019					... Detected SQL Server Instance 'MSSQLVEEAMSQL2012' DB 'TEMPDB' ...
Mon Mar 11 11:00:24 2019					... Detected SQL Server Instance 'MSSQLVEEAMSQL2012' DB 'MODEL' ...
Mon Mar 11 11:00:24 2019					... Detected SQL Server Instance 'MSSQLVEEAMSQL2012' DB 'MSSQLSYSTEMRESOURCE' ...
Mon Mar 11 11:00:24 2019					... Detected SQL Server Instance 'MSSQLVEEAMSQL2012' DB 'MSDB' ...
Mon Mar 11 11:00:24 2019					... Detected SQL Server Instance 'MSSQLVEEAMSQL2012' DB 'MASTER' ...
Mon Mar 11 11:00:24 2019			... Detected SQL Server Instance 'MSSQL$VEEAMSQL2016' ...
Mon Mar 11 11:00:24 2019			... Querying Cluster Node 'RMAAS-V01-VEEAM' WMI Class WIN32_PERFRAWDATA_MSSQLVEEAMSQL2016_MSSQLVEEAMSQL2016DATABASES for SQL Instance ...
Mon Mar 11 11:00:24 2019                         Info : WMI Query returned 7 value(s) ...
Mon Mar 11 11:00:24 2019					... Detected SQL Server Instance 'MSSQLVEEAMSQL2016' DB 'VEEAMONE' ...
Mon Mar 11 11:00:24 2019					... Detected SQL Server Instance 'MSSQLVEEAMSQL2016' DB 'TEMPDB' ...
Mon Mar 11 11:00:24 2019					... Detected SQL Server Instance 'MSSQLVEEAMSQL2016' DB 'MODEL' ...
Mon Mar 11 11:00:24 2019					... Detected SQL Server Instance 'MSSQLVEEAMSQL2016' DB 'MSSQLSYSTEMRESOURCE' ...
Mon Mar 11 11:00:24 2019					... Detected SQL Server Instance 'MSSQLVEEAMSQL2016' DB 'MSDB' ...
Mon Mar 11 11:00:24 2019					... Detected SQL Server Instance 'MSSQLVEEAMSQL2016' DB 'MASTER' ...
Mon Mar 11 11:00:24 2019		... Querying VEEAM Node 'RMAAS-V01-VEEAM', collecting last 15 Days history ...
Mon Mar 11 11:00:24 2019		... Querying VEEAM Node 'RMAAS-V01-VEEAM', collecting last 15 Days Recover Point history ...
Mon Mar 11 11:00:24 2019			... Generating Powershell script ...
Mon Mar 11 11:00:24 2019			... Running Powershell script from VEEAM Node 'RMAAS-V01-VEEAM' ...
Mon Mar 11 11:00:30 2019 Rebuilding Storage Usage Evolution Graph ...
Mon Mar 11 11:00:30 2019 	 Rendering Graphs for Group-by 'Application' Servers ...
Mon Mar 11 11:00:30 2019 		 Rendering Graphs for VEEAM Node 'RMAAS-V01-VEEAM', from Group-by 'Application' group ...
Mon Mar 11 11:00:30 2019 			 Rendering Graph for 'C__' ...
891x324
Mon Mar 11 11:00:30 2019 			 Rendering Graph for 'D__' ...
891x324
Mon Mar 11 11:00:30 2019 			 Rendering Graph for 'F__' ...
891x324
Mon Mar 11 11:00:31 2019 			 Rendering Graph for '____Volume_05493af2-0000-0000-0000-100000000000__' ...
891x324
Mon Mar 11 11:00:31 2019 			 Rendering Graph for VEEAM Node 'RMAAS-V01-VEEAM' ...
891x324
Mon Mar 11 11:00:31 2019 		 Rendering Graph for Group-by 'Application' ...
891x324
Mon Mar 11 11:00:31 2019 Rebuilding Sessions ...
Mon Mar 11 11:00:31 2019	 ... Rebuilding Sessions for Group-by 'Application' Host RMAAS-V01-VEEAM - IP Addr 192.168.1.71 ...
Mon Mar 11 11:00:31 2019 Processing and rebuilding reports ...
Mon Mar 11 11:00:31 2019	 Processing Asset, Quick lookup ...
Mon Mar 11 11:00:31 2019	 Processing Asset, Serial Number & Model Overview ...
Mon Mar 11 11:00:31 2019	 Processing Storage, Overview ...
Mon Mar 11 11:00:31 2019	 Processing Databases, Microsoft SQL Server Overview ...
Mon Mar 11 11:00:31 2019	 Processing Server, Boot time Overview ...
Mon Mar 11 11:00:31 2019	 Processing Server, Installation date Overview ...
Mon Mar 11 11:00:31 2019	 Processing Server, Operating System Overview ...
Mon Mar 11 11:00:31 2019	 Processing Networking, Host Adapter Overview ...
Mon Mar 11 11:00:31 2019	 Processing Networking, Host Lookup ...
Mon Mar 11 11:00:31 2019	 Processing Networking, Subnetting ...
Mon Mar 11 11:00:31 2019 Gathering Technical Docs File list (PDF Files only) ...

Mon Mar 11 11:00:31 2019                                  __/^\__
Mon Mar 11 11:00:31 2019                                   (. .)
Mon Mar 11 11:00:31 2019 ==============================oOOO-(_)-OOOo=================================
Mon Mar 11 11:00:31 2019
Mon Mar 11 11:00:31 2019 Job started at   : Mon Mar 11 10:59:51 2019
Mon Mar 11 11:00:31 2019 Job completed at : Mon Mar 11 11:00:31 2019
Mon Mar 11 11:00:31 2019
Mon Mar 11 11:00:31 2019 Open now the ..\data\index_sam.html and have fun !
Mon Mar 11 11:00:31 2019
Mon Mar 11 11:00:31 2019 ============================================================================

This exe file was created with the evaluation version of Perl2Exe.
For more information visit http://www.indigostar.com
(The full version does not display this message with a 2 second delay.)
...

[ThierryF]

Was a problem with Veeam Console on reporting node.
Solved offline.

Th

[ThierryF]

Friends,

I posted version 2.0 ! So, for interrested people, feel free to download.
https://onedrive.live.com/?id=14190B6B5 ... 6B5B8ECCD5

Enjoy !

Th

What's new in this release :

2.0 Rev. 2019-01-06 :
---------------------
- Added Backup Proxy Acitivty Ganttchart
- Added Microsoft Windows based Backup Repository Usage Overview
- Added Backup Repository Proxy Affinity (Vmware and Hyper-V Backup Proxy)
- Added Used Backup proxy (and amount of established Streams) in Scheduled Backup Job Member Details
- Added Veeam Agent Management Discovered Computers Inventory
- Added Backup and Tape Job Pre & Post Processing Options
- Added Managed Certificate Inventory
- Improved Tape Server Library Inventory
- Improved User Interface by introducing Row Highlighting
- Now allowing Veeam configuration retieval only by turning to 0 or leaving empty <History> field from config file.
- Improved Data collection performance
- Added Vmware Vm Machine per Datastore Overview
- Added Job and Job member based Backup evolution graph (Node Used Size(*) vs Transfered Data Size)
(*) Computed sizing being based on disks being selected from backup job definition.

Note : Under Windows 10, RRDTOOL may be claiming font DejaVuSansMono-Roman.ttf cannot be loaded.
If it is not installed, it will try using RRD_DEFAULT_FONT Bitstream Vera Sans Mono monospace or Courier Font.
You can install the DejaVuSansMono-Roman.ttf font located in bin\ms_windows folder or set
environment variable RRD_DEFAULT_FONT to your favorite font.
(eg : RRD_DEFAULT_FONT=c:/windows/fonts/arial.ttf)

[Seb.pythoud]

hi.
Could you show us some screenshots please ?

Thx.
seb.

[ThierryF]

sure, here you are !