Inquiry regarding SQL query traceability via Microsoft SQL Server entries

Inquiry regarding SQL query traceability via Microsoft SQL Server entries

1 vote

avatar

Dear Support Team,

In our current workflow, we are using Devolutions Server via Remote Desktop Manager.

We have successfully configured Microsoft SQL Server entries, and the connections are working as expected. However, we would like to know if Remote Desktop Manager provides any native functionality to:

  1. Trace or record SQL queries executed by a user during an active session.

  2. Consult a history of queries launched once the session has ended.

If such a feature exists, could you please provide us with the configuration procedure? If not, is there a recommended method using your tools to ensure this type of auditing?

Thank you in advance for your assistance.

Best regards,

All Comments (3)

avatar

Hello,

This is a great feature request. I have logged a feature request ticket for a future version of RDM. Do you want to only record queries run by RDM or do you want to access Query logs, for example the Query Store or the SQL Server Agent to trace all queries run against the server?

Thanks,

Paul

avatar

Hello,

Thank you for your feedback, it’s great to hear about the requested feature.

As for logging queries, I believe priority should be given to queries executed via RDM, since we intend to use the integrated SSMS instance.

However, depending on the level of complexity, why not leverage the "Access Query logs" in MSSQL? That is also a viable approach.

Are both options feasible?

For your information, please note that I have two Devolutions Gateways and one Devolutions Server in my environment.

Best regards,

Jacques

avatar

Hello @jvaillant ,

I have logged your requests in the ticket, and we will look into this.

Thanks,

Paul