How to create an RGD file with multiple server Names and IP address QUICKLY?

When you have the list of Server name and IP address, there is an easy way of creating an RDG with the list of those.

The below Script helps in creating an RDG file, but you will end up having the Server name and Display name both as an IP address

Build an RDCMan

Issues with this approach:

  1. It's not intuitive to read a server by IP(it's impossible to remember individual server IP)
  2. You will have to manually update the server name one by one for all the servers in the list

So I was creating an RDG file for 35 odd servers and the script helped me to quickly create an RDG file, but I ended up wasting a lot of time in changing the server name individually.

I spent a couple of hours (some more ) modifying the script to accept CSV file and create an RDG file out of it.

But I was not able to completely finish it as there was a lot of variables, Type casting to [XML], Ifs and buts … etc.

There got to be an easy way !!!

Thinking about it, RDG was actually an XML configuration file. A powerful tool we have to edit EML file is ….. Yes ! You got it EXCEL.

Below is the easy way to create an RDG file with the list of given Server name and IP address.

Step 1 

Create a blank RDG file(hopefully by now you have already downloaded RDC Manager, if not download and install it).

Note: You can use any old RDG file if you have

Step 2

Open RDG file in Excelopen-file

Say Yes when you see the prompt since we know it is our file

say-yes

Select the third option that says

"Use XML Source task pane"

Click on Ok on the next dialog as well

say-ok

Step 3

On the right plane click on "displayName"   drag and drop it to a column header. Repeat the same thing for "name" as shown in the figure.

displayname-and-ip-address

We are almost close!!

Step 4

Paste the name and display name and IP address of the servers to be connected as shown in the Image below.

paste-the-name-and-display-name-of-the-servers-to-be-connected

Step 5

Now Export this by right clicking on any of the column header("displayName" or "name") > XML  > Export

export

Step 6

Rename the extension of the exported file from .XML  to .RDG and open the file

final-file

Note:

  1. If required you can click on the Root or Group and check the name of your liking.
  2. This process can be used to quickly update any XML. For eg., You have a list of data that you want to update to an XML you can use the above steps.

 

-   Praveen Kumar E signature-picture