SLA details

SLA details

This report is used to get the complete list of SLA  configured in the application. 
‚Äč
PGSQL

SELECT sdo.name "Site Name" ,
       sla.slaname "SLA",
       MAX(sla.duebydays) "SLA Days",
       MAX(sla.duebyhours) "SLA Hours",
       MAX(sla.duebyminutes) "SLA Minutes" ,
       MAX(sla.fr_duebydays) "First Response Days",
       MAX(sla.fr_duebyhours) "First Response Hours",
       MAX(sla.fr_duebyminutes) "First Response Minutes",
       array_to_string(array_agg(au.first_name), ' ') "Escalate to" FROM sladefinition sla
LEFT JOIN sitedefinition sdf ON sla.siteid=sdf.siteid
LEFT JOIN sdorganization sdo ON sdf.siteid=sdo.org_id
LEFT JOIN timezonedefinition tz ON sdf.timezoneid=tz.timezoneid
LEFT JOIN slaescalation es ON sla.slaid=es.slaid
LEFT JOIN operationalhoursdef oh ON sdf.siteid=oh.siteid
LEFT JOIN hoursofoperation op ON oh.operationalhoursdefid=op.operationalhoursdefid
LEFT JOIN escalateton eton ON es.escalatetoid=eton.escalatetoid
LEFT JOIN aaauser au ON au.user_id=eton.userid
LEFT JOIN daysofoperation od ON oh.operationalhoursdefid=od.operationalhoursdefid
GROUP BY sdo.name,
         sla.slaname
ORDER BY 2


          • Related Articles

          • Requester details

            This report is used to find the Requester complete details.  SELECT AaaUser.USER_ID, AaaUser.FIRST_NAME "FullName", AaaLogin.NAME "LoginName", AaaLogin.DOMAINNAME "Domain", AaaContactInfo.EMAILID "Email", DepartmentDefinition.DEPTNAME "Department", ...
          • Contract Details

            SELECT mcdt.Contractid "Contract ID", mcdt.CONTRACTNAME "Contract Name", mcdt.comments "Description", contractcategory.Categoryname "Contract Type", LONGTODATE(mcdt.CREATEDDATE) "Created Time", LONGTODATE(mcdt.FROMDATE) "From Date", ...
          • SLA violation in next 3 days

            When we get a list of SLA violation in next 2 days, it is important to alert the team involved in resolving the incident, to take part in SLA restoration. To make any changes to a query, refer to the KB article below. ...
          • Purchase Request details

            SELECT pr.Requestid "Requestid", pr.Subject "Subject", pr.Description "Description", longtodate(pr.Requesteddate) "Requesteddate", longtodate(pr.Daterequired) "Daterequired", longtodate(pr.createddate) "createddate", pr.Shipping_details ...
          • Software details

            SELECT systeminfo.workstationname             "Workstation",         Max(aaauser.first_name)                "User",         ( softwarelist.softwarename )          "Software_Name",         Max(softwaretype.softwaretype)         "Software_Type",  ...