Non-existing servers in backup time whitelist

One or more servers exists in the database backup time whitelist table dbo.database_backup_time_whitelist, but the servers do not exist.

To query the Performance Store database for non-existing servers in the backup time whitelist, use:

select a.server_name
from dbo.database_backup_time_whitelist a
left join dbo.v_servers s on s.server_name = a.server_name
where s.server_name is null
and a.server_name is not null
group by a.server_name

The alert will be visible on the Latest stats dashboard.

To exclude specific servers from this alert, see how to use the dbo.team_alert_exclude table in Alerting.