Closed request with pending task
This report is used to get all completed request with the pending task.
To make any changes to a query, refer to the KB article below.
SELECT wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject", aau.FIRST_NAME AS "Requester", qd.QUEUENAME AS "Group", ti.FIRST_NAME AS "Technician", std.STATUSNAME AS "Request Status", taskdet.TASKID AS "Task ID", taskdet.TITLE AS "Title", taskowner.FIRST_NAME AS "Owner", taskstatus.STATUSNAME AS "Task Status" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN WorkorderToTaskdetails wotk ON wo.WORKORDERID=wotk.WORKORDERID LEFT JOIN TaskDetails taskdet ON wotk.TASKID=taskdet.TASKID LEFT JOIN SDUser taskownersdu ON taskdet.OWNERID=taskownersdu.USERID LEFT JOIN AaaUser taskowner ON taskownersdu.USERID=taskowner.USER_ID LEFT JOIN StatusDefinition taskstatus ON taskdet.STATUSID=taskstatus.STATUSID WHERE (wo.ISPARENT='1') AND std.ispending='0' AND taskstatus.ispending='1'
Note : Login to ServiceDesk Plus, go to Reports tab > New Query Report > Copy the query to the query editor and run the report.
New to ADSelfService Plus?
Related Articles
Pending Request for more than 10 days
This report provides a quick view of all Pending incidents which are not closed for more than 10 days. When the incidents start backlogging faster than they can be resolved, the tendency of long incidents pending time can be exposed in this report. ...Difference between resolved and Closed notification
The requester notifications are sent for two status: 'Resolved' and 'Closed' Both 'Resolved' and 'Closed' are default completed statuses. When a technician provides a solution that he thinks will solve the issue, he/she can set the request to the ...Query to show Request and associated task details (PGSQL & MSSQL)
Tested in build PGSQL (14300) and MSSQL (14306) PGSQL & MSSQL: SELECT wo.WORKORDERID AS "Request ID", aau.FIRST_NAME AS "Requester", wo.TITLE AS "Subject", pd.PRIORITYNAME AS "Priority", cd.CATEGORYNAME AS "Category", scd.NAME AS "Subcategory", ...Script to Disable Worklog Addition on Closed Request
Kindly use the below scripts under Admin -> Page Scripts to disable Worklog addition on Closed request. The below script hides the Save option while creating new worklog on closed request. Script: let params=new ...Scripts to automatically cancel request tasks when the request status is set to cancelled (when the task closure rule is enabled)
NOTE: In the attached script Owner and Group value is hardcoded, so the script works only when the group and owner name are configured in task closure rules(valid technician name and group name). If technician and group doesn't exist inside the task ...