Graphs for veeam backup performance aren't using flux queries yet

[trenta]

I've updated to using influxdb v2 which I know works with version 1 queries but you have to set grafana to use flux or not for a data source. So should the queries for the veeam backup performance section also be updated to use flux queries?

[U17205367]

Hello, I modified the graphs so that they work with the new version of influxdb, here is the code that I use for each one of them

CPU

from(bucket: "windows") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r._measurement == "cpu" and r.host == "${host}" and r._field == "usage_idle" and r.cpu == "cpu-total") |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false) |> pivot(rowKey: ["_time"], columnKey: ["_field"], valueColumn: "_value") |> map(fn: (r) => ({r: r.usage_idle * -1.0 + 100.0}))

Memory

from(bucket: "windows") |> range(start: v.timeRangeStart) |> filter(fn: (r) => r.host == "${host}") |> filter(fn: (r) => r._measurement == "mem") |> filter(fn: (r) => r._field == "used") |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false) |> yield(name: "mean")

Uptime

from(bucket: v.defaultBucket) |> range(start: v.timeRangeStart, stop:v.timeRangeStop) |> filter(fn: (r) => r.host =~ /${host}/ and r._measurement == "system" and r._field == "uptime") |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false) |> yield(name: "last")

Network

QueryA from(bucket: "windows") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "net") |> filter(fn: (r) => r.host == "${host}" and r.interface =~ /.*$/) |> filter(fn: (r) => r["_field"] == "bytes_recv") |> derivative(unit: 1s, nonNegative: true) |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false) |> yield(name: "mean")

QueryB from(bucket: "windows") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "net") |> filter(fn: (r) => r.host == "${host}" and r.interface =~ /.*$/) |> filter(fn: (r) => r["_field"] == "bytes_sent") |> derivative(unit: 1s, nonNegative: true) |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false) |> yield(name: "mean")

Disk

from(bucket: "windows") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "disk") |> filter(fn: (r) => r.host == "${host}") |> filter(fn: (r) => r["_field"] == "used_percent") |> filter(fn: (r) => r["device"] == "C:") |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false) |> yield(name: "last")