SQL Queries - CAST Central Base - Queries on snapshots - How to get the list of source file objects that does not belong to a snapshot

Purpose of Query

The query will provide the list of source file objects that does not belong to a snapshot

Applicable CAST Version

Applicable RDBMS

Query for CSS

SELECT    dot.OBJECT_TYPE_NAME,
          dos.OBJECT_FULL_NAME
FROM      DSS_OBJECTS dos
          LEFT JOIN DSS_OBJECT_INFO doi
          ON        doi.OBJECT_ID   = dos.OBJECT_ID
          AND       doi.SNAPSHOT_ID = 2
          JOIN DSS_OBJECT_TYPES dot
          ON        dot.OBJECT_TYPE_ID   = dos.OBJECT_TYPE_ID
WHERE     lower(dot.OBJECT_TYPE_NAME) LIKE '%source file%'
AND       doi.OBJECT_ID            IS NULL
ORDER BY  1;

Query result example

Query result interpretation

The query will provide the list of source file objects that does not belong to a snapshot

Query for Oracle

Same as CSS2

Query result example

Query result interpretation

Query for SQL server

Same as CSS2

Query result example

Query result interpretation

Notes/comments

Related Pages