Page tree

The Archived Events tab allows you to read previously collected audit data that has been moved to an archive database for storage.

Available actions

Page through events

Allows you to page through the list of events. Use the previous and next arrows to navigate from page to page, up and down the list.

Update databases to use optimized indexes

Allows you to update archive and event databases generated with earlier versions of IDERA SQL Compliance Manager. Updating the databases applies optimized indexes that improve the Management Console performance.

To update the databases, click the provided link. Be aware that this update process requires free disk space, may be resource-intensive, and may take some time to complete. Consider performing database updates during non-peak hours.

Create customized view

Allows you to create a custom version of this tab. You can change the data that is displayed by selecting different columns. You also can save your customizations to view later.

Attach

Allows you to load audit data stored in the archive database so you can view and run reports on the events. By default, SQL Compliance Manager loads events from the most recently created archive database.

Detach

Allows you to remove the selected archive database. Removing the archive prevents users from viewing and running reports on the audit data stored in the database.

Filters

Allows you to filter the listed events by time span (for example, last seven days) or event category (for example, security).

Enable Groups

Allows you to group events by a specific property, such as the audited SQL Servers affected by the events or the times the events occurred. Enable groups when you want to sort the events or focus on a particular event attribute.

Archives Properties

Allows you to view details about the selected archive database.

Refresh

Allows you to update the Archives list with current data.

Event Properties

Allows you to view details about the selected event.

Default columns

Icon

Provides a visual indication of the event category so you can quickly scan the listed event for a specific event type, such as security events.

Category

Provides the category SQL Server assigns to this event.

Event

Provides the type of SQL action that caused this event, such as CREATE USER.

Date

Provides the date that the event occurred.

Time

Provides the time that the event occurred.

Login

Provides the SQL Server login of the user whose actions generated this event.

Database

Provides the name of the database on which the event occurred.

Target Object

Provides the name of the database object targeted by the T-SQL statement associated with this event.

Details

Provides the text description of the event.

Additional columns

You can add any of these columns to this tab using the Select Column action. After you add a new column, you can save the tab as a custom view to reference later.

Access Check

Indicates whether this event passed or failed the SQL Server access check.

Application

Provides the name of the application that initiated this event.

Database User

Provides the name of the database user who executed this event.

Host

Provides the name of the computer where the event was initiated.

Object

Provides the name of the database object affected by this event

Owner

Provides the name of the owner of the database affected by this event.

Privileged User

Indicates whether the user who initiated this event was a privileged user.

Role

Provides the type of SQL Server role assigned to the user who initiated this event.

Server

Provides the name of the SQL Server affected by this event.

Session Login

Provides the login credentials used to open the corresponding session with SQL Server.

SPID

Provides the SQL Server internal process ID of the object affected by the event.

Target Login

Provides the name of the SQL Server login targeted by the T-SQL statement associated with this event.

Target User

Provides the name of the database user targeted by the T-SQL statement associated with this event.



IDERA |  Products | Purchase | Support |  Community | Resources |  About Us | Legal