Kibana dashboard for hosts status


(A G) #1

Hi,

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?

Thanks,


(CJ Cenizal) #2

Hi there,

You can create a "Data table" visualization with two metrics aggregations:

  1. For the first, choose "Top Hit" aggregation with your timestamp field. For "aggregate with" choose "Concatenate". Sort it on your timestamp field.
  2. 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.

Does this help?

Thanks,
CJ


(A G) #3

Thanks @cjcenizal

That was really helpful and the data table is just as I expected.

Thanks


(system) #4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.