title: Building A Remote Desktop Manager Cluster List link: http://sev17.com/2010/06/30/building-a-remote-desktop-manager-cluster-list/ author: Chad Miller description: post_id: 10363 created: 2010/06/30 16:37:29 created_gmt: 2010/06/30 20:37:29 comment_status: open post_name: building-a-remote-desktop-manager-cluster-list status: publish post_type: post
Building A Remote Desktop Manager Cluster List
The Microsoft Clustering and High Availablity bloggers have taken noticed of the Remote Desktop Connection Manager (RDCMan) utility from a cluster management perspective. I’ve previously blogged about Building A Remote Desktop Manager Connection List from the SQL Server Central Management Server (CMS) tables. The RDCMan use case for cluster administration is very useful and it just so happens that I built a similar solution for cluster servers. So, as a follow up here’s a way to auto generate an RDCMan file from a list of clusters, nodes and virtuals. First create and populate a cluster, cluster_node and cluster_virtual tables defined in the following T-SQL script file: Note: You’ll need to insert your cluster information into the three tables. Next use the following T-SQL XQuery to generate the RDCMan XML and save the file as cluster.rdg. Finally open the cluster.rdg file in Remote Desktop Connection Manager. RDCMan allows to you to have multiple rdg files open at one time which means our previous CMS-based list of SQL Server and our cluster-based list can both be used simultaneously. Enjoy!