Sysadmins removed

An alert is thrown if a user or group is removed from 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 = 'Removed'

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.