hello, I would like to know how I can extract the fields from this log, using grok or another way, I've tried with grok but I completely messed up,
the question is how can i separate the fields with the /t delimiter? I even created a
mapping based on this log on how the fields would look.
Timestamp --> Nov 3 21:45:10
Mta_name --> xxx009148
log_type --> msgtra.imss[26101]: NormalTransac
InTimeStamp --> 2022 Nov 3 21:43:35 -03:00
ScanTimeStamp --> 2022/11/03 21:43:35 -03:00
OutTimeStamp --> 2022 Nov 3 21:44:07 -03:00
Message_ID --> 654717088.24251667522701369.xxxx.xxxxx@xxxx.xxx.xxx.xxx.br
Internal_Message_ID --> xxxxx-EC9A-5D05-9E9E-xxxxxx
Postfix_ID --> xxxxx40EF
Scanner_ID --> 1
Sender --> xxxx.xxx.xxxx@xxx.xxxx.xxxx.br
recipient --> recipient1@xxxxxxx.com.br;recipient2@exxxxx.xxx.br
Subject --> *** TESTE/PE - xxxx xxx xxxxxx (Carga:xxxxxx; Veiculo:xxxxx) ***
Client_IP --> xxxx.xx.xx.217
Delivery_IP --> mail.teste.com.br[186.248.133.196]:25
Delivery_feedback --> 250 2.0.0 Ok: queued as 68F676046032F
Delivery_status --> sent
Action --> 00100000000000000
Split_flag --> 0
Extra_Item --> ""
ToDeliveryTimeStamp --> 2022 Nov 3 21:43:35 -03:00
InDeliveryTimeStamp --> 2022 Nov 3 21:43:35 -03:00
and here's a log sample
<135>Nov 3 21:45:10 sf009148 msgtra.imss[26101]: NormalTransac\t2022 Nov 3 21:43:35 -03:00\t2022/11/03 21:43:35 -03:00\t2022 Nov 3 21:44:07 -03:00\t654717088.24251667522701369.JavaMail.fronteiras@sf063693.xxxx.xx.xxxx.br\tDB2BF6D2-xxxxxxxxx-685CE9Axxxxx\tCB66A640EF\t1\xxx.xxxx.fronteiras@xxx.xxxx.xxx.br\xxxxx@expressonxxxxxx.com.br;xxxxio@xxxxxxxuceno.com.br\t*** xxxx/PE - Liberacao de Carga (Carga:xxxx56; Veiculo:xxxxx9) ***\t172.16.12.217\tmail.xxxxxxxmuceno.com.br[186.248.133.196]:25\t250 2.0.0 Ok: queued as 68F676046032F\tsent\t00100000000000000\t0\t\t2022 Nov 3 21:43:35 -03:00\t2022 Nov 3 21:43:35 -03:00\t\t3\t