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

Created by user-d7a7b on Feb 11, 2022


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(tick)
8.2.x(tick)
8.1.x(error)
8.0.x(error)
Applicable RDBMS


RDBMS
Yes/No
Oracle Server (error)
Microsoft SQL Server (error)
CSS2 (tick)


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