Hi All,
I have a csv log file with column names and a sample record as
access_date,clientIP,Col1, Col2, Col3, Col4_uri_path, col5_referrer,col6_response, col7_hit_count,col8_referrer
'13/Jan/2016:22:57:38','111.222.333.444','String1','String2','String3,
optional_substring4','substring5/substring6/substring7/substring8','','200','1',''
My grok filter is
grok {
match => { "message" => "%{MONTHDAY}/%{MONTH}/%{YEAR}:%{TIME} %{IPORHOST:clientip} %``{NOTSPACE:Col1} %{NOTSPACE:Col2} %{NOTSPACE:Col3} %{URIPATHPARAM:Col4_uri_path} %``{QS:Col5_referrer} %{NUMBER:Col6_response} %{NUMBER:Col7_hit_count} %{QS:col8_referrer}" }
}
I get a [0] "_grokparsefailure" error. Could you please help me with the pattern?
Thank you for all the help.
Best regards,