Advanced placeholder for SQL Query servername

1

3 years ago

Kristian

open0

We currently provide 1 service, with 2 questions for deploying new MSSQL databases.
In the first question we query an hardcoded SQL Instance and database, for all entries in that given table – the list of all MSSQL servers, that the enduser can use.
So the user might select MSSQL1 as the server.

Now i want to execute an MSSQL query on that MSSQL server, but it seems, i can only use the “Advanced placeholder” in my query – not the actual server.

Basically i want this query “SELECT name from master.sys.server_principals WHERE name NOT LIKE ‘##%’ AND name NOT LIKE ‘NT %'” to be executed on the MSSQL server, that the user selected in the first question.

Related Ideas

Hide Au2mator groups

declined2 years agoHi, We would like an global feature, to hide the Au2mator AD groups used for restricting our Au2mator services. Within the next 6 months, we would...Read more

Control LDAP question query more

open2 years agoCurrently the LDAP query lookup is tied to the fields that are displayed. The user cannot search using other values that are not displayed. It would...Read more

SQL Question result usable in other questions

completed2 years agoA SQL question can allow a user to select a row that have multiple columns. It would be helpful to allow this column data to be available to other qu...Read more