Skip to main content
How can we help?
< All Topics
Print

Inactive users

To query the Performance Store database for servers with users that are no longer present in Active Directory or where the user account is disabled in Active Directory:

select s.*
from dbo.v_server_security s
where s.member_type = 'U' and s.enabled_in_ad = 0

To see server security and what users 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.

Table of Contents