/build/static/layout/Breadcrumb_cap_w.png

Finding Duplicates in Kace k1000

K1000 Agents/Client Machines are getting duplicated

0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: anonymous_102124 9 years ago
Blue Belt
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


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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ