-
- Lurker
- Posts: 2
- Liked: never
- Joined: Feb 07, 2024 3:31 pm
- Contact:
Veeam Threat Center RPO Anomalies
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?
-
- 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
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.
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
Senior Product Manager | Veeam ONE @ Veeam Software
@jorgedlcruz
https://www.jorgedelacruz.es / https://jorgedelacruz.uk
vExpert 2014-2025 / InfluxAce / Grafana Champion
-
- Lurker
- Posts: 2
- Liked: never
- Joined: Feb 07, 2024 3:31 pm
- Contact:
Re: Veeam Threat Center RPO Anomalies
Thanks. I always try and find the answer myself but sometimes you just have to ask those who know more than me.
-
- Service Provider
- Posts: 125
- Liked: 31 times
- Joined: Jan 04, 2018 4:51 pm
- Contact:
Re: Veeam Threat Center RPO Anomalies
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.
-
- 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
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:
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:
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.
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)
;
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');
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
Senior Product Manager | Veeam ONE @ Veeam Software
@jorgedlcruz
https://www.jorgedelacruz.es / https://jorgedelacruz.uk
vExpert 2014-2025 / InfluxAce / Grafana Champion
Who is online
Users browsing this forum: No registered users and 5 guests