Purpose of Query
This document provides a query to list the technologies used in an application.
Applicable CAST Version
Release | Yes/No |
|---|---|
| 8.2.x |  |
| 8.1.x | |
| 8.0.x | |
| 7.3.x | |
Applicable RDBMS
RDBMS | Yes/No |
|---|---|
| Oracle Server | |
| Microsoft SQL Server |  |
| CSS2 | |
Query for CSS
SELECT DISTINCT OBJECT_NAME AS TECHNOLOGY
FROM DSS_OBJECTS
WHERE OBJECT_ID IN
(SELECT M1.OBJECT_ID
FROM DSS_METRIC_RESULTS M1
LEFT OUTER JOIN DSS_METRIC_RESULTS M2
ON (
M1.METRIC_ID = M2.METRIC_ID
AND M1.OBJECT_ID = M2.OBJECT_ID
AND M2.SNAPSHOT_ID = -1
AND M2.METRIC_VALUE_INDEX = M1.METRIC_VALUE_INDEX
)
JOIN DSS_LINKS T
ON (
T.NEXT_OBJECT_ID = M1.OBJECT_ID
)
JOIN DSS_OBJECTS DSSO
ON DSSO.OBJECT_ID=T.PREVIOUS_OBJECT_ID
WHERE M1.METRIC_ID = 60017
AND T.LINK_TYPE_ID = 2
AND DSSO.OBJECT_NAME = <APPLICATION_NAME> -- here 'App1'
AND M1.METRIC_VALUE_INDEX = 0
)
Query result example
"JEE"
"PL/SQL"
Query result interpretation
Application "App1" uses JEE and PL/SQL technologies.
Query for Oracle
SELECT DISTINCT OBJECT_NAME AS TECHNOLOGY
FROM DSS_OBJECTS
WHERE OBJECT_ID IN
(SELECT M1.OBJECT_ID
FROM DSS_METRIC_RESULTS M1
LEFT OUTER JOIN DSS_METRIC_RESULTS M2
ON (
M1.METRIC_ID = M2.METRIC_ID
AND M1.OBJECT_ID = M2.OBJECT_ID
AND M2.SNAPSHOT_ID = -1
AND M2.METRIC_VALUE_INDEX = M1.METRIC_VALUE_INDEX
)
JOIN DSS_LINKS T
ON (
T.NEXT_OBJECT_ID = M1.OBJECT_ID
)
JOIN DSS_OBJECTS DSSO
ON DSSO.OBJECT_ID=T.PREVIOUS_OBJECT_ID
WHERE M1.METRIC_ID = 60017
AND T.LINK_TYPE_ID = 2
AND DSSO.OBJECT_NAME = <APPLICATION_NAME> -- here 'App2'
AND M1.METRIC_VALUE_INDEX = 0
)
Query result example
TECHNOLOGY
-------------
PL/SQL
JEE
Cobol
3 record(s) selected [Fetch MetaData: 0/ms] [Fetch Data: 0/ms]
[Executed: 06/02/17 08:57:40 GMT ] [Execution: 7129/ms]
Query result interpretation
Application "App2" uses PL/SQL, JEE and Cobol technologies.
Notes/comments
Related Pages
