When using a MSSQL Advanced Data Source, where are activity/access logs stored?
When using a MSSQL Advanced Data Source, where are activity/access logs stored?
https://help.remotedesktopmanager.com/view_logs_global.htm
When using a Microsoft SQL Server data source, anyone can right-click on a particular session and do View > Logs
Are these events stored in a particular SQL table when the MSSQL Data Source?
All Comments (3)
Hello,
Viewing Logs is not logged (I could not find any on my side...).
However, You can restrict the View Log Permission, By going in Administration -> System Permission -> Miscellaneous -> Activity Logs and set it to Never (or any roles you'd like)
When set to Never, Only Admins can access this feature.
I hope this helps!
Best regards,
Alex Belisle
I’m actually hoping to find where they’re saved, not restrict access to them (at this time).
I’m hoping to find a way to get the activity logs into a system like Splunk. Wondering if there is a particular SQL table they live in that I could query for events. I will also check out the database tomorrow - but hoping for a quick answer or best practice.
Thank you!
Hi,
They are in the ConnectionLog table. For historical reasons it contains a lot of unused columns, but you should find your way around the relevant columns easily.
Best regards,
Maurice