How To verify QoS Metrics data Flow from SQL query and SLM Tool

Document ID : KB000010339
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

How To  verify QoS  Metrics data Flow from SQL query and SLM Tool 

Background:

During the QoS metrics data troubleshooting, we need to query for Table ID, Table, Target, Source, QoS name  and  RN_QoS_data information which involves several steps.

It is a summary of this step ans other method.

Environment:
It is UIM database SQL query and its SLM tool in UMP site.
Instructions:

To Find Qos Name, Source IP Target, Table ID and Table of RN_QoS

select * FROM [DB NAME].[dbo].[S_QOS_DATA] where qos = 'QoS Metric Name'

select * from rn_qos_data_00XX where table_id = XX

eg:

 

select * FROM [uim850].[dbo].[S_QOS_DATA] where qos = 'qos_reachability_reachability'

select * from rn_qos_data_00XX where table_id = YY

 

From SLM QoS Tool

From QoS selection-> Select  QoS Group-> Select Specific QoS metric ->Select target devices/hosts then  Drill Down until “ View Data” choice then select “Properties” to view table ID, Table, Target, Source and QoS Name.