How to view calculated baseline values?
Currently its only possible to view calculated baseline values by querying the database.
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.
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
- 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: