‎01-11-2023 10:08 AM - last edited on ‎04-02-2024 11:32 AM by Mercedes_O
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.
‎01-11-2023 10:45 AM
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.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now