Skip to main content
< All Topics
Print

Non-existing servers in module_end whitelist

One or more servers exists in the module_end whitelist table dbo.module_end_exclude, but the servers do not exist.

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

select a.server_name
from dbo.module_end_exclude 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.

Table of Contents