Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Application Activity Report lists all activity details, such as login, event, and time of activity, performed per application and database. Use this report to audit activity across multiple applications and databases.

Image Added

This report lists all activity by application. 

(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.

...

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 the schema on which you want to report.

Target Object

Allows you to type the name of one or more target objects 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.

Category

Allows you to select the category type on which you want to report. Select a category type from the drop down menu to filter the report on.

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.

Privileged Users Only

Select between True or False from the drop down list to report on Privileged Users only or to report on All User types.

Run Report

Click this button to Run the report. 

...

Default Columns

Application

The Application column displays the name of the application used to capture the event.

...

The Schema column displays the name of the event´s schema. 

Target Object

The Table Target Object column displays the name of the .target object.. 

Details

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

Time

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

SQL

The SQL column provides the name of the audited SQL Server instance where this event occurredcolumn when set to True, provides the SQL Statement for the captured event.

 



Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

...