Page History

This report The Alert Activity - Data Report shows SQL Compliance Manager data alert activity in your monitored environment. Use this report to track Data Alert Activity performed in specific Tables or at an specific point in time. identify and investigate data manipulation on specific databases, tables, or columns.

A filter can include a list of wildcards, separated by commas, where a wildcard is a string, which may contain asterisks. The following parameters are specific to the selected report and enable you to filter the data to include in the report. 

Available actions

Server Instance

Allows you to select a registered instance on which you want to report. Select ALL to report on all instances.

...

Allows you to select or type the name of one or more table names on which you want to report.

Login

Allows you type or to select the login from the drop down list of available logins. Select ALL to report on all logins.

Start Date

...

Select between AM or PM from the drop down list to configure the End Time for Each Day range from which you want to report.

Schema

Allows you to type the name of the schema on which you want to report.

...

Select between True or False from the drop down list menu to show filter the SQL Text as part of the reportreport by SQL Text.

Alert Level

Choose to filter alerts by their different levels; Severe, High, Medium, or Low.

Run Report

Click this button to Run the report. 

...

Default columns

Time

The Time column displays the date and time when the event was captured. 

...

The Details column provides the first line of the alert message associated with this alert.

SQL

The SQL column displays the ... when set to True, provides the SQL Statement for the captured event.

...