→ 🚀What's New? Explore Lansweeper's Fall 2024 Updates! Fall Launch Blog !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Susan_A
Lansweeper Alumni

TL;DR-Sweepy-Icon (1).png
This page explains where to find the report library, and how to add any report to your own Lansweeper Classic installation.


The report library houses a vast amount of reports, ranging from network reports, to vulnerability reports or even Patch Tuesday reports. If you find a SQL query in the report library that you would like to import into your own Lansweeper Classic installation, you can do so in just a few easy steps.

Lansweeper data, reports and settings are stored in a database. Your database is hosted in either the Microsoft SQL LocalDB, Microsoft SQL Server or (deprecated) Microsoft SQL Compact database server. Any built-in or custom Lansweeper reports are in fact SQL queries that are run on your SQL database.

Import a SQL query as a report

  1. Browse to the Reports > Create New Report section of the web console to open the report builder.
    menu-reports-create-new-report.jpg
  2. Replace the default SQL query at the bottom of the report builder with the one you want to import. The screenshot below shows what needs to be changed. Make sure to replace the entire SQL query with your own.
    how-to-add-a-report-to-your-lansweeper-installation-1.jpg
  3. Give your report a title in the report builder.
    how-to-add-a-report-to-your-lansweeper-installation-2.jpg
  4. Wait for your SQL query change to apply, if it hasn't already. You'll see the new query be applied in the upper section of the report builder, both in the visual representation of tables and in the expression list.
  5. Select Save & Run to execute the report you just imported. The SQL query is now run on your database and the report results are displayed.
    how-to-add-a-report-to-your-lansweeper-installation-3.jpg
  6. After the report is run, you can:  
    • Export the report results or perform other actions on the report.
    • Filter the report further within the report results, using the boxes above each column.
    • Set up an alert for the report, so you are automatically notified of its results. The alert can automatically export the report results to a folder or send them via email to email addresses specified by you.
      how-to-add-a-report-to-your-lansweeper-installation-4.jpg

Was this post helpful? Select Yes or No below!
Did you have a similar issue and a different solution? Or did you not find the information you needed? Create a post in our Community Forum for your fellow IT Heroes!
More questions? Browse our Quick Tech Solutions.


Was this article helpful? Yes No
0% helpful (0/2)

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now
Version history
Last update:
‎08-16-2023 11:55 AM
Updated by: