SQLServer dump audit specifications

dump_audit.sql

SELECT [sa].[name] as audit_name, [sas].[name] as audit_spec_name, [sasd].[audit_action_name] as action, [dp].[name] as username, [o].[name] as tablename
FROM sys.server_audits sa
JOIN sys.database_audit_specifications sas ON sa.audit_guid = sas.audit_guid
JOIN sys.database_audit_specification_details as sasd ON sas.database_specification_id = sasd.database_specification_id
JOIN sys.database_principals dp ON dp.principal_id = sasd.audited_principal_id
JOIN sys.objects o ON o.object_id = sasd.major_id