My first post here, so apologies if this isn’t the right area!
I am setting up a Grafana dashboard for a lot of clusters, and i’m getting pretty bored of adding the same query 20 times for different host names! (I’m new to Grafana so now realise this is not the best way, especially for alerting on every query!!!)
I have set a custom multi-variable in the dashboard settings called $variablename for example, in which contains some server names, (servername01,servername02).
Im using the below query:
SELECT mean("Percent_Free_Space") FROM "win_disk" WHERE ("host" = '$variablename' AND "instance" = 'C:') AND $timeFilter GROUP BY time($__interval) fill(null)
I have selected all the servernames at the top of the dashboard, however its only outputting the one server (first one in the variable). I have also turned on panel repeating for the variable also.
I know its going to be something wrong with my query, and something silly! - Can anyone point me in the right direction with this one?
I’m new to Grafana so apologies if i’ve missed something very obvious!
Thanks in advance!