Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save nullbind/5da8b5113da007ba0111 to your computer and use it in GitHub Desktop.
Save nullbind/5da8b5113da007ba0111 to your computer and use it in GitHub Desktop.
-- List enabled server specifications
SELECT audit_id,
a.name as audit_name,
s.name as server_specification_name,
d.audit_action_name,
s.is_state_enabled,
d.is_group,
d.audit_action_id,
s.create_date,
s.modify_date
FROM sys.server_audits AS a
JOIN sys.server_audit_specifications AS s
ON a.audit_guid = s.audit_guid
JOIN sys.server_audit_specification_details AS d
ON s.server_specification_id = d.server_specification_id
WHERE s.is_state_enabled = 1
-- List enabled database specifications
SELECT a.audit_id,
a.name as audit_name,
s.name as database_specification_name,
d.audit_action_name,
s.is_state_enabled,
d.is_group,
s.create_date,
s.modify_date,
d.audited_result
FROM sys.server_audits AS a
JOIN sys.database_audit_specifications AS s
ON a.audit_guid = s.audit_guid
JOIN sys.database_audit_specification_details AS d
ON s.database_specification_id = d.database_specification_id
WHERE s.is_state_enabled = 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment