I’m also very new to grafana templating and have a quite similar question, so hopefully both can be answered here.
I have installed telegraf on several servers including some running Windows. I have a “Detailed Server” dashboard using a template variable to determine the server names, but I want to restrict to only those submitting “win_cpu” measurements (i.e. the Windows boxes), and have another template variable to determine the non-Windows boxes (e.g. submitting “cpu” measurements).
I thought there should be a way to define the template variable as:
show tag values with key = “host” where “measurement” = “win_cpu”
(but this doesn’t work). I’m sure this is something trivial I’m not understanding about the query syntax.