Configure Enterprise Data Collection and Analytics

Configure Enterprise Data Collection and Analytics

Overview

LanSchool Classic Enterprise Data Collection allows school districts and IT administrators to collect teacher 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:

  1. Install and configure a PostgreSQL database.
  2. Assign a school name to each LCS server.
  3. Enable Enterprise Data Collection on an LCS server.
  4. Connect the LCS server to the PostgreSQL database.
  5. Generate standard Enterprise Data Collection reports.

Prerequisites

Before configuring Enterprise Data Collection, ensure your environment meets the following requirements:

  1. LanSchool Connection Service (LCS): Version 9.0 or later.
  2. PostgreSQL: Version 12.0 or later.
  3. Database server: A separate machine from the LanSchool Connection Service server.
  4. Static IP address: Configure a static IP address for the PostgreSQL database server.
  5. Database permissions: The PostgreSQL user must have administrative rights to the LanSchool database.

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.

Prerequisites

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:

SettingExample
Database ServerIP address or hostname of the PostgreSQL server
Database Port5432
Database NameLanSchool
Database Usernamelanschool

You may use different database names and usernames, provided they have the required permissions.

Step 1: Install and Configure PostgreSQL

  1. Install PostgreSQL Server version 12.0 or later on a machine separate from the LanSchool Connection Service (LCS) server.

  2. Create a PostgreSQL database. For this example, use LanSchool.

  3. Create a PostgreSQL user. For this example, use lanschool.

  4. Assign the PostgreSQL user administrative rights to the newly created LanSchool database.

  5. 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.

Step 2: Set the School Name on the LCS Server

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.

  1. Log into the LanSchool Connection Server as an Administrator.
  2. Open Notepad as an administrator:
    1. Click Start and search for Notepad.

    2. Right-click Notepad and select Run as administrator.

  3. Enter the following configuration:
    [Default School]
    name=Name of School

  4. Select File > Save As.

  5. Navigate to:
     C:\Program Files (x86)\LanSchool\lskdu.

  6. Enter LANSCHOOL.INI as the file name.
  7. Change Save as type to All Files.

  8. Select Save.

Replace Name of School with the appropriate school or site name.

Repeat these steps on each LCS server that needs a unique school name.

Step 3: Enable the Data Collection Option on the LCS Server

Before configuring the database connection, enable the Data Collection option on the LanSchool Connection Server Status Page.

  1. Log into the LanSchool Connection Server as an Administrator.
  2. Click Start, type regedit, and open Registry Editor.

  3. Navigate to the following registry key:
    Computer\HKEY_LOCAL_MACHINE\SOFTWARE\LanSchool

  4. Right-click the LanSchool folder and select New > DWORD (32-bit) Value.

  5. Name the new value:

    ShowDataCollection

  6. Double-click ShowDataCollection.

  7. Set Value data to 1.

  8. Select OK and close Registry Editor.

  9. Open the Windows Services application.

  10. Locate LanSchool Connection Server Service.

  11. Select Restart the service.


After restarting the service, the Data Collection page will be available in the LCS Status Page.

Step 4: Configure and Start Enterprise Data Collection

Configure the LCS server to connect to your PostgreSQL database.

  1. Log into the LanSchool Connection Server as an Administrator.
  2. Open a browser on the LCS server.
  3. Navigate to: 

    Alternatively, double-click the LanSchool Connection Server Status Page shortcut on the desktop.

  4. Select Data Collection from the navigation pane (on the left).
  5. Check Enable data collection.
  6. Enter your PostgreSQL database connection information:

    SettingInformation to Enter
    Database ServerIP address or hostname of your PostgreSQL database server
    Port5432
    Database NameLanSchool, or the database name you created
    Database Usernamelanschool, or the username you created with administrative rights to the database


  7. Select the Submit.
  8. Verify that the message Configuration saved appears.

  9. Click OK.
  10. Close the LCS Status Page or navigate to another page, such as Status.



Once configured, the LCS server will begin sending collected usage statistics to the PostgreSQL database.

You can use the reporting tool of your choice to access and analyze the collected data.

Step 5: Generate Enterprise Data Collection Reports

LanSchool provides the LskDataQuery.exe utility to generate standard Enterprise Data Collection reports.

Run the utility directly on the LanSchool Connection Service server.

  1. Open Command Prompt on the LCS server.

  2. Navigate to the following directory:

     C:\Program Files (x86)\LanSchool\Lskdu

  1. Run the following command, replacing the dates with your desired reporting period:

    LskDataQuery.exe -b "2025-05-01" -e "2025-05-08"
  2. The example generates reports using May 1, 2025, as the beginning date and May 8, 2025, as the ending date

  3. Navigate to the following folder to view the generated reports:

  4. C:\Program Files (x86)\LanSchool\Lskdu\Report

Example command line:  C:\Program Files (x86)\LanSchool\Lskdu>LskDataQuery.exe -b "2025-05-01" -e "2025-05-08"


View Additional Report Options

To view additional command-line options and examples, run:

LskDataQuery.exe -h

Frequently Asked Questions

What is LanSchool Enterprise Data Collection?

Enterprise 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.

What are the requirements for Enterprise Data Collection?

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.

Which database does LanSchool use for Enterprise Data Collection?

LanSchool Enterprise Data Collection uses PostgreSQL version 12.0 or later.

Do I need to install PostgreSQL on the LanSchool Connection Server?

No. PostgreSQL must be installed on a separate machine from the LanSchool Connection Service (LCS) server.

How do I enable Enterprise Data Collection?

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.

Where do I configure the PostgreSQL database connection?

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.

How do I know if Enterprise Data Collection is configured successfully?

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.

What is the difference between Enterprise Data Collection and the LanSchool Report Server?

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.

Does Enterprise Data Collection collect historical data from before it was configured?

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.

Can I generate a report showing how often each teacher uses LanSchool over the past 12 months?

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:

  1. Ensure Enterprise Data Collection has been configured and enabled on your LanSchool Connection Service (LCS) server.

  2. Run LskDataQuery.exe from the following directory:

    C:\Program Files (x86)\LanSchool\Lskdu

  3. Specify the beginning and ending dates for your reporting period using the -b and -e parameters.

AlertImportant: 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.

How do I generate LanSchool Enterprise Data Collection reports?

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