Case Sensitive HOSTS?


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?

ok to get round this within telegraf.conf I have added thanks to the InfluxDB peeps the following that forces all tag values to be pushed into influxdb with uppercase:
## Convert a tag value to uppercase
tag = “*”

1 Like

nice little workaround!