This 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.
(Screenshot)
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.
Databases
Allows you to select or type the name of one or more databases on which you want to report.
Table Name
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 select the login from the drop down list of available logins. Select ALL to report on all logins.
Start Date
Allows you to select the start date for the range from which you want to report.
End Date
Allows you to select the end date for the range from which you want to report.
Start Time - Hour
Allows you to select the exact starting hour of the day for the range from which you want to report.
Start Time - Min
Allows you to select the exact starting minute of the day for the range from which you want to report.
Start Time - AM/PM
Select between AM or PM from the drop down list to configure the Start Time for Each Day range from which you want to report.
End Time - Hour
Allows you to select the exact ending hour of the day for the range from which you want to report.
End Time - Min
Allows you to select the exact ending minute of the day for the range from which you want to report.
End Time - AM/PM
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 type the name of the schema on which you want to report.
Application
Allows you to type the name of one or more applications on which you want to report.
Host
Allows you to type the name of one or more hosts on which you want to report.
Show SQL
Select between True or False from the drop down list to show the SQL Text as part of the report.
Run Report
Click this button to Run the report.
Available fields
Time
The Time column displays the date and time when the event was captured.
Alert Level
The Alert Level column displays the ...
Event
The Event column displays a description of the event captured.
Login
The Login column displays the ...
Host
The Host column displays the ...
Application
The Application column displays the ...
Database
The Database column displays the ...
Schema Name
The Schema Name column displays the ...
Table
The Table column displays the ...
Details
The Details column displays the ...
SQL
The SQL column displays the ...