Feature Request: Report all Schedules for Health Checkings

[manuel.aigner]

Hi there,

I have to implement Healthchecking for over 300 Jobs on over 300 Azure Blob Storage Repos.
Your Support told me it's a bad idea to let start them at same time. So I need to know, where is a free slot.
ATM I got an "Overview" by querying VeeamBackup DB and analyze the xml field, where this information is located. Additionally I created a procedural function which outputs a slot time for me, by calculate a little bit around with the chars of the server name I input.

That is working, but is also a big workaround for a product functionality lack.

Many thanks.

[jorgedlcruz]

Hello Manuel,
Apologies for the response received by support, but this is not correct. We do have this information today in the report, and you can cleverly filter it and do a lot with it within the product, let me show you:

Let's start by using the Job Configuration Dump Report, select the jobs you want, or all, and the page called Advanced:


Then let's add some great filtering, for example "Property contains health check schedule" OR "Property contains health check on this day of week"


Let's group just by Job Name, this leaves you with the next view:


Once you have this, feel free to export to CSV and play in Excel, or your favourite AI:


Talking about AI, we do have Veeam Intelligence in Veeam ONE, and one of the best Agents there which is called Deep Data Analysis Agent. To which basically you load any Report, you save this report with these filters, load it to Veeam Intelligence:


Ask away about recommendations and you should receive something similar to this, if not press negative feedback which I read weekly:


Give it a try and keep me posted.

Thank you!

[manuel.aigner]

Hi Jorge,

thanks for your response and sorry for my late answer.
Hmm, I'm not a fan of manual tasks like this. I know, my approach isn't a supported one, but at the moment my only way to fully automate that.
I've to manage hundreds of jobs. In such cases the only way to be sure, that all job configs are compliant to our technical standards is to automate such tasks by script. If there are some tasks I have to do manually in the middle of a configuration process isn't good, as it completely breaks the config workflow.

It would be nice to get such information via Powershell, REST-API, or also WMI is OK for me. But not via AI, where you couldn't be sure that the output is full of hallucinations, or not.

My actual approach ist to query directly the VeeamBackup DB (I know... not supported, but I'm working with things I got). I created a own sql db on backup manager and created some Views which refers to data from Veeam it self.
So I can see how many HC Jobs are scheduled on each 30min. timeslot, all over the month. I also created a procedural schedule distribution function, which calculates a proper time slot based on the server name.

With this Info I can also see, if there are jobs where we forgot to configure such a job and fix that automatically.

here my Output of this distribution View

View_HCJobDistribution
---
| SchedulesCount | GenerationPolicy_RecheckMonthlyScheduleOptions_DayNumberInMonth | GenerationPolicy_RecheckMonthlyScheduleOptions_DayOfWeek | GenerationPolicy_RecheckTime |
| ---: | --- | --- | --- |
| 40 | Last | Saturday | 05:00:00 |
| 2 | Fourth | Thursday | 13:00:00 |
| 2 | Fourth | Tuesday | 14:30:00 |
| 2 | Fourth | Tuesday | 12:00:00 |
| 2 | Fourth | Wednesday | 12:00:00 |
| 2 | Second | Friday | 12:30:00 |
| 2 | Second | Monday | 11:00:00 |
| 2 | Second | Monday | 14:30:00 |
| 2 | First | Friday | 12:30:00 |
| 2 | First | Monday | 15:00:00 |
| 2 | First | Tuesday | 15:00:00 |
| 2 | Second | Tuesday | 10:00:00 |
| 2 | Second | Tuesday | 11:30:00 |
| 2 | Second | Tuesday | 12:00:00 |
| 2 | Second | Wednesday | 06:00:00 |
| 2 | Second | Wednesday | 07:00:00 |
| 2 | Second | Wednesday | 09:00:00 |
| 2 | Second | Wednesday | 12:00:00 |
| 2 | Third | Monday | 10:00:00 |
| 2 | Second | Thursday | 15:00:00 |
| 2 | Third | Friday | 14:30:00 |
| 1 | Third | Monday | 06:00:00 |
...

Your support told me it's a bad idea to schedule all jobs to the same time slot. But Veeam doesn't offer an "easy to use" overview of when is which job scheduled.
My way here is working great, but I know it's not supported. So please give us a supported way without work intensive workarounds

BR
Manuel

[jorgedlcruz]

Hello Manuel,
The report it is produced once, and then Veeam Intelligence with the Deep Data Analysis Agent mounts the data of the report and works based on it, hallucinations might happen but as it is based on the data presented by the report the chances are low. Did you try it?

Have you checked the report with the filtering I mentioned above? You do that just once for all jobs, schedule the report to send the CSV to a path, as part of the schedule you can attach your own script. Meaning that you can, without AI hallucinations:

• Use the report that we know has the data you require, all the jobs and when it is the health check scheduled
• Save this report and schedule it
• In the schedule, save the CSV you trust into a path
• In the schedule add a small script that reads the latest .csv, does the calculations you need, and send you a comfortable email with the summary on what to change

To me seems less complicated than querying VBR database, which depending of the auth the script has can be a problem if someone gets their hands into it.

Another supported option could be using VBR RestAPI, as it has this information, if you use this endpoint you can see it under data.storage.advancedSettings.backupHealth

• https://helpcenter.veeam.com/references ... GetAllJobs

I think the Veeam Intelligence in Veeam Backup & Replication that uses these APIs, or the new Veeam MCP can help you getting this if you want to give AI a try.

Let me know