I am sure that this has been asked a number of times and from my review of the previous posts nothing seems to be helping me solve my problem.
My JSON has separate date and time fields.
I'm creating an 'eventTime' field in order to combine the date and time into a single reference.
mutate {
add_field => {"eventTime" => "%{Date} %{Time}"}
I'm then matching the eventTime to the correct format and assigning it to the @timestamp field.
date {
match => ["eventTime", "yyyy-mm-dd HH:mm:ss"]
#match => ["Time", "MM/dd/yyyy HH:mm:ss"]
timezone => "America/Chicago"
target => "@timestamp"
}
I am beyond my _dateparsefailure issues but the eventTime is not matching that of @zikakou1er
"eventTime" => "2017-05-09 00:05:08",
"@timestamp" => 2017-01-09T06:05:08.000Z,
"Time" => "00:05:08",
"Date" => "2017-05-09",
I am sure it is something easy that I am just missing but can't seem to get passed my mental block.
Any suggestions would be appreciated.
Thanks in advance.