K1000 Agents/Client Machines are getting duplicated
Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0

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

Answered 07/01/2014 by: anand.30hiremath
Blue Belt

  • 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.
Please log in to comment
Answer this question or Comment on this question for clarity