Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

mimi0110's avatar

AWS cloudwatch log insights parse

Hi guys ! I have an issue related to AWS cloudwatch log, maybe it not related to laravel or server but please forgive me .

I have log @message like this format :


2020-08-18T09:57:57.798985Z 4 Query set local oscar_local_only_replica_host_status=0
2020-08-18T09:57:45.062390Z 4 Query SELECT @@aurora_version
2020-08-18T09:56:57.735404Z 4 Query set local oscar_local_only_replica_host_status=0

https://imgur.com/Xakdxik

I want to parse above message to seperate some variable like : time, number, query

As I do in ussual, but it not work:

filter @message like /(Query)/
 | parse "*Z * Query *" as time, number, query

result: https://imgur.com/IVNbyvx

=> not work Can anybody help me please !

0 likes
1 reply
mimi0110's avatar
mimi0110
OP
Best Answer
Level 1

OMG ! Find out by myseft

parse @message '*Z*Query' as time, number, query

Please or to participate in this conversation.