Hi all,
I have different types of timestamps coming into my logstash input from different logfiles xml and log type:
My Configuration for filebeat looks like below:
I have 4 different log files, one of them is as xml file, I have parsed everything by grok in logstash and saved in individual feild (for later visualization in kibana) but I also have the dates of each log file through (Date Filter parsed), every things work fine.
But I have a problem with the date from xml file I can not parse in (Date Filter). on the same Filed (logtime)
can someone help
2018-04-17T15:19:20.313 FC772FA2 CBR FNRCE0000I - INFO binary_recognizer_....
the secend log -> icn & cpe have the same Datestamp format like below:
[6/13/18 5:29:50:575 CEST] 0000006d SystemOut O CIWEB Perf : com.ibm.ecm.configuration....
the third log -> default_XML
<record>
<date>2018-05-31T09:06:28</date>
<millis>1527750388992</millis>
<sequence>825425</sequence>
<logger>com.ibm.es.nuvo.inyo.ingest.DocIngestHandlerMulti</logger>
<level>INFO</level>
<class>com.ibm.es.nuvo.inyo.ingest.DocIngestHandlerMulti</class>
<method>addDocument</method>
<thread>908</thread>
<message>Last document notification received for collection /</message>
according to my configuration the contents of the logtime field? is the dates from all logs type except the log (default xml). i will to pars also this date into logtime field with the others dates so that i can in kibana using logtime filter for all logs type.
Okay, so in the last example you posted logtimeshould contain "2018-05-31T09:06:28" which should be parseable by the date filter you have. Please remove the mutate { remove_field => ["logtime"] } filter and show the raw event produced by Logstash when it's fed an XML document. Copy/paste the text from the JSON tab in Kibana or use a stdout { codec => rubydebug } output.
So the date (2018-05-31T09:06:28) of the XML file is already parsed in logtime but that does not help me if I can't parse it in eventlog where all dates parsed (from the other logs). because eventlog is my datefilter on kibana at the index pattern creating and there I find only the dates from the other logs (p8, icn, cpe). i need to know how i can get this issue, is important (for me ) to go on with the Visualiz on kibana
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.