on 06-17-201908:30 PM - edited on 08-16-202311:55 AM by Nils
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
Browse to the Reports > Create New Report section of the web console to open the report builder.
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.
Give your report a title in the report builder.
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.
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.
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.
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.