How do I exclude "non-active" assets from reports?

[Obi_1_Cinobi]

To exclude "non-active" assets from your reports, we recommend adjusting your reports so they only include assets with the “Active” state. In Lansweeper, reports and dashboards are based on SQL logic, so you can easily filter them by adding a specific condition.

Steps:

1. Open the report in the Lansweeper web console.
2. Click Edit report.
3. In the SQL query section, locate the tblAssets reference.
4. Add the following condition to the query:

   WHERE tblAssets.Assetstate = 1
   

   This ensures that only assets marked as "Active" are displayed.
5. Save and refresh the report.

Additionally, Lansweeper can automatically adjust the active/non-active state based on asset scanning:

• Go to Configuration > Asset Cleanup Options.
• Ensure that “Clean up non-active assets” is enabled and set to “Automatically make non-active assets active when they are rescanned.”
• Configure the number of days after which assets not seen will be marked as "non-active".

Built-in reports in the on-premises web console often only display assets marked as "Active" already.