Purpose of Query
This page helps you to get the list of missing technological objects.
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 DISTINCT doi.OBJECT_ID , doi.OBJECT_TYPE_ID , dot.OBJECT_TYPE_NAME AS OBJECT_NAME, 'Technologic ' || dot.OBJECT_TYPE_NAME || ' object' AS OBJECT_DESCRIPTION, dot.OBJECT_TYPE_NAME AS OBJECT_FULL_NAME FROM DSS_LINK_INFO dli JOIN DSS_OBJECT_INFO doi ON doi.SNAPSHOT_ID = dli.SNAPSHOT_ID AND doi.OBJECT_ID = dli.NEXT_OBJECT_ID JOIN DSS_OBJECT_TYPES dot ON dot.OBJECT_TYPE_ID = doi.OBJECT_TYPE_ID LEFT JOIN DSS_OBJECTS dos ON dos.OBJECT_ID = dli.NEXT_OBJECT_ID WHERE dli.LINK_TYPE_ID = 2 AND dos.OBJECT_ID IS NULL
Query result example
Query provides below column values:
Query result interpretation
Query for Oracle
Enter the SQL query
Query result example
Query result interpretation
Query for SQL server
Enter the SQL query
Query result example
Query result interpretation
Notes/comments
Related Pages