Finding Duplicates in Kace k1000
Answers (1)
Resolution:
Create K1000 Report using below SQL Query
Select
MACHINE.NAME As SYSTEM_NAME,
MACHINE.LAST_SYNC,
MACHINE.IP,
MACHINE.KUID,
MACHINE.MAC,
MACHINE.BIOS_SERIAL_NUMBER,
M2.CT,
Concat(ASSET.NAME, ' see appendix of FAQ') ASSET_NAME,
ASSET.ID ASSET_ID,
KBSYS.SMMP_CONNECTION.CLIENT_CONNECTED
From
MACHINE Left Join
ASSET On ASSET.MAPPED_ID = MACHINE.ID Inner Join
KBSYS.SMMP_CONNECTION On KBSYS.SMMP_CONNECTION.KUID = MACHINE.KUID,
(Select
Count(MACHINE.ID) CT,
MACHINE.NAME
From
MACHINE
Group By
MACHINE.NAME) M2
Where
MACHINE.NAME = M2.NAME And
(M2.CT > 1)
Order By
MACHINE.NAME
****Analysis the Report and delete the duplicated nodes as per the Report****
To prevent Duplicates
Go to K1000 Settings: Agent Messaging Protocol
Check the Checkbox of Disbale Duplicate Machine Detection
Comments:
-
We have a duplicate on name report but you might also want to check duplicates based on serial number or MAC address of the nic. - Jbr32 9 years ago