Hello everyone, Thanks for your time:
I am using Grafana V5.1.0.
up{host=“10.0.0.1”, instance=“xxx”} up{host=“10.0.0.2”, instance=“xxx”}
Assume i have a variable named hosts such as label_values(up, host), the value return is:
==> “10.0.0.1”,“10.0.0.2”
Now i wanna use this in my SQL script:
==> select ip from ip_table where ip not in (“10.0.0.1”,“10.0.0.2”)
I tried to use “ALL” option for my hosts, it works.
Questions is:
How can i set it to “ALL” default and forever,?
Because i will hide this variable and do not allow it to be not ALL.
Or is it possible for me to format the list of label_values(up, host) into one variable (“10.0.0.1”,“10.0.0.2”)?
Because i don’t need one single value of this list, i need all of them.
I checked the glob/regex/pipe/csv/lucene in “Advanced Formatting Options”.
But i can not find the right way.
