SQL Queries - CAST Central Base - SQL Queries on Metrics - How to get the list of metrics using parameters

Purpose of Query

This page provides a query to get the list of metrics using parameters.

Applicable CAST Version

Applicable RDBMS

Query for CSS

Please run the query on central schema to get the list of metrics using parameters :

select T.METRIC_ID,
       T.METRIC_NAME,
       MTP.PARAM_NUM_VALUE, 
       MTP.PARAM_CHAR_VALUE,
       DMP.PARAM_NAME
from DSS_METRIC_TYPES T,DSS_METRIC_PARAM_VALUES MTP
join DSS_METRIC_PARAM_TYPES DMP
on DMP.METRIC_ID=MTP.METRIC_ID
where MTP.METRIC_ID = T.METRIC_ID + 1
 and T.METRIC_GROUP = 1
order by T.METRIC_NAME

This query will provide the result like below which contains metric_id,metric_name,param_value and param_name respectively.

Query result example

7132,‘Action Mappings should have few forwards’,‘5’,,‘Maximum number of forwards’

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