Continuing our learning series on auditing, today we look at how to query the audit information from the server.

• sys,server_audits displays information on the audits setup on the server.
  

  Figure 1 – Sys.server_audits

• sys.server_audit_specifications displays information on the audit specification setup on the server.
  

  Figure 2 – Sys.server_audit_specification

• sys.server_audit_specification_details display detailed information about the specifications.
  

  Figure 3 – Sys.server.audit.specification.detail

• sys.dm_server_audit_status displays information about the status of your audits.
  

  Figure 4 – Sys.dm_server_audit_status

Enjoy and stay tuned!