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:
- General SQL Server properties. SQL Server SQL Server Properties displays the name of the instance, the version of SQL Server being and edition of the SQL Server are used, and the Windows Operating System the SQL Server SQL Server instance is operating on.
- Auditing status. On the right section of the SQL Server instance. 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, including the time it was taken, the collection statistics, audit filter information, and a listing of any suspect Windows accounts or unavailable databases that were encountered while the Snapshot was being taken. For more information on suspect Windows accounts, see Identify Suspect Windows Accounts. For more information on unavailable databases, see Identify Unavailable Databases.. The table below describes the information displayed in this section.
Image Added
Information contained in Audit History
The following table describes the information displayed in each of the columns:
/ | The date when the snapshot was taken. |
Time | The |
date and 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. |
Group MembersWindows Accounts | The number of |
group members Windows accounts collected in the snapshot. |
SQL Secure tells you who has access to what on your SQL Server databases. Learn more > >
...