Veeam Threat Center RPO Anomalies

[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]

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.

[jbarrettSCSC]

Thanks. I always try and find the answer myself but sometimes you just have to ask those who know more than me.

[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]

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.