Comment on Grafana, Influxdb and Flux - issues with Dashboards

thelastknowngod@lemm.ee ⁨1⁩ ⁨year⁩ ago

• 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

  • beaumains@programming.dev ⁨1⁩ ⁨year⁩ ago

    You don’t do it in flux, you do it in the panel options in Grafana.

    On your original question you can set the Telegraf hostname in the config, for docker stuff I just use omit_hostname = true

    source

    • Haui@discuss.tchncs.de ⁨1⁩ ⁨year⁩ ago

      Okay! Thanks for explaining! Thats very helpful.

      source