How can we help?
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.