This 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 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.
SQL Compliance Manager audits all activity on your server. Learn more > >