Parsing log content

[goutham_a]

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

[StrangerThing · Accepted solution]

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'

[goutham_a]

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