Location of Data in MariaDB Database
I have data entered within the "General", "Hardware", and "Notes" tabs under Properties > Information of a particular device. I have queried all of the tables within MariaDB for this information, but I cannot find it. This information shows up on multiple clients, so it must be shared in the DB somewhere. Can someone please tell me where this information is stored within the DB so that I may run custom queries on this data to generate my own reports?
All Comments (3)
Hello,
Since we support more than 160 technologies, our DB structure must be quite flexible. Most of the data is in a single field, namely Connections.Data, its an xml structure.
You best bet would be to use Powershell. It handles decryption and provides access to all of the fields.
You can have a look at our forum dedicated to powerwhell http://forum.devolutions.net/forum42-remote-desktop-manager--powershell-repository.aspx . The sticky topics up top contain enough to get you started.
Do not hesitate to post a question in that forum.
Best regards,
Maurice
Fantastic! Thank you!
I just noticed that we also have a report that could be used
Administration, reports, then the Entry Information report, you will be able to select the tabs to include
Maurice