Mass Deleting Assets without going through them 1 by 1

[CarlVE]

Hi All

Hope someone can help, I am busy going through all the assets that have no user relation to them in order to do a clean up.

The report I have shows all the assets, is there any way to remove them all without going through them 1 by 1 (around 900 assets).

I can mass delete assets from the asset tab but I cannot filter it with the results I need. 

[Hendrik_VE]

What I would do in this case (but you need to have a little SQL knowledge), is open up SSMS and create an update query that updates a custom field based on the output of your report (back up your Lansweeper DB first 😉).

Then go to Lansweeper -  Assets (which gives you the list of all assets), filter on this custom field, select all these assets and click delete.