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.

CAUTION: 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