Purpose of Query
This page provides a query to get the list of metrics using parameters.
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 |
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