Query report for Time Spent for First response in Version 11.0 (Postgres)
SELECT slad.SLANAME AS "Request SLA", wo.WORKORDERID AS "Request ID", longtodate(wo.CREATEDTIME) AS "Created Time", slad.SLANAME AS "Request SLA", longtodate(wo.FR_DUETIME) AS "Request first response due time",round(wo.RESPONSE_TIMESPENT / 60000) AS "Request response time elapsed (in Minutes)", wos.IS_FR_OVERDUE AS "Request first response overdue status", longtodate(wo.RESPONDEDTIME) AS "Responded Date" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN SLADefinition slad ON wo.SLAID=slad.SLAID WHERE ( std.ISPENDING = false ) AND wo.ISPARENT='1' ORDER BY 1, 2
Filtered by: Pending Status is NO.
New to ADSelfService Plus?
Login Frequency Query Report
The below report would help us find the last logged in time of the users in SCP 11.0 SELECT AaaUser.FIRST_NAME "Technician", MAX(AaaLogin.NAME) "LoginName", MAX(AaaContactInfo.EMAILID) "Email", MAX(AaaAccSession.USER_HOST) "IP ...
Query to get the Request Approval details
Compatible builds : 14000 to 14200 DB : MSSQL /PGSQL OUTPUT: SELECT wo.WORKORDERID AS "Request ID", wo.title AS "Subject", wo.REQUESTERID AS "Requester ID", LONGTODATE(wo.CREATEDTIME) AS "Requested Date", LONGTODATE(apdet.sent_time) AS "Action ...
Database migration from MySQL to Postgres/MSSQL in SCP 8.1
We no longer support the use of MYSQL as database in SupportCenter Plus. Hence, we request our users to migrate to Postgres (which is in-built) or Microsoft SQL. Please follow the below steps to carry out the database migration: 1. Shutdown the ...
Script to satisfy first response SLA in SCP 11
As of now only for the following scenarios, First response can be marked in the SupportCenter application: * Notes addition * Worklog addition * Technicians manual response Apart from this if you want to mark any other actions in the application as ...
Query for Support Rep list in DB
Please run this query to find the list of Support Reps available with login in the system select * from aaauser aaau join sduser sdu on aaau.user_id=sdu.userid inner join helpdeskcrew hd on sdu.userid=hd.technicianid inner join aaalogin aaal on ...