Checking if all Vcenter VMs has Veeam backup job created

[pmakow]

Hello,

I've checked existing subjects on the forum, but I couldn't find solution for my problem.

I'm looking for solution giving me possibility, to compare VMs existing on Vcenter server, with Veeam backup jobs,
which will show me, if every vcenter's VM and its resources (like virtual disks) have been added to backup jobs.

May be someone know a tool, which gives that possibility?

My idea was to:

1. write MSSQL query to Veeam database, which will return a list of VMs and their virtual disks, which are defined in backup jobs
2. write MSSQL query to Vcenter database, which will return a list of VMs and their virtual disks
3. compare outputs
4. send an e-mail with comparison results

It is hard to do, because I don't know associations between Veeam's db keys, and also vcenter ..

Have you got any ideas?

Many thanks for your help.

[PTide]

Hi and welcome to the community,

It look like this Veeam ONE report meets your requirements, doesn't it?

Thank you

[pmakow]

PTide thank you for answer.

Yes, Veeam One report meets my requirements, but it is a tool which gives possibility to make a lot of reports so the license for it is expensive.
I need only one report - Protected VMs.
Any idea how to get this possibility without buying license for Veeam One application?
May be you know another free software which gives that possibility?

[veremin]

Here is a free PS script; should meet your expectations. Thanks.

[dellock6]

There's also this one, originally created by Tom Sightler, that i posted on my blog:
https://www.virtualtothecore.com/en/bac ... 6-edition/

Luca

[pmakow]

It is what I was looking for.
Many thanks!

[pmakow]

I need one more functionality.
The above scripts doesn't check, if there was any VM changes and if backup contains that changes.

For example: when there is a valid backup during last 24h, and after backup finish I add another virtual disk to VM,
or I expand existing disk, and then run the script once again, the script will still return info, that VM is backed up - even if this backup isn't full backup, because it doesn't include resources I mentioned.

My idea is to schedule PS script, which will recalculate resources in all jobs before backups starts.

Do you guys have the script giving possibility to recalculate all resources in jobs, or another idea how to achieve this functionality?

I need to know if my backups includes all VMs resources.

Thank you for help.

[veremin]

To my knowledge such script doesn't exist. You will probably need to:

- either preserve previous VM configuration, compare it with the current one during the script execution and initiate new backup, in case they differ from each other
- or parse vSphere logs within the script, looking for VM configuration changes, and initiate new backup, in case some are found

Thanks.

[pmakow]

Thanks for reply.

But what in case, if someone will forget about recalculate after VM chages?
There is no automatic method to check if recalculation occured?

[veremin]

What kind of recalculation are you talking about? The script should check whether VM configuration has changed since the latest script's execution and take actions accordingly.

To check the state of VM configuration you will need either to preserve the previous VM configuration (the one you got the last time the script was executed) or search through vSphere logs for specific events that occurred after the script was executed last time.

Thanks.

[pmakow]

I'm talking about "Recalculte" option in Veeam Backup and Replication Console jobs (job edit->Virtual Machines->Recalculate).
If I don't use this option the Veeam B&R doesn't see any VM changes.
Do you know if it is a way to automatically recalculate all VMs in all defined jobs, or I need to open each job and click recalculate ?

[Vitaliy S.]

If you want to emulate this button functionality, then please take a look a this topic > Emulate recalculate button with powershell

Keep in mind though, that this button does not calculate changes, it only tracks if new VMs/disks were added to the source container or not.