How to delete duplicate Assets from KACE SMA?
Good morning everyone,
I'm very new to Assets Management on the SMA. For some reason, we have duplicates, and even triplet records of the same device in our assets. I've checked on the admin guide, but I don't really see much about deleting assets. Would anyone have any ideas to share on how I could delete multiple records without have to search through all of them manually?
Thank you very much.
We also seem to have this issue of multiple assets after deploying windows.
Here is a link to the solution to searching for duplicates with an SQL query.
Create an SQL report and paste the SQL query in it and run. This should show you
all the duplicates in your organization
hope this helps
Can I suggest that you look at you Device Asset type as that is where your inventory record links to the asset record. If that is set in the wrong way it can leave you open to duplicate assets.
Over the years we try and move customers to this “best practice”, in your Device asset type add an additional text field, call it Serial Number and save your asset type.
Now edit the Device asset type again and set the inventory field to BIOS Serial number and the asset field to your new Serial Number field.
This will the link inventory records to asset records on the serial number. That means that if you change the device name, because the link is on the serial number you are much less likely to get duplicate asset records.
You also get the best of both worlds as the asset name copies the Device name, so assets are easy to find.
I Hope you find that useful.
If you set this up the asset records will update on the fly.