Query that shows Service catalog SLA (MSSQL & PGSQL)

Query that shows Service catalog SLA (MSSQL & PGSQL)


Tested in Build PGSQL (14300) or MSSQL (14306)


select slad.slaname "SLA NAME", sdo.name "SITE", slad.duebydays "Resolved within Days", slad.duebyhours "Resolved within Hours", slad.duebyminutes "Resolved within Mins", slad.fr_duebydays "Responded within Days", slad.fr_duebyhours "Responded within Hours" ,slad.fr_duebyminutes "Responded Within minutes", slad.Overrideoh "Should respond/resolve irrespective of OP Hrs",slad.Overrideholidays "Should respond/resolve irrespective of Holidays", slad.Overrideweekends "Should respond/resolve irrespective of  Weekends" from sladefinition slad left join sitedefinition sd ON slad.siteid=sd.siteid left join sdorganization sdo ON sd.siteid=sdo.org_id left join accountsitemapping asm ON slad.siteid=asm.siteid left join accountdefinition ad ON asm.accountid=ad.org_id WHERE slad.isservicesla='TRUE'

                  New to ADSelfService Plus?

                    • Related Articles

                    • Query to show service catalog template details (MSSQL & PGSQL)

                      Tested in Build PGSQL (14300) or MSSQL (14306) select sd.name "Service Name", rtl.templatename "Service Template Name", rtl.comments "Template description", rtf.description "Description field" from requesttemplate_list rtl LEFT JOIN ...
                    • Query to show response, resolution SLA violated count and its percentage ( PGSQL & MSSQL)

                      Tested in build PGSQL (14300) and MSSQL (14306) SELECT pd.PRIORITYNAME AS "Priority" , count(wo.WORKORDERID) "Total Requests", count(case when ( std.ispending='0') THEN 1 ELSE NULL END) "Closed", count(case when (wos.IS_FR_OVERDUE='1') THEN 1 ELSE ...
                    • Query to show SLA assigned to tickets

                      Working on Builds: 14500 and above Database: PGSQL & MSSQL: SELECT slad.slaname "SLA", ad.ORG_NAME AS "Account", wo.WORKORDERID AS "Request ID", LONGTODATE(wo.CREATEDTIME) AS "Created Time", ti.FIRST_NAME AS "Technician", rtdef.NAME AS "Request Type" ...
                    • 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" , ...
                    • Contract and Service Plans details - Query Report (MSSQL & PGSQL)

                      Tested in Build PGSQL (14300) or MSSQL (14306) PGSQL & MSSQL: select ac.contractno "Contract Number", ac.contractname "Contract Name", sp.serviceplanname "Service Plan Name",sp.plantype "Service Plan Type", sp.timeperiod "Bill ...