Sync with or export to a MySQL DB

Hello,

Just to confirm my understanding, the MySQL DB is not one used by RDM, right?

If so, you can use our powershell module to export to a csv format, then use any other tool to import in your other DB. MySQL had a "LOAD DATA" statement that may fit your requirements.


Just correct my if I misunderstood.

Reference forum for our powershell module https://forum.devolutions.net/forum42-remote-desktop-manager--powershell-repository.aspx


Best regards,

Yes, not the RDM DB.

I have a website that i put tech info into online spreadsheets. These spreadsheets dynamically display this data in charts and graphs. I'd like to have RDM sync system information with a DB at the DB server. Manually exporting is a plan B, if i could somehow sync it would be great.

Thank you for any help and ideas.

Scott

Hello,

We are limited on what we can do for your import process as it is not into our products, but we can help setup a scheduled export that fits your requirements.

It will be a powershell script that you can call on a schedule. A real basic example can be found on https://help.remotedesktopmanager.com/howto_powershell_exportcsv.htm

Do you have a list of the fields you want exported?

No problem on the import process, i understand and will figure that out.

As for the export, i'm really interested in export info that changes often. i.e. Software/versions, OS build, Drive free space.

Can an export process be setup for all profiles/connections or do they need to be done individually?

Is there any more reference info for using this powershell script?

For example, i'd like to,

If Acrobat Reader is installed on the remote machine (I find it currently with an Inventory Report) export this info to a CSV.

Hello,

Information's on PowerShell can be found in our online help and/or in the dedicated forum that we have on that matter
https://help.remotedesktopmanager.com/powershell_cmdlets.htm
https://forum.devolutions.net/forum42-remote-desktop-manager--powershell-repository.aspx

Best regards,