Hello,
I have setup Grafana Dashboard with a custom list of windows hosts within the variables, my problem is that the HOSTS can be either uppercase or lowercase so when setting the variable I have to put in both Upper and Lowercase versions - this is a bit messy as on the dropdown it shows both and 1 does not work, how can i get around this?
The custom list is
server1,server2,server3 etc
I cant see where i can change this to be case insensitive
piped query for data
from(bucket: “bucket”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r["_measurement"] == “sql_cpu”)
|> filter(fn: (r) => r[“host”] =~ /${comp:pipe}/)
|> filter(fn: (r) => r["_field"] == “Percent_Processor_Time” or r["_field"] == “Percent_User_Time” or r["_field"] == “Percent_Privileged_Time”)
|> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
|> yield(name: “mean”)
Has anyone got any ideas to get around this issue?