My Index has three fields Host name, Host status & time stamp and these values gets updated every 60 secs. I would like to build a dashboard to show the current status of all of my hosts in one dashboard. Can someone help me how to do this in Kibana?
You can create a "Data table" visualization with two metrics aggregations:
For the first, choose "Top Hit" aggregation with your timestamp field. For "aggregate with" choose "Concatenate". Sort it on your timestamp field.
For the second, choose "Top Hit" aggregation with your host status field. For "aggregate with" choose "Concatenate". Sort it on your timestamp field.
Then create a bucket "Terms" aggregation with your host name as the field. The resulting visualization will show you a table with columns for status, time stamp (with the most recent selected), and status.
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.