SQL Queries - CAST Central Base - How to Identify list of objects not linked in DSS_LINK_INFO

Purpose of Query

This page helps you to get the list of objects not linked in DSS_LINK_INFO table.

Applicable CAST Version

ReleaseYes/No
8.3.x✅
8.2.x✅
8.1.x❌
8.0.x❌

Applicable RDBMS

RDBMSYes/No
Oracle Server❌
Microsoft SQL Server❌
CSS2✅

Query for CSS

SELECT O.OBJECT_TYPE_ID,  
              COUNT(O.OBJECT_ID) 
  FROM DSS_OBJECT_INFO O 
  JOIN DSS_OBJECT_TYPES OT 
    ON OT.OBJECT_TYPE_ID = O.OBJECT_TYPE_ID 
   AND OT.OBJECT_GROUP = 2 
 WHERE O.SNAPSHOT_ID = 104 
   AND NOT EXISTS ( SELECT 1 
                      FROM DSS_LINK_INFO DL 
                      WHERE DL.LINK_TYPE_ID = 2 
                      AND DL.SNAPSHOT_ID =<snapshot_id>
                     AND DL.NEXT_OBJECT_ID = O.OBJECT_ID
                     )                                                             
Group by O.OBJECT_TYPE_ID

Query result example

Query result interpretation

Query provides object type id and counts of objects not linked in DSS_LINK_INFO table.

Query for Oracle

Enter the SQL query

Query result example

Query result interpretation

Query for SQL server

Enter the SQL query

Query result example

Query result interpretation

Notes/comments

Related Pages