CODEWITHSUNDEEP
sql-server-2008-r2auditing
frosty
frosty

Reputation: 2862

SQL Server 2008 Auditing - reports

Other than using SQL statement like SELECT * FROM fn_get_audit_file('C:\SQLSvrAuditing*', default, default), are there good reporting available for SQL Server auditing? Even if there are useful query templates, it will be helpful.

Upvotes: 0

Views: 69

Answers (1)

Milena Petrovic
Milena Petrovic

Reputation: 2771

No, there is no elegant solution for reading *.sqlaudit files.

One option is to use the fn_get_audit_file function, like you said. You can use the exact column list, and add a WHERE condition to narrow down the results. E.g.

WHERE action_id IN ( 'LGIF' , '%AU%', 'SL', 'IN', 'DR',  )

Another option is to use the Log File Viewer utility in SQL Server Management Studio.

enter image description here

enter image description here

Upvotes: 1

Related Questions