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

Document ID:  TEC1502107
Last Modified Date:  08/10/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Unified Infrastructure Management

Releases

  • CA Unified Infrastructure Management:Release:8.4
  • CA Unified Infrastructure Management:Release:8.41
  • CA Unified Infrastructure Management:Release:8.42
  • CA Unified Infrastructure Management:Release:8.47
  • CA Unified Infrastructure Management:Release:8.5
  • CA Unified Infrastructure Management:Release:8.51

Components

  • UIM - UMP:UIMUMP
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.

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >