SQL Queries - CAST Central Base - Queries on Objects - How to get the list of objects contributing to the DELETED automated enhancement technical point for a snapshot

Purpose of Query

The following query can be run on the central repository, it provides you with the list of objects contributing to the DELETED automated enhancement technical point for a snapshot

Applicable CAST Version

Applicable RDBMS

Query for CSS

SELECT V.object_id, 
       O.object_full_name 
FROM   aep_technical_artifacts_vw V 
       JOIN dss_objects O 
         ON V.object_id = O.object_id 
WHERE  V.snapshot_id = <snapshot_id>
       AND V.status = 'DELETED' 
ORDER  BY V.object_id

Query result example

1, fullname

Query result interpretation

The query returns the object Id and the object full name

Query for Oracle

SELECT V.object_id, 
       O.object_full_name 
FROM   aep_technical_artifacts_vw V 
       JOIN dss_objects O 
         ON V.object_id = O.object_id 
WHERE  V.snapshot_id =  <snapshot_id>
       AND V.status = 'DELETED' 
ORDER  BY V.object_id

Query result example

1, fullname

Query result interpretation

The query returns the object Id and the object full name

Query for SQL Server

SELECT V.object_id, 
       O.object_full_name 
FROM   aep_technical_artifacts_vw V 
       JOIN dss_objects O 
         ON V.object_id = O.object_id 
WHERE  V.snapshot_id =  <snapshot_id>
       AND V.status = 'DELETED' 
ORDER  BY V.object_id

Query result example

1, fullname

Query result interpretation

The query returns the object Id and the object full name

Notes/comments

Related Pages