Comment on Grafana, Influxdb and Flux - issues with Dashboards

<- View Parent
Haui@discuss.tchncs.de ⁨1⁩ ⁨year⁩ ago

Thanks for answering so fast! :)

I’m not deep enough to know if telegraf can do this. It has “plugins” that work okayish. Not a lot to configure. I suppose I could start going into the nitty gritty but I would abolutely love to avoid it. I have like 10+ services running on my server and I can’t go this deep without an IT team and with a job. :)

In this special case, it is uptime I’m after and influxdb throws a table at me that looks like this:

Image

then I use this to get the data into grafana:

from(bucket: "telegraf")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "system")
  |> filter(fn: (r) => r["_field"] == "uptime_format")
  |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)
  |> yield(name: "last")

And what turns up is this:

Image

Now, having worked with SQL before, there is a way to just show the “2 days, 18:02” bit instead of two values and without manually selecting the host each time in SQL, I just don’t know how to do it in flux.

I hope this makes sense. Have a good one. :)

source
Sort:hotnewtop