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", slad.fr_duebydays || ' Days' || slad.fr_duebyhours || ',Hours' || slad.fr_duebyminutes || ' Mins' "Responded Within", 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 ORDER BY 3
MSSQL:
select sdo.name "SITE", slad.slaname "SLA NAME", ad.org_name "ACCOUNT", slad.fr_duebydays "Response DueBy Days", slad.fr_duebyhours "Response DueBy Hours", slad.fr_duebyminutes "Response DueBy Minutes", slad.duebydays "Resolution DueBy Days", slad.duebyhours "Resolution DueBy Hours", slad.duebyminutes "Resolution DueBy Mins", 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 ORDER BY 3
Along with Escalation details:
select sdo.name "SITE", slad.slaname "SLA NAME", ad.org_name "ACCOUNT", slad.fr_duebydays "Response DueBy Days", slad.fr_duebyhours "Response DueBy Hours", slad.fr_duebyminutes "Response DueBy Minutes", slad.duebydays "Resolution DueBy Days", slad.duebyhours "Resolution DueBy Hours", slad.duebyminutes "Resolution DueBy Mins", 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", SLAE.ESCALATION_TYPE, SLAE.LEVEL, SLAE.ESCAFTERDAYS, SLAE.ESCAFTERHOURS, SLAE.ESCAFTERMINUTES, SLAE.ESCTOTICKETOWNER 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 LEFT JOIN Slaescalation slae ON slad.slaid=slae.slaid ORDER BY 3
New to ADSelfService Plus?
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" , ...SLA not working
There are a few configurations that need to be checked 1. Account/Site Check the request Account & Site, Now, go to Admin>Service Level Agreements>Filter the Account & Site and make sure the SLA is created for the same 2. Operational Hours Go to ...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 ...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 ...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 ...