topic Re: Parsing log content in DQL

Parsing log content

goutham_a — Mon, 03 Feb 2025 15:11:33 GMT

Hi,

I am trying to parse this log content and get the response time, Can anyone please help with the DQL? Thanks in advance.

2025-01-29 19:32:07 ebafc69c-9f9b-4984-bd9e-9d22e5ef2246 -1234dd56:123456789ww:-1234::1234567812 NA NA NA APP service NA NA NA txnlog - https://xyz.com/oauth2/token - 200 - 187.281msec

Re: Parsing log content

StrangerThing — Mon, 03 Feb 2025 15:45:57 GMT

TIMESTAMP:timestamp SPACE
LD:UID SPACE
LD:x SPACE
LD:a SPACE
LD:b SPACE
LD:c SPACE
LD:app SPACE
LD:service SPACE
LD:d SPACE
LD:e SPACE
LD:f SPACE
LD:txnlog SPACE
'-' SPACE
LD:endpoint SPACE
'-' SPACE
LD:http_status SPACE
'-' SPACE
DOUBLE:duration 'msec'

Re: Parsing log content

goutham_a — Mon, 03 Feb 2025 20:37:57 GMT

Thanks, the query works. Can you also help with converting the duration to seconds