, ( SELECT remoteDesktop AS FOR XML PATH ( 'remoteDesktop' ), TYPE ) , ( SELECT gatewaySettings AS FOR XML PATH ( 'gatewaySettings' ), TYPE ) , ( SELECT connectionSettings AS FOR XML PATH ( 'connectionSettings' ), TYPE ) , ( SELECT logonCredentials AS FOR XML PATH ( 'logonCredentials' ), TYPE )
sysmanagement_shared_registered_servers_internal ) SUBSTRING (name, 1, (PATINDEX ( '%,%' ,name ) - 1 ) )įROM msdb. SUBSTRING (name, 1, (PATINDEX ( '% \%' ,name ) - 1 ) ) The following T-SQL query creates an RDCMan XML file from CMS servers and groups. The same servers and groups in your CMS will be represented in the resulting RDCMan file:įROM msdb. Because the CMS data is already in SQL Server tables it’s easier to use a T-SQL approach to shape the XML. The approach Jan takes builds an RDCMan file from the computers in Active Directory using PowerShell which isn’t quite what I want, but it gives me an idea on using T-SQL/XQuery…Īs a SQL Server DBA I maintain a list of SQL Servers and groups in a Central Management Server or CMS. A CMS is not only useful for maintaining a central list of SQL Servers, driving Policy Based Managment, and executing multi-server queries but can also be used as input for other things including building an RDCMan file. A quick web search turns up a post by Jan Egil Ring titled Dynamic Remote Desktop Connection Manager connection list. Fortunately the XML file called an RDCMan file used for the connection list in RDCMan is a simple structure you can build yourself. If you’re connecting to multiple remote desktop sessions, RDCMan is a tool worth looking into.īecause my environment has hundreds of servers, one of the things I look for in management tools is a method to import an existing list of servers. The functionality provided by RDCMan is above and beyond what you’ll find in the built-in Remote Desktop MMC and comparable to other 3rd party Remote Desktop utilities. Remote Desktop Connection Manager or RDCMan is a free download from Microsoft for managing multiple remote desktop connections.
0 kommentar(er)
