SQL Queries - CAST Central Base - Queries on Metrics - How to get a list of complex objects

Purpose of Query

The purpose of this page is to provide a query to provide a list of complex objects in the CAST Central database

Applicable CAST Version

Applicable RDBMS

Query for CSS

SELECT   o.object_id "Object ID"    ,
         o.object_name "Object Name",
         CASE dmr.metric_num_value
                  WHEN 2
                  THEN 'HIGH'
                  WHEN 3
                  THEN 'VERY HIGH'
         END "Object Cost",
         dmr.snapshot_id
FROM     dss_objects o,
         dss_metric_results dmr
WHERE    o.object_id = dmr.object_id
AND
         --dmr.snapshot_id = 9 and
         dmr.metric_id = 65005
AND      dmr.metric_num_value IN(2,3)
ORDER BY o.object_id;

Query result example

500;“xhr”;“HIGH”;12

811;“execOptions”;“VERY HIGH”;11

Query result interpretation

The query will list HIGH and VERY HIGH complexity objects and provide the associated object id, object name and snapshot id for these complex objects.

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