How to clear all scanning errors

[Obi_1_Cinobi]

If you have been troubleshooting scanning errors but can no longer easily determine which assets still have active issues, you may wish to reset all scanning errors and start from a clean slate. This article explains how to safely clear the tblErrors table in your Lansweeper database. Once cleared, new scanning errors will automatically repopulate as they occur.

Important: Back Up Your Database First

Before making any direct changes to your database, perform a full database backup.

• Do not skip this step.
• Backup instructions are available here: https://www.lansweeper.com/knowledgebase/backing-up-your-installation/

Step 1: Stop the Required Services

Stop the following services before modifying the database:

1. Lansweeper Server service – on all scanning servers
2. Web server service – on your Lansweeper web server
   • This will be either World Wide Web Publishing Service (IIS) or IIS Express, depending on your configuration

Step 2: Clear the tblErrors Table

1. Open SQL Server Management Studio (SSMS).
2. Connect to the Lansweeper database.
3. Execute the following script:

Use Lansweeperdb
DELETE FROM tblErrors
DBCC CHECKIDENT ('TblErrors', RESEED, 0)
GO

This removes all existing scanning errors and resets the identity counter for the table.

Step 3: Restart the Services

Once the script has completed successfully, restart:

• The Lansweeper Server service on all scanning servers
• Your web server service (IIS or IIS Express)

After the services are running again, new scanning errors will begin to populate normally as scans occur.