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

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. 

1 REPLY 1
Hendrik_VE
Champion Sweeper III

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.