NXLOG - csv field need to parse on date format - how to convert 10Nov2016 to YYYY-MM-DD
Hello,
I'm catching up logs, but when they arrived to my Graylog, they take the actual date and not the old date.
I saw my logs and they don't have format date. They're csv, and I have this field :
FW_date_time:10Nov2016;21:40:10
and I need to assign it on the timestamp, but I don't kno how.
Could you help me please to convert this on a good format?
I tried this (I have a field called: FW_date_time on my source csv file):
Exec FW->parse_csv();
Exec $EventReceivedTime =strptime($FW_date_time, '%Y %b %d %T');
Exec $EventTime =strptime($FW_date_time, '%Y %b %d %T');
But it didn't work.
Thank you very much for your help.
Cordially,
Ana
Hello,
I'm catching up logs, but when they arrived to my Graylog, they take the actual date and not the old date.
I saw my logs and they don't have format date. They're csv, and I have this field :
FW_date_time:10Nov2016;21:40:10
and I need to assign it on the timestamp, but I don't kno how.
Could you help me please to convert this on a good format?
I tried this (I have a field called: FW_date_time on my source csv file):
Exec FW->parse_csv();
Exec $EventReceivedTime =strptime($FW_date_time, '%Y %b %d %T');
Exec $EventTime =strptime($FW_date_time, '%Y %b %d %T');
But it didn't work.
Thank you very much for your help.
Cordially,
Ana
You need to provide the correct format to strptime() that matches 10Nov2016;21:40:10.