Deleting unlinked device assets?
Is there any way to find and delete assets that are not linked to a device anymore? I know that I can visually identify them by whether they have a bracketed device name next to the entry. But Kace was not well maintained over the years and we have hundreds of orphaned records that I want to remove and clean up, so manual identification is not really optimal.
There is no quick way to do this unfortunately, due mainly to the fact that you cannot create labels in the Asset Management space, so you cannot sort device assets into groups and also due to the fact that the data fields you need are not available via the search options
Running the following SQL in a report will show you the extent of the issue
FROM ASSET ASSET
WHERE (ASSET.ASSET_TYPE_ID = 5) AND (ASSET.MAPPED_ID = 0)
ORDER BY ASSET.ID, ASSET.NAME