When I am importing data to logstash it does not handle the data/Time correctly
It shows time Dec 2, 2019 @ 21:09:29.000
when it should show 2019/12/03 05:09:29
Message in Kibana
tmessage 2019/12/03 05:09:29,95,MP Member Policies,200,OK,View Current Policy 7-1,true,5556,1,23,https://Statements=true-GetSisDetails=true-PolicyType=,94,SERVERNAME,0,14
Raw Data
2019/12/03 05:09:29,95,MP Member Policies,200,OK,View Current Policy 7-1,true,5556,1,23,https://Statements=true-GetSisDetails=true-PolicyType=,94,SERVERNAME,0,14
filter {
csv {
columns => ["time","elapsed","label","responseCode","responseMessage","threadName","success","bytes","grpThreads","allThreads","url","latency","Hostname","IdleTime","Connect"]
}
#Logstash date config section
date {
match => ["time","yyyy/MM/dd HH:mm:ss"]
target => "time"
}
Can any one help with this?