The collected data is sent from each LanSchool Connection Service (LCS) server to a centralized PostgreSQL database. Administrators can then use the LskDataQuery.exe utility to generate standard reports and analyze LanSchool usage across their school or district.
This article explains how to:
Before configuring Enterprise Data Collection, ensure your environment meets the following requirements:
LanSchool Classic Enterprise Data Collection allows school districts and IT administrators to collect educator usage statistics from connected LanSchool Teacher Consoles across their organization.
The collected data is sent from each LanSchool Connection Service (LCS) server to a centralized PostgreSQL database. Administrators can then use the LskDataQuery.exe utility to generate standard reports and analyze LanSchool usage across their school or district.
This article explains how to:
Install and configure a PostgreSQL database.
Assign a school name to each LCS server.
Enable Enterprise Data Collection on an LCS server.
Connect the LCS server to the PostgreSQL database.
Generate standard Enterprise Data Collection reports.
Before configuring Enterprise Data Collection, ensure your environment meets the following requirements:
LanSchool Connection Service (LCS): Version 9.0 or later.
PostgreSQL: Version 12.0 or later.
Database server: A separate machine from the LanSchool Connection Service server.
Static IP address: Configure a static IP address for the PostgreSQL database server.
Database permissions: The PostgreSQL user must have administrative rights to the LanSchool database.
You will need the following database information during configuration:
| Setting | Example |
|---|---|
| Database Server | IP address or hostname of the PostgreSQL server |
| Database Port | 5432 |
| Database Name | LanSchool |
| Database Username | lanschool |
You may use different database names and usernames, provided they have the required permissions.
Install PostgreSQL Server version 12.0 or later on a machine separate from the LanSchool Connection Service (LCS) server.
Create a PostgreSQL database. For this example, use LanSchool.
Create a PostgreSQL user. For this example, use lanschool.
Assign the PostgreSQL user administrative rights to the newly created LanSchool database.
Record the database server's IP address or hostname, database name, username, and port number (5432). You will need this information when configuring the LCS server.
For additional information about installing and configuring PostgreSQL, visit the PostgreSQL Documentation.
If your organization uses multiple LanSchool Connection Service servers, assign a unique school name to each LCS server.
This allows you to identify which LCS server collected the data when reviewing reports.
Click Start and search for Notepad.
Right-click Notepad and select Run as administrator.
Enter the following configuration:
[Default School]
name=Name of School
Select File > Save As.
Change Save as type to All Files.
Replace Name of School with the appropriate school or site name.
Repeat these steps on each LCS server that needs a unique school name.
Before configuring the database connection, enable the Data Collection option on the LanSchool Connection Server Status Page.
Click Start, type regedit, and open Registry Editor.
Navigate to the following registry key:
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\LanSchool
Right-click the LanSchool folder and select New > DWORD (32-bit) Value.
Name the new value:
ShowDataCollection
Double-click ShowDataCollection.
Set Value data to 1.
Select OK and close Registry Editor.
Open the Windows Services application.
Locate LanSchool Connection Server Service.
Select Restart the service.
After restarting the service, the Data Collection page will be available in the LCS Status Page.
Configure the LCS server to connect to your PostgreSQL database.
Alternatively, double-click the LanSchool Connection Server Status Page shortcut on the desktop.
Enter your PostgreSQL database connection information:
| Setting | Information to Enter |
|---|---|
| Database Server | IP address or hostname of your PostgreSQL database server |
| Port | 5432 |
| Database Name | LanSchool, or the database name you created |
| Database Username | lanschool, or the username you created with administrative rights to the database |
Verify that the message Configuration saved appears.
Close the LCS Status Page or navigate to another page, such as Status.
You can use the reporting tool of your choice to access and analyze the collected data.
LanSchool provides the LskDataQuery.exe utility to generate standard Enterprise Data Collection reports.
Run the utility directly on the LanSchool Connection Service server.
Open Command Prompt on the LCS server.
Navigate to the following directory:
C:\Program Files (x86)\LanSchool\Lskdu
Run the following command, replacing the dates with your desired reporting period:
LskDataQuery.exe -b "2025-05-01" -e "2025-05-08"The example generates reports using May 1, 2025, as the beginning date and May 8, 2025, as the ending date
Navigate to the following folder to view the generated reports:
C:\Program Files (x86)\LanSchool\Lskdu\Report
To view additional command-line options and examples, run:
LskDataQuery.exe -hEnterprise Data Collection is a LanSchool Classic feature that collects usage statistics from connected Teacher Consoles through the LanSchool Connection Service (LCS). The collected information is stored in a PostgreSQL database and can be used to generate reports about LanSchool usage across an organization.
Enterprise Data Collection requires:
LanSchool Connection Service version 9.0 or later.
PostgreSQL version 12.0 or later.
A PostgreSQL database server on a separate machine from the LCS server.
A PostgreSQL user with administrative rights to the LanSchool database.
LanSchool Enterprise Data Collection uses PostgreSQL version 12.0 or later.
No. PostgreSQL must be installed on a separate machine from the LanSchool Connection Service (LCS) server.
First, create and configure a PostgreSQL database. Then, add the ShowDataCollection registry value to the LCS server, restart the LanSchool Connection Server Service, and configure the database connection from the Data Collection page in the LCS Status Page.
On the LCS server, open a browser and navigate to http://localhost:8085/. Select Data Collection from the navigation pane and enable data collection. Enter the PostgreSQL server address, port, database name, and username, then select Submit.
After submitting the database configuration, the LCS Status Page should display the message Configuration saved.
Once configured, usage statistics should begin appearing in the PostgreSQL database.
Enterprise Data Collection collects usage statistics from connected Teacher Consoles and stores them in a PostgreSQL database.
The LanSchool Report Server is a separate reporting solution that collects information such as student browsing history, keyword alerts, application activity, and computer inventory.
No. LanSchool Enterprise Data Collection only begins collecting usage statistics after the feature has been successfully configured and enabled on the LanSchool Connection Service (LCS) server.
Data from before Enterprise Data Collection was set up cannot be retrieved or collected retroactively. Only data collected from the time of setup forward will be available in the PostgreSQL database and included in generated reports.
Yes. LanSchool Enterprise Data Collection can collect Teacher Console usage statistics that can be used to analyze LanSchool usage across your organization.
You can use the LskDataQuery.exe utility to generate reports for a specified date range and review usage data stored in the PostgreSQL database.
To generate a report covering the past 12 months:
Ensure Enterprise Data Collection has been configured and enabled on your LanSchool Connection Service (LCS) server.
Run LskDataQuery.exe from the following directory:
C:\Program Files (x86)\LanSchool\Lskdu
Specify the beginning and ending dates for your reporting period using the -b and -e parameters.
Important: Enterprise Data Collection only collects data starting from the date it was initially configured and enabled. It cannot retrieve historical usage information from before setup.If you need a full 12 months of usage data, Enterprise Data Collection must have been collecting data throughout that period.
Run LskDataQuery.exe from the following directory on the LCS server:
C:\Program Files (x86)\LanSchool\Lskdu
Use the -b and -e parameters to specify the beginning and ending dates for the reporting period.
Generated reports are saved in:
C:\Program Files (x86)\LanSchool\Lskdu\Report