Here's a problem:
I restore extended events every day. The folders structure look like:
1) ServerName_20210102 -> extended files
2) ServerName_20210103 -> extended files
3) ServerName_20210104 -> extended files
And I want to restore Extended Events for each date. For example: StartDate = 20210101 EndDate = 20210105
So I wanna restore files between these two dates for each date (create table and load data into it). Looks like:
1) First table - ServerName_20210101
2) Second table - ServerName_20210102
3) ETC.
I wondering how to read data from several folders? Using this:
sys.fn_xe_file_target_read_file ( path, mdpath, initial_file_name, initial_offset )
I can setup path only for one folder. Do we have any way to use several pathes in target?