DX Infrastructure Management

 View Only

Tech Tip: UIM Baseline / Dynamic Alarms - How to view calculated baseline values? 

Apr 11, 2018 09:15 AM

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

How to view calculated baseline values? - https://comm.support.ca.com/kb/how-to-view-calculated-baseline-values/KB000077071 

 

Additional Information: 


How baseline values are calculated - https://comm.support.ca.com/kb/how-baseline-values-are-calculated/KB000077075 

UIM Baseline / Dynamic Alarms - How baseline values are calculated - https://communities.ca.com/docs/DOC-231180992-uim-baseline-dynamic-alarms-how-baseline-values-are-calculated 

Statistics
0 Favorited
12 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Comments

Sep 19, 2018 03:47 AM

Hi Ryan,

 

UIM 9.01, baseline_engine 9.00

Richard

Sep 13, 2018 11:33 AM

Hi rschiller2

 

Can you please confirm the UIM version and baseline_engine probe version, I will test this in house. 

 

Many thanks, 

Ryan

Sep 11, 2018 05:10 AM

Query 1 does not work - at least not in V9.01!

Related Entries and Links

No Related Resource entered.