Page History
The Object Activity Report ... allows users to configure their preferred email and SNMP settings, as well as to groom undesired alerts on your SQL Servers. lists all activity for specified objects performed on specific databases. Use this report to audit mass data movement or database object activity, such as SELECT or UPDATE, across multiple databases.
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 databases 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
Allows you to select the start date for the range from which you want to report.
...
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 one or more schema on which you want to report.
...
Allows you to type the name of one or more hosts on which you want to report.
Category
Allows you to select the category type on which you want to report. Select from a category type to filter on from the drop down menu.
Event
Allows you to type the name of one or more events on which you want to report.
Show SQL
Select between True or False from the drop down menu to filter the report by SQL Text.
...
Click this button to Run the report.
...
Default columns
Database
The Database column displays the name of the database where the event was captured...
Schema Name
The Schema Name column displays the ... name of the event´s schema.
Target Object
The Target Object column displays the .name of the target object..
Details
The Details column displays the ..provides details of the captured event.
Event
The Event column displays a description of the event captured.
Login
The Login column displays the login name of the ... user who performed the event.
Host
The Host column displays the ... name of the host.
Application
The Application column displays the ... the name of the application used to capture the event.
Time
The Time column displays the date and time when the event was captured.
SQL
The SQL column when set to True, provides the SQL Statement for the captured event.
...