Purpose of Query
This query on the central base returns the list of metrics that have parameters and their associated parameters.
Applicable CAST Version
Release | Yes/No |
|---|---|
| 8.3.x |  |
| 8.2.x | |
Applicable RDBMS
RDBMS | Yes/No |
|---|---|
| Oracle Server |  |
| Microsoft SQL Server | |
| CSS | |
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
