Deleting duplicate machines in Kace
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
Answers (1)
Please log in to answer
Posted by:
chucksteel
7 years ago
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.
Comments:
-
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") - JasonEgg 7 years ago-
Nice tip. I am adding that to my report - rockhead44 7 years ago
