Inactive groups

To query the Performance Store database for servers with AD groups that are no longer present in Active Directory, use:

select s.*
from dbo.v_server_security s
where s.type = 'G' and s.ad_enabled = 0

To see server security and what groups are inactive, use the Server access dashboard.

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.