Skip to main content

2.Activity Job Group

The jobs in the 2. Activity Job Group provides insight into user login activity, object permission changes, unusual database activity, SQL and Azure SQL activities against sensitive data, and SQL and Azure SQL activities against selected or all database objects.

2.Activity Job Group

The jobs in the 2.Activity Job Group are:

  • SQL_Activity Job – This job is designed to provide insight into user activity in target SQL and Azure SQL server instances and databases in each instance based on the SQL Server Audit Specification settings
  • SQL_Logons Job – This job is designed to provide insight into failed or successful SQL and Azure SQL server logon activity across all the targeted SQL and Azure SQL Servers
  • SQL_PermissionChanges Job – This job is designed to provide detailed information about the changes in permissions across all the database objects, specifically objects containing sensitive data
  • SQL_SensitiveDataActivity Job – This job is designed to provide detailed information about all the DML (UPDATE, INSERT, DELETE, TRUNCATE) against objects containing selective data
  • SQL_UnusualActivity Job – This job group is designed to highlight any anomalies related to outlying user activity by database across all the targeted SQL and Azure SQL server instances.