How to view calculated baseline values?

Document ID : KB000077071
Last Modified Date : 11/04/2018
Show Technical Document Details
Introduction:
How to view calculated baseline values?
 
Currently its only possible to view calculated baseline values by querying the database.
 
Environment:
UIM 8.51 
Instructions:
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: 

User-added image