To view IDERA SQL Secure information related to a specific SQL Server, click the server under the Audited SQL Servers tree, and on the right side of the console, SQL Secure displays the respective server summary information. The Server Summary window allows you to view the following:
- SQL Server properties. SQL Server Properties displays the name of the instance, the version and edition of the SQL Server being used, and the Windows Operating System the SQL Server instance is operating on.
- Auditing status. On the right section of the Server Summary, the Auditing Status displays the status of the last collection, the date and time of the next scheduled collection, and basic statistics for the latest snapshot.
- Audit history. Audit History provides detailed information about your snapshot. The table below describes the information displayed in this section.
Information contained in Audit History
The following table describes the information displayed in each of the columns:
Item | Description |
---|---|
Date | The date when the snapshot was taken. |
Time | The time when the snapshot was taken. |
Status | The status of the snapshot (audit data collection). |
Comments | Description of any issues the collector encountered. |
Baseline | Whether or not the snapshot is marked as a baseline. |
Objects | The number of objects audited in the snapshot. |
Permissions | The number of permissions collected in the snapshot. |
Logins | The number of logins collected in the snapshot. |
Windows Accounts | The number of Windows accounts collected in the snapshot. |