79550666

Date: 2025-04-02 12:53:09
Score: 1.5
Natty:
Report link

Thanks to siggermannen and Dan Guzman I made it to the following query:

use [OmegaCA_Benchmark]

select 
a.database_specification_id,
a.audit_action_id, a.audit_action_name, 
a.class, a.class_desc, 
a.major_id,
object_schema_name = 
CASE 
    WHEN a.class_desc = 'OBJECT_OR_COLUMN' THEN OBJECT_SCHEMA_NAME(a.major_id)
    ELSE NULL
END,
object_name = 
CASE 
    WHEN a.class_desc = 'OBJECT_OR_COLUMN' THEN OBJECT_NAME(a.major_id)
    WHEN a.class_desc = 'SCHEMA' THEN SCHEMA_NAME(a.major_id)
    WHEN a.class_desc = 'DATABASE' THEN 'OmegaCA_Benchmark'
    ELSE NULL
END,
a.minor_id,
a.audited_principal_id, c.name as Principal_Name,
a.audited_result, 
a.is_group,
b.name as DB_Aud_Spec_Name, 
b.create_date, b.modify_date, 
b.audit_guid, 
b.is_state_enabled

from sys.database_audit_specification_details a

inner join sys.database_audit_specifications b
on a.database_specification_id = b.database_specification_id

inner join sys.database_principals c 
on a.audited_principal_id = c.principal_id

best regards
Altin

Reasons:
  • Blacklisted phrase (0.5): Thanks
  • Blacklisted phrase (0.5): best regards
  • Blacklisted phrase (1): regards
  • Long answer (-1):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (0.5):
Posted by: altink