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 ...
How do I convert the database from MSSQL to PGSQL ?
Kindly plan to perform this process ONLY during Non Operational hours. You can do this process in the same server that you have SDP MSP installed. Step 1: Stop the application and Take a backup of the existing data in the application. Navigate to ...
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" ...
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 ...