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

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

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

 

Environment

UIM 8.x

UIM 9.x

Resolution

• The query below can be run on sql management studio .
• In the example below the information will be 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 desired probe in above query as per requirement.
• The met_description, ci_descr and  ci_alias 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.