If you find a SQL query on the Lansweeper.com website that you would like to import into your own Lansweeper 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.
To import a SQL query as a report into your installation, do the following:
- Browse to the following section of the web console to open the report builder: Reports\Create New Report
- 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 at the very top of 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.
- Hit the Save & Run button to execute the report you just imported. The SQL query is now run on your database and the report results are displayed.
- Optionally, export the report results or perform other actions on the report with the buttons on the left. You can also filter the report further within the report results, using the boxes above each column. In addition to these options, you can 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.