How to determine correct Metric Type information in the Top N report or Group Trend Report for UMP

Document ID : KB000015533
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

How to determine correct Metric Type information in the Top N report or Group Trend Report for UMP

TopN.png

 

Environment:
UIM 8.x
Answer:
  • The query below can be run on sql management studio .
  • In the example below the information will be provided for probe sysstat.

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 'systat'; 

 

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