Monitoring and reporting for Veeam Data Platform
Post Reply
jbarrettSCSC
Lurker
Posts: 2
Liked: never
Joined: Feb 07, 2024 3:31 pm
Contact:

Veeam Threat Center RPO Anomalies

Post by jbarrettSCSC »

On Veeam One Web Client Threat Center, it shows RPO Anomalies. Easy enough I was able to track down why some machines didn't have backups. Now I come across my last machine my Veeam Backup Server. I don't include it in any backup job. Instead, I backup its configuration as listed in. https://www.veeam.com/kb2645 So is there a way to exclude this VM so I can get the RPO anomalies down to 0?
jorgedlcruz
Veeam Software
Posts: 1550
Liked: 669 times
Joined: Jul 17, 2015 6:54 pm
Full Name: Jorge de la Cruz
Contact:

Re: Veeam Threat Center RPO Anomalies

Post by jorgedlcruz » 1 person likes this post

Hello!
Great story thanks for sharing. We are very happy you were able to track down some of those critical workloads without protection :)

There is nothing actually for this, and it is so great use-case of course. Let me ask if we can fine-tune something on the Stored Procedure as a quick workaround meanwhile we add a functionality for this!

Thanks so much.
Jorge de la Cruz
Senior Product Manager | Veeam ONE @ Veeam Software

@jorgedlcruz
https://www.jorgedelacruz.es / https://jorgedelacruz.uk
vExpert 2014-2025 / InfluxAce / Grafana Champion
jbarrettSCSC
Lurker
Posts: 2
Liked: never
Joined: Feb 07, 2024 3:31 pm
Contact:

Re: Veeam Threat Center RPO Anomalies

Post by jbarrettSCSC »

Thanks. I always try and find the answer myself but sometimes you just have to ask those who know more than me.
jasonede
Service Provider
Posts: 125
Liked: 31 times
Joined: Jan 04, 2018 4:51 pm
Contact:

Re: Veeam Threat Center RPO Anomalies

Post by jasonede »

I'd like to be able to exclude machines from this too. We have our Veeam backup proxies on our cloud that we don't backup (as they're easily replaced anyway) and so would be good to exclude.
jorgedlcruz
Veeam Software
Posts: 1550
Liked: 669 times
Joined: Jul 17, 2015 6:54 pm
Full Name: Jorge de la Cruz
Contact:

Re: Veeam Threat Center RPO Anomalies

Post by jorgedlcruz »

Hello,
So I have a workaround, not supported and of course it will get override with upgrades, etc. Use it at your own risk, and make sure you have a copy of the stored procedure.

1.- Open the VONE SQL Database with Management Studio, navigate to VONE Database > Programmability > Stored Procedures. And look for the one called reportpack.wid_DPPO_RestorePointObjectiveAnomalies. Ok, right click Modify, at this point if I was you I would CTRL + A, and take that somewhere else so I can restore if needed.

2.- Time to edit, look for the next part, almost at the end:

Code: Select all

	select workload_name
		,workload_type
		,workload_type_id
		,backup_server
		,backup_server_id
		,max(last_success) as last_success
		,max(missing_rpo) as missing_rpo
	into #result
	from #pre_result rp
	where workload_type_id in (0 ,3)
	group by workload_name, group_value, workload_type, workload_type_id, backup_server, backup_server_id
	union all
	select workload_name
		,workload_type
		,workload_type_id
		,backup_server
		,backup_server_id
		,last_success
		,missing_rpo
	from #pre_result
	where workload_type_id in (1, 2, 4)
	;
3.- Replace that whole part with this, add here the workloads you want to omit, in my case I have VEEAM-ONE, and AD-DNS-001:

Code: Select all

	select workload_name
		,workload_type
		,workload_type_id
		,backup_server
		,backup_server_id
		,max(last_success) as last_success
		,max(missing_rpo) as missing_rpo
	into #result
	from #pre_result rp
	where workload_type_id in (0, 3)
	  and workload_name NOT IN ('VEEAM-ONE', 'AD-DNS-001')
	group by workload_name, group_value, workload_type, workload_type_id, backup_server, backup_server_id
	union all
	select workload_name
		,workload_type
		,workload_type_id
		,backup_server
		,backup_server_id
		,last_success
		,missing_rpo
	from #pre_result
	where workload_type_id in (1, 2, 4)
	  and workload_name NOT IN ('VEEAM-ONE', 'AD-DNS-001');
4.- Click execute a few times. That's it.
5.- Go to the Threat Center, and edit the RPO widget, change the number of workloads, like from 25, to 24, or to 3, we just want a different value so it refresh, click Save and it should work.

NOT SUPPORTED, but keen to hear your feedback. We are hoping to add filtering in a much easier way in the future.
Jorge de la Cruz
Senior Product Manager | Veeam ONE @ Veeam Software

@jorgedlcruz
https://www.jorgedelacruz.es / https://jorgedelacruz.uk
vExpert 2014-2025 / InfluxAce / Grafana Champion
Post Reply

Who is online

Users browsing this forum: No registered users and 5 guests