ScreenConnect offers the ability to audit session history with its basic and advanced auditing features. However, specific queries can often be useful for finding targeted information such as the number of concurrent sessions running at a given time, session durations, comprehensive lists of unattended machines, etc. Fortunately, the database file can be queried directly to receive specific information.
Part 1 - Installation:
The first step necessary in running your own queries with ease is to download a Database Browser tool. This allows you to quickly and easily view the data structure and data entries, while giving you the ability to run queries and view the results immediatley. One of the favorite tools among our team is the free SQLite Database Browser. It's simple to get up and running, but we've included the steps below.
1. Visit the website for the SQLite Database Browser (
the installation file for your appropriate system
3. Follow the Setup Wizard to install the software
Part 2 - Executing a Query:
Now that you have the Database Browser software installed, we can begin executing queries. ScreenConnect uses SQLite to store all data to a database consisting of four tables. These tables include Session, Session Connection, and Session Event information. Using the available information at your disposal, a wide variety of information can be reported based on the instructions below.
the SQLite Database Browser
Open Database from the top menu
to the ScreenConnect directory and open the file “Session.db”
the “Execute SQL” tab in the SQLite Database Browser
5. Enter your SQL query into the space provided
the “Run” button to execute the code
the “Save File” button and select “Export to CSV”
setting as default and click the “OK” button
the file to your desire location
A report is now saved in a format that is easily accessed via Microsoft Excel. With the power of SQLite and the Database Browser, you can access a much more specific set of information from the ScreenConnect database. Below is an example query for accessing a list of all unattended clients existing since the last time the database was cleared. Give it a try, and see what else you can determine with your newfound ability.
SELECT Name, GuestLoggedOnUserDomain, GuestLoggedOnUserName, GuestOperatingSystemName, GuestInfoUpdateTime
WHERE SessionType LIKE 2
ORDER BY GuestInfoUpdateTime DESC;