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.

0 Comments   [ + ] Show comments

Answers (2)

Posted by: akmagnum 1 month ago
Red Belt

Hi there.

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

  • Thank you for the information. This helps! - cbargas 1 month ago
Posted by: Hobbsy 1 month ago
Red Belt

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.

  • Thank you for the information. This helps! - cbargas 1 month ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ