Purpose of Query
The following query can be run on the central repository, it provides you with the list of objects contributing to the MODIFIED automated enhancement technical point for a snapshot.
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 |
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 = 'MODIFIED' 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 = 'MODIFIED' 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 = 'MODIFIED' 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