Efficient Time-Based Audit Log Filtering for Azure SQL Database

  • Thread starter Thread starter Sravani Saluru
  • Start date Start date
S

Sravani Saluru

We are happy to announce that, we’ve released an enhanced version of fn_get_audit_file. Now, customers can easily specify their desired time range to retrieve audit logs more efficiently.



The sys.fn_get_audit_file_v2 function in Azure SQL Database is designed to retrieve audit log data with enhanced efficiency compared to its predecessor, sys.fn_get_audit_file. The new function introduces time-based filtering at both the file and record levels, providing significant performance improvements, particularly for queries targeting specific time ranges.



Function Syntax​


sys.fn_get_audit_file_v2 ( file_pattern, initial_file_name, audit_record_offset, start_time, end_time )



for more details, please refer the documentation here: sys.fn_get_audit_file_v2 (Transact-SQL) - SQL Server

Continue reading...
 
Back
Top