The Archived Events tab allows you to read previously collected audit data that has been moved to an archive database for storage.
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.
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.
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.
Allows you to filter the listed events by time span (for example, last seven days) or event category (for example, security).
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.
Allows you to view details about the selected archive database.
Allows you to update the Archives list with current data.
Allows you to view details about the selected event.
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.
Provides the category SQL Server assigns to this event.
Provides the type of SQL action that caused this event, such as CREATE USER.
Provides the date that the event occurred.
Provides the time that the event occurred.
Provides the SQL Server login of the user whose actions generated this event.
Provides the name of the database on which the event occurred.
Provides the name of the database object targeted by the T-SQL statement associated with this event.
Provides the text description of the event.
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.
Indicates whether this event passed or failed the SQL Server access check.
Provides the name of the application that initiated this event.
Provides the name of the database user who executed this event.
Provides the name of the computer where the event was initiated.
Provides the name of the database object affected by this event
Provides the name of the owner of the database affected by this event.
Indicates whether the user who initiated this event was a privileged user.
Provides the type of SQL Server role assigned to the user who initiated this event.
Provides the name of the SQL Server affected by this event.
Provides the login credentials used to open the corresponding session with SQL Server.
Provides the SQL Server internal process ID of the object affected by the event.
Provides the name of the SQL Server login targeted by the T-SQL statement associated with this event.
Provides the name of the database user targeted by the T-SQL statement associated with this event.