I am trying to extract log line using custom log integration fleet agent, It's a single event but every event is seperate.
<SQL > <TrID: aergaerfertferfewrfwerwewf:0011064> <TID: 6546546464> <RPC ID: 0001135907> <Queue: List > <Client-RPC: 390620 > <USER: Application Service > <Overlay-Group: 1 > /* Tue Oct 08 2024 08:48:16.5360 / BEGIN TRANSACTION
<SQL > <TrID: aergaerfertferfewrfwerwewf:0011064> <TID: 6546546464> <RPC ID: 0001135907> <Queue: List > <Client-RPC: 390620 > <USER: Application Service > <Overlay-Group: 1 > / Tue Oct 08 2024 08:48:16.5370 */ SELECT * from table
<SQL > <TrID: aergaerfertferfewrfwerwewf:0011064> <TID: 6546546464> <RPC ID: 0001135907> <Queue: List > <Client-RPC: 390620 > <USER: Application Service > <Overlay-Group: 1 > /* Tue Oct 08 2024 08:48:16.5380 / OK
<SQL > <TrID: aergaerfertferfewrfwerwewf:0011064> <TID: 6546546464> <RPC ID: 0001135907> <Queue: List > <Client-RPC: 390620 > <USER: Application Service > <Overlay-Group: 1 > / Tue Oct 08 2024 08:48:16.5380 / No. of records retrieved=0
<SQL > <TrID: aergaerfertferfewrfwerwewf:0011064> <TID: 6546546464> <RPC ID: 0001135907> <Queue: List > <Client-RPC: 390620 > <USER: Application Service > <Overlay-Group: 1 > / Tue Oct 08 2024 08:48:16.5380 */ COMMIT TRANSACTION
but couldn't find how to do this , Is it possible to parse as single event
Is it possible to be look like below log as single event after processing
<SQL > <TrID: aergaerfertferfewrfwerwewf:0011064> <TID: 6546546464> <RPC ID: 0001135907> <Queue: List > <Client-RPC: 390620 > <USER: Application Service > <Overlay-Group: 1 > /* Tue Oct 08 2024 08:48:16.5360 / BEGIN TRANSACTION
SELECT * from table
OK
No. of records retrieved=0
COMMIT TRANSACTINON