search cancel

SLA queries for last months compliance For SLA dashboard Downtime

book

Article ID: 239623

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

SLA Query   for  response update/downtime:
Gets an SLA listing to put in a dashboard for specific SLA name

Environment

Release : 20.3, any release

Component : UIM - SLA_ENGINE

Resolution

SELECT H.sla_id, S.name, H.percentage, H.period_begin, H.period_end, H.created
FROM H_SLA_COMPLIANCE H
JOIN S_SLA_DEFINITION S on H.sla_id=S.sla_id
WHERE H.period_begin > dateadd(MONTH, -2, GETDATE()) and S.NAME like 'SLM name'
ORDER by H.sla_id, H.period_begin