Efficient Time-Based Audit Log Filtering for Azure SQL Database

[Guest Sravani Saluru]

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

 

 

 

The [iCODE]sys.fn_get_audit_file_v2[/iCODE] function in Azure SQL Database is designed to retrieve audit log data with enhanced efficiency compared to its predecessor, [iCODE]sys.fn_get_audit_file[/iCODE]. 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.

 

 

 

[HEADING=1]Function Syntax[/HEADING]

 

[iCODE]sys.fn_get_audit_file_v2 ( file_pattern, initial_file_name, audit_record_offset, start_time, end_time )[/iCODE]

 

 

 

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

 

Continue reading...