Getting to work with influx v2.7.4 flux queries

[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.

[Cybaen13]

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 would very much be interested in the whole dashboard.

[Cybaen13]

I would very much be interested in the whole dashboard.

https://grafana.com/grafana/dashboards/21915-idrac-host-stats/
Regards