How can we help?
Database role member added
Will throw a one-time alert when a user or group is added to a database role.
To query the Performance Store database for the last 100 added database role members, use:
select top 100 a.* from dbo.v_audit a where a.event_type = 'ADD_ROLE_MEMBER' order by a.post_time desc
To exclude specific servers from this alert, see how to use the dbo.team_alert_exclude table in Alerting.