Inserting Connections Directly into a Database

Hello,

Have you seen our powershell cmdlets?

They are documented on http://help.remotedesktopmanager.com/powershell_cmdlets.htm

We even have a forum dedicated to them

http://forum.devolutions.net/forum42-remote-desktop-manager--powershell-repository.aspx

Is it an acceptable solution?

Thanks Maurice.

We're currently running our operations on a remote Ubuntu Server that has a web interface. This is the server we generate the cloud servers from via API. Would this work on a linux platform?

I'm not well versed on powershell at all, as a matter of fact I've never used it. I'll try to read around and see if I can find a way that would be able to help. I was hoping there was a way I could just do a simple insert into the database somehow.

You could also use the CSV Synchronizer, you would generate a CVS file on the ubuntu host, transfer it on a windows box which would have RDM, then "launch" the CSV sync to create new entries.

It would maybe require to install SSH on that windows box. This method would also allow you to run the powershell script. Maybe the CSV method is less involved

You definitely could create the sessions directly in the DB, but we cannot guarantee that the schema will not change in future releases. If you look at the DATA column of the Connections table, you will see that its a simple XML structure.

Best regards,
edited by mcote on 12/31/2014
edited by mcote on 12/31/2014

I see the entries in the database, what encryption method would I use to encrypt the passwords?

Thanks again.

We cannot share that, but you can set the password in clear text format in a ClearTextPassword field.

My personal suggestion would be to set these sessions to use inherited credentials and store them in a group that has credentials set to it. Obviously this works only if they use the same password...

Awesome! Thanks Maurice, that seems to work! One last question, looking through the XML there's an ID field and a stamp field. What is the stamp field? And is the ID generated randomly?

Thanks again for your help so far and happy new year.

Hi,
Exactly it's only a random Guid used to uniquely identify the connection and the it's version. It changes on every save.