If you are a SQL Server database administrator (DBA) who also has need to administer servers via Remote Desktop, this script will be of tremendous help to you at least once, and may be something you run regularly.
Get the script at:
Prerequisites:
Have populated a SQL Server Central Management Server (CMS) with at least one group and server
To use, run the script against the instance holding your CMS data.
Click on the link to the XML. Select All and Copy:
Create a new text file with the extension *.rdg (for example MyCMSServers.rdg) Paste the XML content:
In Remote Desktop Connection Manager, File->Open the *.rdg file
Details:
All unique host names are placed under a group called '_All Servers'. The 'Smart Lists' dynamically filter based on the groups in your SQL CMS. This is done by placing a comment in the RDCMan node for each server.
The script doesn't yet generate hierarchical groups in RDCMan. Keep an eye out for edge cases that I haven't tested yet: special characters in the server or group names, hosts that are found in more than one group, etc.
Get the script at:
Hope you enjoy!
