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_CONNECTEDFrom 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) M2Where 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
Sign up today to participate,
stay informed, earn points and establish a reputation for yourself!