How To Read SQL Server Audit

dbtut

6 years ago

You can read the article “How To Create SQL Server Audit” to get more information about Audit and create an audit.

You can read an audit via SSMS with the help of the following script.

SELECT * FROM sys.fn_get_audit_file ('C:\Audit\AuditFileName.sqlaudit' , default, default)

1	SELECT * FROM sys.fn_get_audit_file ('C:\Audit\AuditFileName.sqlaudit' , default, default)

We read our audit “AuditFileName.sqlaudit” under “C:\Audit” path in our script.

You must write the path of the audit files that you want to read instead of “C:\Audit”.

You must also write the name of the audit file that you want to read instead of “AuditFileName”.