Often I have to run same query against multiple Servers for analysis and club all results for presentation. I come across simple option which allows to do it all in one go…
• View Registered Servers (Ctrl+Alt+G)
• Create new Server Group
• Register New Servers
• Add new Serves, you may change the Registered server name with user friendly name.
• You may add multiple Servers to the same group and Initiate new query at Server level
• You will see the number of Servers connected and execute the Query against all servers in one go
Query results will be appended with one additional column, Server Name.