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 escalateton eton ON es.escalatetoid=eton.escalatetoid
LEFT JOIN aaauser au ON au.user_id=eton.userid
GROUP BY sdo.name,
         sla.slaname
ORDER BY 2



      New to M365 Manager Plus?
      New to M365 Manager Plus?
        New to RecoveryManager Plus?
        New to RecoveryManager Plus?
          New to Exchange Reporter Plus?
          New to Exchange Reporter Plus?
            New to SharePoint Manager Plus?
            New to SharePoint Manager Plus?
                See all integrations
                New to ADManager Plus?
                See all integrations
                New to ADManager Plus?

                  New to ADSelfService Plus?

                  Start your free trial
                  Start your free trial

                    • Related Articles

                    • Query to get complete SLA details. (PGSQL)

                      Tested in build PGSQL (14300) 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" , ...

                    • Query to know SLAs configured and its details (MSSQL & PGSQL)

                      Tested in Build PGSQL (14300) or MSSQL (14306) PGSQL: select slad.slaname "SLA NAME", sdo.name "SITE", ad.org_name "ACCOUNT", slad.duebydays || ' Days,' || slad.duebyhours || ' Hours,' || slad.duebyminutes || ' Mins' "Resolved Within", ...

                    • Send escalation email to the Technician "Reporting to" if SLA is violated (Deluge).

                      From Builds 10600 and above Follow the below steps and based on the update we need to create a custom trigger based on the action set under the SLA escalation notification and then with the help of that we can execute the custom trigger and the ...

                    • How to send notification mail to the Reporting Manager when a SLA is breached ?

                      Use Case:   When a SLA is getting breached, the technician's "ReportingTo" Manager has to be notified over email. Prerequisites: 1. Python Installation Steps :  ...

                    • 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", ...

                      Related Products