Is it possible to create a master-panel to show if there is any problem with a machine?

Grafana Dashboards
,
1

Hello fellow Grafana community,

I monitor several machines via Icinga and have set up a Grafana dashboard for each machine using InfluxDB with Flux language as data source. For Grafana, I use the current version of the Docker Container.

My question now is whether I can create a panel so that I can directly see in only this one whether any metric exceeds its limits or not? And what would be the best way to implement this? The goal is to have a dashboard where all these “master panels” are, so that you can see directly which machine is causing problems.

Kind regards
Alex

2

Could you please post the ‘schema’ of the bucket you save this data in?

3

Hi, I am relatively new to Influx. How exactly do I get the scheme? InfluxDB is also running in a Docker container and when I use the API (as described here Manage bucket schemas in InfluxDB | InfluxDB Cloud (TSM) Documentation), for example, I only get error “404 page not found” as a response.

4

Can you show us the flux query?

5

Of course, the query looks like this:

from(bucket: "icinga")
    |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
    |> filter(fn: (r) => r._measurement == "service-windows")
    |> filter(fn: (r) => r._field == "state")
    |> filter(fn: (r) => (r.hostname == "xy") and ((r.service == "a") or (r.service == "b")))
    |> last()
    |> group()
    |> reduce(fn: (r, accumulator) => ({sum: r._value + accumulator.sum}), identity: {sum: 0})
    |> yield()