/bundles/itninjaweb/img/Breadcrumb_cap_w.png
K1000 Agents/Client Machines are getting duplicated
Answer Summary:
Cancel
0 Comments   [ - ] Hide Comments

Comments

Please log in to comment

Answer this question or Comment on this question for clarity

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