Strange issue. I have created a dashboard that will grab the drive space on a SQL server and drop it into a panel. I used a multi-value variable (SHOW TAG VALUES WITH KEY = “sql_instance”) to grab just SQL servers, and the query for the panel uses that variable name to grab the disk usage from InfluxDB.
The problem I am running into is SHOW TAG VALUES WITH KEY = “sql_instance” returns everything in all caps, but another variable on another dashboard returns the name as it appears in Windows.
SHOW TAG VALUES WITH KEY = “sql_instance” will return DEMOSRV1
SHOW TAG VALUES FROM “win_system” WITH KEY = “host” will return DemoSrv1
I cannot figure out how to link these 2 so that I can use the sql_instance name and pull that data from the host name.