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.
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 ...
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 ...
You can use the below query to get the Followers and the request details. Go to Reports --> New Query Report select wo.workorderid "Request Id",wo.title "Subject",aaau.first_name "Followers",aaauc.emailid "Followers email" from workorder_cclist woc ...