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
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
7.3.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS2(tick)
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