/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


Deleting duplicate machines in Kace

01/30/2017 1675 views
Hello ITNinja 

My company has Kace agents installed on all of our end user PC's. The agent grabs all kinds of info from the machines and creates a database of them in the "inventory" Module of Kace. 

We thousands of machines spread across every state in over a 100 offices. During re images we sometimes forget to delete the old computer from inventory. 

Is there a way to make inventory authenticate machines using service tag or mac address and delete any duplicates? So any machines that were reimaged and had a name change will have their old name deleted from the database?

Thanks  
0 Comments   [ + ] Show comments

Comments


All Answers

3
You can't automate this process but there are options. The first is to turn on the MIA settings to automatically delete (or archive if running version 7) machines from the inventory. Alternatively you can run a report that will find duplicate computers. We have several that we run on a periodic basis to find duplicate computers.

By System Name:
SELECT MACHINE.KUID,MACHINE.NAME AS SYSTEM_NAME,IP,MAC,OS_NAME,LAST_SYNC,CLIENT_VERSION
FROM (MACHINE ,( select COUNT(ID) CT, MACHINE.NAME FROM MACHINE GROUP BY MACHINE.NAME )M2 ) LEFT JOIN ASSET ON MAPPED_ID=MACHINE.ID
WHERE M2.CT>1 and MACHINE.NAME=M2.NAME
ORDER BY SYSTEM_NAME
By serial number:
SELECT MACHINE.BIOS_SERIAL_NUMBER,MACHINE.KUID,MACHINE.NAME AS SYSTEM_NAME,IP,MACHINE.MAC, OS_NAME,LAST_SYNC
FROM (MACHINE ,( select COUNT(ID) CT, MACHINE.BIOS_SERIAL_NUMBER FROM MACHINE GROUP BY MACHINE.BIOS_SERIAL_NUMBER )M2 ) 
WHERE M2.CT>1 and MACHINE.BIOS_SERIAL_NUMBER=M2.BIOS_SERIAL_NUMBER
ORDER BY MACHINE.BIOS_SERIAL_NUMBER,SYSTEM_NAME
By hardware address:
SELECT MACHINE.MAC,MACHINE.KUID,MACHINE.NAME AS SYSTEM_NAME,IP,OS_NAME,LAST_SYNC
FROM (MACHINE ,( select COUNT(ID) CT, MACHINE.MAC FROM MACHINE GROUP BY MACHINE.MAC )M2 ) 
WHERE M2.CT>1 and MACHINE.MAC=M2.MAC
ORDER BY MACHINE.MAC,SYSTEM_NAME
I have the first one emailed to me Monday morning and go through and delete the duplicates.
Answered 01/31/2017 by: chucksteel
Red Belt

  • I have a similar weekly report for dupe serial numbers. In order to minimize erroneous results I also include the following line in the WHERE clause:
    AND MACHINE.BIOS_SERIAL_NUMBER NOT IN ("","0","To be filled by O.E.M.","System Serial Number")
    • Nice tip. I am adding that to my report
 
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