→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
pschreutelkamp
Engaged Sweeper II

For some reason the database cleanup does not seem to work. Despite the settings below I still have assets in the database as "last seen in 2014"...

  • We have no assets set to not be affected by cleanup options.
  • Assets still in the database have long been purged from our AD. 
  • Our system is on LS version 10.6.2.0

2023-09-19 Server options - Asset Cleanup settings.jpg

And this is a sample from a list giving last scan dates:

2023-09-19 Last scandates sample.jpg

Can someone please tell me what I'm doing wrong? 

3 REPLIES 3
Obi_1_Cinobi
Lansweeper Tech Support
Lansweeper Tech Support

Hello there!

The option Permanently delete assets not seen in the last XX days needs some more clarification, perhaps. For example, if you have configured this interval to 30 days, the assets that have not been seen in the last 30 days will be deleted. You can check the Scan Time tab of your assets to see if they have met this not seen criterium, with not seen we mean:

  • The assets have not been successfully scanned in the last 30 days, this means that the Last Seen date or Last Successful Scan (tblAssets.Lastseen) needs to be older than 30 days.
  • The assets have not reported to a domain controller in the last 30 days, this means that the Last Active Scan or Last On-Premises AD Domain Scan date (tblAssets.LastActiveScan) needs to be older than 30 days.
  • The assets have not been seen in the network in the last 30 days by IP Range Scanning, i.e. Lansweeper has not seen assets with that name/IP combination and open ports in the network. This means that the Last IP Range Scan date (tblAssets.LastIPScan) needs to be older than 30 days.

For in-depth troubleshooting we would recommend reaching out to support: https://www.lansweeper.com/contact-support/

Thanks ObiWan and MrNobody, I am aware of the option of maunally deleting assets, and I am also aware of the 30 days not seen requirement for automated cleaning. The fields you see in the provided screenshot are exclusively coming for the tblAssets table, and you can see tblAsset.Lastseen = 10-10-2014. That does not match with the 30 days parameter.... However... many assets are not having a "lastIPscan" date, as they were never discovered during an IP scan. That is also clear in the screenshot I provided. This is typical for travelling employees and consultants who only now and then are visible in the network, as they are typically at work in the offices of our clients. When they are in our office they do not make money, so preferable we see them as little as possible. In the settings I limited the "set to not active" to 60 days not seen and the "delete" to 365 days not seen. 

I am not aware when in the process of daily life the value for LastActiveScan is filled-in. Many assets do have only blanks there. But I also see many units with a date Lastseen in 2015 and a date LastActiveScan in 2012 (see the bottom of the screenshot) and a blank LastIPscan. In my view these should have been automatically removed? 

Probably it's best if I log a support-case. 

Thank you for thinking with me!

Mister_Nobody
Honored Sweeper II

Sometimes LS has corrupted data so you can deleted assets manually via Assets editiing menu.