# List of hosts status in Grafana table view **URL:** \ **Category:** Dashboards\ **Tags:** telegraf, grafana, influxql\ **Created:** [November 7, 2017, 10:36am UTC](https://community.influxdata.com/t/list-of-hosts-status-in-grafana-table-view/3002 "2017-11-07T10:36:43Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![geo](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/geo/32/1873_2.png) [@geo](https://community.influxdata.com/u/geo)\ **Post date:** [November 7, 2017, 10:36am UTC](https://community.influxdata.com/t/list-of-hosts-status-in-grafana-table-view/3002/1 "2017-11-07T10:36:43Z")
Hi. Currently I’m trying todo smth that is done in Chronograf “Host List”. So, to have a list of hosts and it’s status even if machine is down and there is no data into some measurements(let say `system`) still show the host and maybe set some status. Now, a query like this works ok: `SELECT last("usage_idle") * -1 + 100 as "cpu_usage" FROM "cpu" WHERE ("cpu" = 'cpu-total') AND time > now() - 1m GROUP BY host` But when there will be no data host will not be shown. I guess I need to combine 2 queries, first run smth like this: `SHOW TAG VALUES FROM /win_system|system/ WITH KEY = "host"` and after that combine this with the above query to have what I need, but not sure yet. Is this possible, can anyone guide me into right direction? Thx a lot! ---
**Author:** ![fchiorascu](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/fchiorascu/32/995_2.png) [@fchiorascu](https://community.influxdata.com/u/fchiorascu)\ **Post date:** [January 6, 2018, 10:12am UTC](https://community.influxdata.com/t/list-of-hosts-status-in-grafana-table-view/3002/2 "2018-01-06T10:12:56Z")
**The same thing here, trying to find a way on Internet.** Hi, My configuration is based on: Telegraf + InfluxDB + Grafana, I’m not using Kapacitor, Cronograf. For this notification aspect is a way to have in Grafana if I’m not using Kapacitor, Cronograf? [Server side] telegraf-1.5.0-1.x86\_64 grafana-4.6.3-1.x86\_64 influxdb-1.4.2-1.x86\_64 I’m trying something like in Nagios | Centreon, to have on home page all Services that are in WARNING/ CRITICAL status, somehow a filtering in order to see only the problems. It is feasible/ possible to have on the same Dashboard(with template or without template) where you have the services KPIs a top row where you can have some notifications panels (singlestat, etc) where you can see the services in WARNING/ CRITICAL status? Or is needed to have a separate Dashboard for this? Any recommendation or docs for this, really appreciated. Kind Regards, ---
**Author:** ![fchiorascu](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/fchiorascu/32/995_2.png) [@fchiorascu](https://community.influxdata.com/u/fchiorascu)\ **Post date:** [January 6, 2018, 5:09pm UTC](https://community.influxdata.com/t/list-of-hosts-status-in-grafana-table-view/3002/3 "2018-01-06T17:09:35Z")
For what you try I think there is another way to do this. In my case is more complex but maybe what I’ve put below will help you. Config: ![image](https://us1.discourse-cdn.com/flex023/uploads/influxdata/original/1X/18b1122a61b429decdec80bddde041a140ff23b9.png) Result: ![image](https://us1.discourse-cdn.com/flex023/uploads/influxdata/original/1X/20f18b1692ad34965f5aa1a306d58a26ac1da10d.png) ---
**Author:** ![fchiorascu](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/fchiorascu/32/995_2.png) [@fchiorascu](https://community.influxdata.com/u/fchiorascu)\ **Post date:** [January 6, 2018, 5:10pm UTC](https://community.influxdata.com/t/list-of-hosts-status-in-grafana-table-view/3002/4 "2018-01-06T17:10:57Z")
I think this way will fit the best. ![image](https://us1.discourse-cdn.com/flex023/uploads/influxdata/original/1X/0fc38fa515b9c109a66703f3f1dd36a61d37b400.png) ![image](https://us1.discourse-cdn.com/flex023/uploads/influxdata/original/1X/9eb30e167f2e79f151b6103f2d205f1c1bfe0d60.png) ---
**Author:** ![geo](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/geo/32/1873_2.png) [@geo](https://community.influxdata.com/u/geo)\ **Post date:** [January 9, 2018, 2:46pm UTC](https://community.influxdata.com/t/list-of-hosts-status-in-grafana-table-view/3002/5 "2018-01-09T14:46:39Z")
Hi, Few questions about your solution: 1. It’s possible to show the nodes in a separate column? I also want to be able to click on specific node and check mode details, I did it like like this: ![50 PM](https://us1.discourse-cdn.com/flex023/uploads/influxdata/original/1X/5853886861165f551d3e9e5e59b29dee081bca45.png) 1. In case that you don’t have any data from one node, is it still working? You will have 0 or N/A for SPU usage? Thx. ---
**Author:** ![fchiorascu](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/fchiorascu/32/995_2.png) [@fchiorascu](https://community.influxdata.com/u/fchiorascu)\ **Post date:** [January 9, 2018, 8:18pm UTC](https://community.influxdata.com/t/list-of-hosts-status-in-grafana-table-view/3002/6 "2018-01-09T20:18:09Z")
Hi Geo, I’ll respond to your question, I’m not sure that will fit your needs because I didn’t understand exactly what you need to obtain as a final request, it will be great if you detail a little bit the needs. After I’ve stopped telegraf on VM. 1). Please detail. 2). In my case I use a Dashboard for multiple servers and I have used “panel”: Singlestat, Graph in most of the cases like in the picture below. - On panel singlestat i will have N/A. ![image](https://us1.discourse-cdn.com/flex023/uploads/influxdata/original/1X/7ba8b3f76a07af6c65529579a2790468771a1321.png) - On panel Graph I will have no data like below. ![image](https://us1.discourse-cdn.com/flex023/uploads/influxdata/original/1X/037e346355c57896d6e765d0ca9d4075021258fc.png) Kind Regards,