Linked request

Linked request

This report is used to find the child request id that are linked to the parent request id. 


SELECT wos.linkedworkorderid "Request ID",
       wo.TITLE "Subject",
       std.STATUSNAME "Request Status",
       rtdef.NAME "Request Type",
       longtodate(wo.CREATEDTIME) "Created Time",
       wo.workorderid "Linked to" FROM WorkOrder wo
LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID
LEFT JOIN RequestTypeDefinition rtdef ON wos.REQUESTTYPEID=rtdef.REQUESTTYPEID
LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID
WHERE (wo.ISPARENT='1')
  AND wos.linkedworkorderid IS NOT NULL
ORDER BY 1
 

Note : Login to ServiceDesk Plus, go to Reports tab > New Query Report > Copy the query to the query editor and run the report. 

          • Related Articles

          • How to close linked requests when a parent request is closed.

            This post describes the use of a python script to close all the linked request when a parent request is closed using custom triggers. Use Case: We get tickets which are getting reported for the same issue but different end-users so that once we ...
          • Close parent request only if all the linked request are closed.

            Requirement: Parent ticket can be closed only if all the linked requests are closed Usecase: In many organizations, the parent ticket is divided into many sub-requests, each of which is handled by a different technician/group. All of these ...
          • Close all linked requests when a parent request is closed - Deluge

            Requirement: All the linked requests need to be closed when the parent request is closed. Refer to this link for Python equivalent:  https://pitstop.manageengine.com/portal/en/kb/articles/how-to-close-linked-requests-when-a-parent-request-is-closed ...
          • How to Auto Share Request Upon Creation to All/Selected Technicians

            NOTE:  This script is supported only for builds below 11.3 This post describes the use of a python script to share requests to technicians specified in a list variable in the script, which can be generated from an SQL query. This script can be ...
          • Request recipient email

            This report is used to find the recipient email address.  Some requests are forward to others through the mail, this report helps to find the statistics how many requests are forward to others using the email address filter.  To make any changes to a ...