How to view calculated baseline values?

book

Article ID: 77071

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

How to view calculated baseline values?
 
Currently its only possible to view calculated baseline values by querying the database.
 

Environment

UIM 8.51

Resolution

Below is the query to get the RN_table (Raw QoS values) for a particular QoS on that particular device:
 

  • You have to replace the probe_name and dev_name(device name) to your respective probe and device name in Query 1.
  • Once executed it will return the RN_QOS_DATA_<num> and table_id for the particular QoS, Source and Target.
  • To then view the baseline values execute Query 2 where we are replacing R with B i.e, RN_QOS_DATA _<num> to BN_QOS_DATA_<num>. This will allow you to view the hourly baselines calculated in the 'samplevalue' column for the respective QoS Samples.


 
Query 1:
 
select
d.dev_name,
c.ci_name,
q.r_table,
qd.name,
q.table_id,
q.source,
q.target
from cm_Device d
join CM_CONFIGURATION_ITEM c
on d.dev_id = c.dev_id
join CM_CONFIGURATION_ITEM_METRIC m
on m.ci_id = c.ci_id
join s_qos_data q
on q.ci_metric_id = m.ci_metric_id
join s_qos_definition qd
on qd.qos_def_id = q.qos_def_id
where d.probe_name in ('controller','cdm') and d.dev_name like '%dunry01%' order by 2
 
Query 2:
 

  • Using Query 1, this will identify the respective RN table and its table_id, replace the R with B as above (r_table is RN_QOS_DATA_0015) and execute it to get the baselines for desired QoS.


 
select * from BN_QOS_DATA_0015 where table_id=921

Example Screenshot of both Queries: 

 

Attachments

1558693750137000077071_sktwi1f5rjvs16mbm.png get_app