Systems Management

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.

https://www.itninja.com/question/deleting-duplicate-machines-in-kace

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.