Create entries directly in SQL Server database

Hello,

Its best to use our Powershell module to perform these kinds of tasks, but you need to handle a lot of stuff yourself.

Another option is to T-SQL to create a csv file, and have a https://help.remotedesktopmanager.com/synchronizer_csv.htm that processes the file, it will handle duplicate detection, moves, deletes, etc. This is the one that makes better use of the business logic behind our entry management as it is coded by us.

What track would you prefer?


Best regards,

Thanks for your reply. I know about Powershell module, but I'm planning to use other SQL Server DB to get entries and insert it into RDM, so it will be much more easier and faster directly by TSQL.

Hello,

Believe me, it is not easier.

We use triggers and timestamps.

Unless you do not use neither of our two caching systems at all, you will run into issues.

When you say "other SQL Server DB", is it a RDM data source?

Best regards,

No :)

Ok, so another question.

In your sample https://help.remotedesktopmanager.com/synchronizer_csv.htmI'm able only to insert few informations like:

Host,Name,Template,ConnectionType,ConnectionSubType,SubMode,Group,Username,Domain,Password,Description,URL

Is it possible to add something else ? like eg credentials (to set inherited credentials from group) ?

Hello,

Oh, that is documented in https://help.remotedesktopmanager.com/pstipsandtricks.htm

That is hard to find, we're struggling to index that type of stuff but we are trying a bunch of stuff. Hopefully we will improve the help search results.


Best regards,

I'm trying to import entries by "CSV synchronizer" but i encounter problem with templates. I'm unable to use templates on "group/folder" level, on "Microsoft Remote Desktop (RDP)" level, everything works fine.

Could you please explain how to use template on problematic level ? I need templates to set credentials and different icon than default.