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

Purpose of Query

The query provides the list of source file objects that 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
         JOIN DSS_OBJECT_INFO doi
         ON       doi.OBJECT_ID   = dos.OBJECT_ID
         AND      doi.SNAPSHOT_ID = <SNAPSHOT_ID>
         JOIN DSS_OBJECT_TYPES dot
         ON       dot.OBJECT_TYPE_ID    = dos.OBJECT_TYPE_ID
WHERE    lower(dot.OBJECT_TYPE_NAME) LIKE '%source file%'
ORDER BY 1

Query result example

Query result interpretation

The query will result the number of sources files included for 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