Cybaen13
commented
1 month ago Hi,
Here is what i've done for the global status map:
I forked and modified the whole dashboard with flux queries if interested (the dashboard was not working at all on my instance)
from(bucket: "${bucket}")
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r["_measurement"] == "${hostslist_key}")
|> filter(fn: (r) => r["_field"] == "system-globalstatus")
|> group(columns: ["_field", "system-name"]) // Group by field and system name
|> keep(columns: ["_time", "_value", "system-name"])
|> sort(columns: ["system-name", "_time"], desc: false)
|> aggregateWindow(every:5m, fn:last)
c-stewa20
I have a majority of all the queries working, but can't seem to get the System Overview, Global Status Map, Physical Disks, System Logs to work quite right.
When I import the file, nothing is imported for the queries, so not sure what the grafana setting are for those panels.
Here is the query for the Status Map
from(bucket: v.defaultBucket) |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "idrac-hosts") |> filter(fn: (r) => r["_field"] == "system-globalstatus") |> filter(fn: (r) => r["agent_host"] =~ /${idrac_host:regex}/) |> group(columns: ["_field", "system-name"]) // Group by field and system name |> last() // Get the last value within each group |> keep(columns: ["_time", "_value", "_field", "system-name"]) // Keep only the relevant columns |> yield(name: "last")
In influx Data Explorer it shows
Any help would be appreciated.