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:

ItemDescription
DateThe date when the snapshot was taken.
TimeThe time when the snapshot was taken.
StatusThe status of the snapshot (audit data collection).
CommentsDescription of any issues the collector encountered.
BaselineWhether or not the snapshot is marked as a baseline.
ObjectsThe number of objects audited in the snapshot.
PermissionsThe number of permissions collected in the snapshot.
LoginsThe number of logins collected in the snapshot.
Windows AccountsThe number of Windows accounts collected in the snapshot.

IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal
  • No labels