UIM 20.3.x - SLA Reports history not working

book

Article ID: 206551

calendar_today

Updated On:

Products

DX Infrastructure Management

Issue/Introduction

The new OC interface for the SLA reports does not allow to select a different history for the selected SLA:

Environment

Release : 20.3

Component : UNIFIED INFRASTRUCTURE MGMT

Resolution

This is a known problem in 20.3.x version and it's targeted to be fixed in the next version (20.3.4).

As a workaround, you can run the following queries to get the SLA reports history.

Note: In all the below queries change the parameter values as per your environment.

 

-- Identify the SLA by name - extract sla_id
SELECT * FROM S_SLA_DEFINITION WHERE name = 'Overall Compliance'

 

-- Run the below query to get History SLA compliance for the sla
-- Inputs Needed - sla_id & period_begin
SELECT DISTINCT 
       s.name, 
       s.sla_id, 
       s.description, 
       s.period_code, 
       s.period_number, 
       d.percentage, 
       s.compliance_percentage, 
       s.compliance_warning, 
       s.compliance_warning_level, 
       d.period_begin, 
       d.period_end, 
       d.created, 
       t.zone_name, 
       t.zone_display, 
       t.zone_offset, 
       t.zone_offset_dst, 
       t.zone_display_token 
  FROM s_sla_definition s LEFT JOIN 
        s_time_zone t 
         ON s.time_zone_name = t.zone_name, 
        h_sla_compliance d 
  WHERE d.sla_id = s.sla_id 
    AND s.sla_id = 74
    AND d.period_begin = '2020-11-01 00:00:00.0' 
  ORDER BY created DESC

 

  -- Run the below query to get History SLO compliance
  -- Inputs Needed - sla_id & period_begin
  SELECT DISTINCT 
       s.slo_id, 
       s.sla_id, 
       s.name, 
       s.description, 
       s.weight, 
       d.percentage, 
       s.compliance_percentage, 
       s.compliance_alarm, 
       COUNT(n.slo_note_id) as noteCount 
  FROM h_slo_compliance d, s_slo_definition s 
    LEFT JOIN s_slo_notes n 
      ON s.slo_id = n.slo_id 
      AND n.note_date BETWEEN '2020-11-01 00:00:00.0' AND '2020-12-01 00:00:00.0' 
  WHERE d.slo_id = s.slo_id 
  AND d.created = (SELECT MAX(created) FROM h_slo_compliance WHERE slo_id = d.slo_id AND period_begin = '2020-11-01 00:00:00.0') 
  AND d.period_begin = '2020-11-01 00:00:00.0' 
  AND s.sla_id = 74 
  GROUP BY s.slo_id, 
           s.sla_id, 
           s.name, 
           s.description, 
           s.weight, 
           d.percentage, 
           s.compliance_percentage, 
           s.compliance_alarm 
  ORDER BY s.slo_id 

 

 -- Run the below query to get History QOS Constraints compliance
-- Inputs Needed - sla_id & period_begin
SELECT DISTINCT 
       s.sla_id,
    s.slo_id, 
    sq.qos,
    sq.source, 
    sq.target, 
    hqc.created, 
    hqc.percentage compliance_percentage
  FROM h_qos_compliance hqc, 
  s_qos_constraints sq,
  s_slo_definition s 
  WHERE 
 hqc.sla_id = s.sla_id AND hqc.slo_id = s.slo_id AND hqc.qos_const_id = sq.qos_const_id
 AND sq.slo_id = s.slo_id  
  AND hqc.created = (SELECT MAX(created) FROM h_qos_compliance WHERE sla_id = hqc.sla_id and slo_id = hqc.slo_id and qos_const_id = hqc.qos_const_id AND period_begin = '2020-11-01 00:00:00.0') 
  AND hqc.period_begin = '2020-11-01 00:00:00.0' 
  AND s.sla_id = 74 
  ORDER BY s.slo_id 

Attachments