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

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

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

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.

Can you show us the flux query?

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()