How can we help?
Non-existing servers in agent job whitelist
One or more servers exists in the agent job whitelist table dbo.agent_job_whitelist, but the servers do not exist.
To query the Performance Store database for non-existing servers in the agent job whitelist, use:
select a.server_name from dbo.agent_job_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.