I am trying to track file transfers from one location to another. Flow: Files are copied to File copy location -> Target Location Both File copy location and Target location logs are in the same index but each has it own sourcetype. File copy location events has logs for each file but Target location has a logs which has multiple files names. Log format of filecopy location: 2024-12-18 17:02:50 , file_name="XYZ.csv", file copy success 2024-12-18 17:02:58, file_name="ABC.zip", file copy success 2024-12-18 17:03:38, file_name="123.docx", file copy success 2024-12-18 18:06:19, file_name="143.docx", file copy success Log format of Target Location: 2024-12-18 17:30:10 <FileTransfer status="success> <FileName>XYZ.csv</FileName> <FileName>ABC.zip</FileName> <FileName>123.docx</FileName> </FileTransfer> Desired result: File Name FileCopyLocation Target Location XYZ.csv 2024-12-18 17:02:50 2024-12-18 17:30:10 ABC.zip 2024-12-18 17:02:58 2024-12-18 17:30:10 123.docx 2024-12-18 17:03:38 2024-12-18 17:30:10 143.docx 2024-12-18 18:06:19 Pending Since events are in the same index and more events I do not want use join.
... View more