-- 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