Skip to main content

SQL_Activity Job

The SQL_Activity Job provides insight into user activity in target SQL server instances and databases based on SQL Server Audit Specification settings.

Analysis Tasks for the SQL_Activity Job​

Navigate to the Databases > SQL > 2.Activity > SQL_Activity > Configure node and select Analysis to view the analysis tasks.

warning

Do not modify or deselect the selected analysis task(s). The analysis task(s) are preconfigured for this job.

Analysis Selection

The default analysis tasks are:

  • List SQL User Activity Details – Creates the SA_SQLServer_Activity_Details table accessible under the job’s Results node
  • User Activity Database Summary – Creates the SA_SQLServer_Activity_UserDatabaseSummary table accessible under the job’s Results node
  • User Activity Instance Summary – Creates the SA_SQLServer_Activity_UserInstanceSummary table accessible under the job’s Results node

In addition to the tables and views created the analysis task, the SQL_Activity Job produces the following pre-configured report.

ReportDescriptionDefault TagsReport Elements
User Activity SummaryThis report lists all SQL events, and summarizes them by database and instance.NoneThis report is comprised of three elements:
  • Bar Chart – Displays users with most events by instance
  • Table – Provides details on users with most events by database
  • Table – Provides details on event details