We've spent the past few weeks exploring the ability to obtain extra information from the ScreenConnect database. We obtained a database viewer, and we've run some interesting queries about access machines and support session durations. It's a bit of an understatement to say that we can find some pretty useful information with SQL quieries. But, there are limitations to our current workflow. What if you need a less technical employee to generate reports? Or, what if you have a query that needs to be run on a regular basis?
Forunately, we can take the process one step further with some programming aptitude. There are libraries readily available for handling SQL queries. In this case, I've used my most familiar language: Java. It's possible to easily open and query the database, manipulate the data, and save to a format that can be viewed with Excel. It can even be exported an as executable file.
Below, you'll find two files: the .exe file for duration and the zipped Eclipse project. The program is written specifically for Windows 64-bit machines, but can be easily changed for Unix-based operating systems. You can choose to use my exising .exe file to generate support duration reports (Warning: it requires Java 8), and you can modify the existing code to generate your own reports.
Note: The executable must be run on the server machine. A good strategy is to place the .exe on your server's desktop, install an access client on your server (if you haven't already), and remote to the server anytime you need a report.
Generate Report .exe (3.78 mb)
Eclipse Project .zip (3.72 mb)
Good luck with your customizations, and share any interesting modifications with the forum!