I am using telegraf from 3 nodes to send data to influxdb2.
I have setup a deadman check called
uptime which triggers to level
crit for a host if it is down for more than 10 min.
I am trying to create a table of all the hosts that are off (in state
crit) and ma using this query
from(bucket: "_monitoring") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_check_name"] == "uptime") |> last() |> filter(fn: (r) => r["_level"] == "crit")
However each line of output has its own table ID.
Any suggestions on how I can go about doing this or if there is some sort of template or other mechanism to achieve this would be very helpful.