Non-existing servers in drive predictions whitelist

One or more servers exists in the drive predictions whitelist table dbo.drive_predictions_whitelist, but the servers do not exist.

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

select d.server_name
from dbo.drive_predictions_whitelist d
left join dbo.v_servers s on
case
	when charindex('\', s.server_name) > 0 then substring(s.server_name, 0, charindex('\', s.server_name))
	when charindex(',', s.server_name) > 0 then substring(s.server_name, 0, charindex(',', s.server_name))
	else s.server_name
end = d.server_name
where s.server_name is null
and d.server_name is not null
group by d.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.