API call to query Morpheus MySQL database tables

It could be useful to have an API call to query (only read mode) the Morpheus database table to extract data from table to build external reports instead of accessing lMorpheus appliance using SSH.

Thank you

Ideally the REST API can be used to query the desired information from the Morpheus platform. Are there any examples of information that you’ve been unable to retrieve using the REST API that was possible via a direct database query?

Optionally, the MySQL router offers an API endpoint to MySQL. In some HA environments we utilize the router, and then can direct read vs writes the applicable nodes.

The access to mysql tables could help to extract data that would require the development of a report plugin. For example list the users currently connected to the system or even to produce reports for multi tenants in one query