CMS Snapshot Analysis - Run Analyzer - Information - How to identify duplicate object GUIDs

This page describes about the method to find duplicate object GUIDs

(1) Activate AMT saving debug mode

(2) Run the following query on the KB:

select  o1.OBJECT_ID as "ID of object 1"
      , o2.OBJECT_ID as "ID of object 2"
      , o1.NAME_ID as "GUID of object 1"
      , o2.NAME_ID as "GUID of object 2"
from IN_OBJECTS o1
  join IN_OBJECTS o2 on (o2.NAME_ID = o1.NAME_ID
       and o2.OBJECT_ID > o1.OBJECT_ID)

The rows returned by the query contain the objects having duplicated GUIDs.

In order to delete the duplicate objects in the KB use example : SQL Queries - CAST Knowledge Base - Queries on objects - How to get and delete GUID of duplicate objects in KB

Note that more diagnostic queries can be found on SQL Queries - CAST Knowledge Base - Queries on objects - How to get object GUID