CREATE VIEW sys.server_file_audits AS
SELECT
au.audit_id,
au.name,
au.audit_guid,
au.create_date,
au.modify_date,
au.principal_id,
au.type,
au.type_desc,
au.on_failure,
au.on_failure_desc,
au.is_state_enabled,
au.queue_delay,
convert(bigint, ms.value) AS max_file_size,
convert(int, mr.value) AS max_rollover_files,
sysconv(bit, au.status & 0x10000) AS reserve_disk_space,
convert(nvarchar(260), pt.value) AS log_file_path,
convert(nvarchar(260), nm.value) AS log_file_name
FROM sys.audits$ au
LEFT JOIN master.sys.sysobjvalues ms ON ms.valclass = 38 AND ms.objid = au.audit_id AND ms.subobjid = 0 AND ms.valnum = 50 -- SVC_AUDITPROPS/AUDIT_FL_MAX_SIZE
LEFT JOIN master.sys.sysobjvalues mr ON mr.valclass = 38 AND mr.objid = au.audit_id AND mr.subobjid = 0 AND mr.valnum = 51 -- SVC_AUDITPROPS/AUDIT_FL_MAX_ROLLOVER
LEFT JOIN master.sys.sysobjvalues nm ON nm.valclass = 38 AND nm.objid = au.audit_id AND nm.subobjid = 0 AND nm.valnum = 53 -- SVC_AUDITPROPS/AUDIT_FL_NAME
LEFT JOIN master.sys.sysobjvalues pt ON pt.valclass = 38 AND pt.objid = au.audit_id AND pt.subobjid = 0 AND pt.valnum = 54 -- SVC_AUDITPROPS/AUDIT_FL_PATH
WHERE au.type = 'FL'