jvm_monitor metrics not showing in OC

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

After applying the 20.40T3 ump_operatorconsole patch I can choose jvm_monitor metrics but after choosing and updating a view the metrics are not showing as they should. Only one metric is showing, no matter how many I choose.

Environment

UIM 20.4

jvm_monitor 1.51

Cause

The given query is failing because a computer system might exists with the same name in multiple origins in customer's environment.

Resolution

Run it by replacing the 'DEVICE_NAME' and  'USER_ORIGIN' with appropriate device and origin names.

SELECT qd.source,  qd.qos,  qd.target,  qd.r_table,  qd.table_id, qd.robot, qd.ci_metric_id,

       qd.probe, cim.ci_metric_type,  qs.samplevalue, cs.origin

  FROM cm_computer_system cs

         INNER JOIN

       cm_device d ON d.cs_id = cs.cs_id

         INNER JOIN

       cm_configuration_item ci ON ci.dev_id = d.dev_id

         INNER JOIN

       cm_configuration_item_metric cim ON cim.ci_id = ci.ci_id

         INNER JOIN

       s_qos_data qd ON qd.ci_metric_id = cim.ci_metric_id

         INNER JOIN

       s_qos_snapshot qs ON qd.table_id = qs.table_id

  WHERE cs.cs_id = (SELECT CS_ID FROM CM_COMPUTER_SYSTEM WHERE name = 'DEVICE_NAME' and origin = 'USER_ORIGIN')

  AND qs.sampletime > '2022-01-01 00:00:00.000'