SQL Queries - CAST Central Base - Queries on Metrics - How to get the list of all metrics with param name and values

Purpose of Query

This query on the central base returns the list of metrics that have parameters and their associated parameters.

Applicable CAST Version

Applicable RDBMS

Query for CSS

SELECT   t1.metric_id      ,
         t3.metric_name    ,
         t1.param_name     ,
         t2.param_num_value,
         t2.param_char_value
FROM     dss_metric_param_types t1 ,
         dss_metric_param_values t2,
         DSS_METRIC_TYPES t3
WHERE    t1.metric_id   = t2.metric_id
AND      t1.metric_id   = t3.metric_id
AND      t1.param_index = t2.param_index
AND      t1.object_type_id IN (-1 ,
                               -13,
                               -20,
                               -5 ,
                               -11,
                               -15,
                               -4 ,
                               -17,
                               -18,
                               -2 ,
                               -3 ,
                               0)
ORDER BY t1.metric_id

Query result example

565;“Avoid including files other than header files”;“Extensions for files”;0;".hh"
565;“Avoid including files other than header files”;“Extensions for files”;0;".hxx"
565;“Avoid including files other than header files”;“Extensions for files”;0;".h"
565;“Avoid including files other than header files”;“Extensions for files”;0;".hcc"

Query result interpretation

The results provide the metric id, the metric name, the parameter name, the parameter numeric value, and the parameter character value. All of these values may not be pertinent for all metrics. See themetric documentation for more details on a specific metrics parameters.

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