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
Option to cancel the pending tasks when Request is cancelled- when the worklog is mandatory
Requirement: Customer needs to close the tasks when the request is closed and the worklog is mandatory field in request closing rules. Download the attached scripts. Under Admin > Developer Space > Global Custom Function, create a new custom ...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 ...