Hi All, I have some raw message have been parsed with below fields:
EventID:
EventTime:
Hostname:
Message:
Kibana index name begins with logstash-xxx.
The question is now I am using Kibana 4.5.0 and visualize my data with Metric and Data Table. I can easily filtered my data with EventID say 676 and shows total counts in Metric is correct. But the question is that it has a wrong count show in Data Table. An example is just like below:
Enable Filter: EventID:676
Metric View
1141 <-- This is correct number of entries.
Data Table
EveintID.raw Message.raw Count
676 Some message 323 <-- (only 323 showed but total count is 1141)
I have tried not to use Message.raw field and it shows correct count 1141. I tried to review the log in Discovery view, it show that was parsed successfully in message field. Seems parsing has no problem but the data view exist missing counts in Data Table.
Based on your example it looks like the data table is grouping events by their raw Message, meaning that the count 323 is simply the number of events with EventID 676 and the same message. What if you add a filter for the message.raw too, does the metric view match then?
But now there is another question. As below screen shows, I have many event ID. If I enable the filter for EventID 675, total logs is 593. The log and message showed correctly in the Data Table. While I enable the filter Event ID 673, total count is 1171 but no message can show out. I go the Discover tab and search the log with EventId 673, the message field contains the message in message filed, seems has been parsed with no problem. Appreciate you help.
Hi, when you are filtering on EventID = 673, could you click the little ^ at the bottom of the MSG visualization panel? This will bring up a spy panel which has useful debugging information. In this spy panel, please click the Request button. This will show the request being sent to Elasticsearch. Please paste this request over here so we can debug further. Thanks!
As it is using dynamic mapping , and the default behaviors of ES that query from Message field is not allowed. And It return successful eventID 675 with the same request from Message.raw. Is there any misconfiguration or praising issue I made or it is the fault of ES?
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.