There is no table for the Server Role Members module, only views Collector.ServerRoleMemberCurrent and Collector.ServerRoleMemberPrevious, which feed from the Collector.Logins table. For more information, see the Logins Module.
Stored procedures
Alert.AdminRoleLoginNewRetired
This procedure is called automatically from jobs, to alert you to new and retired logins in high-level SQL Server roles.| Parameter | Type | Description |
| @EmailProfile | varchar | The name of the email profile to use for this alert. |
| @ServiceLevel | varchar | The service level to alert for. |
Views
Collector.ServerRoleMemberCurrent
Provides the most recent collection of server role membership data.Each “Current” view associated with a Collector table contains all (or nearly all) of the columns from the base table, plus a “ViewDesc” description column, and columns from dbo.Servers data:
- ServerName
- ServiceLevel
- Version
- Edition
- Descr
Collector.ServerRoleMemberPrevious
Provides the next-to-most recent collection of server role membership data.Each “Previous” view associated with a Collector table contains all (or nearly all) of the columns from the base table, plus a “ViewDesc” description column, and columns from dbo.Servers data:
- ServerName
- ServiceLevel
- Version
- Edition
- Descr