1.Users and Roles Job Group

The 1.Users and Roles Job Group is designed to provide insight into user security, roles, and object permissions to all SQL or Azure SQL server objects.

The jobs in the 1.Users and Roles Job Group are:

• SQL_DatabasePrinciples Job – This job group is designed to provide detailed information on database principals across all the targeted SQL or Azure SQL server instances
• SQL_PasswordIssues Job – This job group is designed to analyze the SQL or Azure SQL login passwords and evaluate if they comply with the prescribed password policies. In addition, it checks for weak passwords.
• SQL_RoleMembers Job – This job is designed to analyze and provide information about all the role members in each o the SQL or Azure SQL server role groups, both at the instance and database level, across all the targeted SQL or Azure SQL servers
• SQL_ServerPrincipals Job – This job is designed to provide information about all the server principals on the instances across all the targeted SQL or Azure SQL servers
• SQL_SQLLogins Job – This job is designed to provide information on both successful and failed SQL or Azure SQL server logins across all the targeted SQL or Azure SQL servers
• SQL_SysAdmins Job – This job group is designed to provide insight into all the users who have SQL or Azure SQL server administration roles across all the targeted SQL or Azure SQL servers