Modify TSQL script

I setup SQL audit and dumping data into this location: O:\Audit\Data1. Now I need to load data into SQL table, AuditInfo. I need to run the following query in SQL job everyday.

The following script works fine. Modification needed, so when it runs every day, it will load only the previous day data into SQL table.

SELECT distinct *

FROM sys.fn_get_audit_file('O:\Audit\Data1\*.*', DEFAULT, DEFAULT)

INSERT INTO Test.[dbo].[AuditInfo] (

event_time

,action_id

,server_principal_name

,server_instance_name

,database_name

,schema_name

,object_name

,statement

)

SELECT event_time

,action_id

,server_principal_name

,server_instance_name

,database_name

,schema_name

,object_name

,statement

FROM sys.fn_get_audit_file('O:\Audit\Data1\*.*', DEFAULT, DEFAULT)

I need to modify this query, so the records that were inserted yesterday will be loaded into the SQL table

For example:

If I run the job 02/03/2020 at 9 pm the records on 02/02/2020 will be loaded

02/04/2020 at 9 pm the records on 02/03/2020 will be loaded

02/05/2020 at 9 pm the records on 02/04/2020 will be loaded

SQL MySQL Microsoft SQL Server PHP Software Architecture

Project ID: #23880342

About the project