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