Parameter/drop down list

[addyb77]

Hi all

I am creating a dashboard to show relevant sql server info for admin and info purposes. I have multiple queries which are identical apart from the servername of the data connection itself.

Currently i have 3 servers listed under tables which display the following columns:

Table 1 (query 1)

Server              Domain           IP Address

My Server 1     MyDomain       x.x.x.x

Table 2 (query 2)

Server              Domain          IP Address

My Server 2     MyDomain     x.x.x.x

Table 3 (query 3)

Server              Domain          IP Address

My Server 3     MyDomain     x.x.x.x

What i want to do is have a drop down list/slicer of all the server names so when i select one it will just the relevant ip address etc for that server in one table instead of it being split across multiple tables. Im not sure how i go about this.

[Anonymous · Accepted solution]

Use the Query Editor to "Append" these into one query.

[addyb77]

Thank you i hadnt spotted that. That does the trick.