mimni
2 months ago
254
1
Servers

AWS cloudwatch log insights parse

Posted 2 months ago by mimni

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 !

Please sign in or create an account to participate in this conversation.