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
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 = '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
