Grafana Variable SQL Server Stored Procedure

Hi All,

Just wondered if there were any known limitations with a variable in grafana such as $hosts which executes a stored procedure against and sql server db datasource?

so I have $appname as an exsiting Var

I want to execute
… exec getserver ‘$appname’ …
to return the machines in the drop down for my guy. I keep getting a massive list of machines which don’t seem to match. Just wanted to check that this functionality does work and it is my query/proc which is the issue.

Many Thanks in advance