Sysadmins added

How can we help?
< All Topics
Print

Sysadmins added

An alert is thrown if a user or group is added to the sysadmins server role.

To query the Performance Store database for details of the action as well as previous sysadmin modifications, use:

select t.*
from dbo.v_custom_stats_history t
where t.name = 'Sysadmins'
and t.action = 'Added'

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