• UIM 9.x or higher

• The query below can be run on sql management studio.
• In the example below the information is provided for probe cdm.

select distinct cs.cs_id, cs.name, cs.cs_key, cs.ip, dev.dev_id, cim.ci_id, cim.ci_metric_id,
qos.origin, qos.source, qos.target, cim.ci_metric_type,cimd.met_description,ci.ci_name as ci_name,
sqdef.description as ci_descr, qos.qos, qos.probe, qos.table_id, qos.r_table, qos.v_table, 
sqdef.unit, sqdef.unit_short, sqdef.hasmax, sqdef.isbool, sqdef.type, sqdef.description_token, 
cid.ci_description as ci_alias 
from S_QOS_DATA qos 
join S_QOS_DEFINITION sqdef 
on sqdef.qos_def_id = qos.qos_def_id 
join CM_CONFIGURATION_ITEM_METRIC cim 
on cim.ci_metric_id = qos.ci_metric_id 
join CM_CONFIGURATION_ITEM ci 
on ci.ci_id = cim.ci_id 
join CM_DEVICE dev 
on dev.dev_id = ci.dev_id 
join CM_COMPUTER_SYSTEM cs 
on cs.cs_id = dev.cs_id 
join CM_CONFIGURATION_ITEM_METRIC_DEFINITION cimd 
on cimd.met_type = cim.ci_metric_type 
join CM_CONFIGURATION_ITEM_DEFINITION cid 
on cid.ci_type = cimd.ci_type 
where qos.probe like 'cdm%'; 

• Can change the probe to the desired probe in the query above as per requirements.
• The met_description, ci_descr and  ci_alias column in the above query output will provide information on the corresponding Metric Type to be used for a probe as seen in the Top N report or Group Trend Report.