Query to show parent and child requests (Linked Request) and its details.(MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306)
Please go to Reports-New Query Report and execute this query.
select woparent.WORKORDERID "Parent request ID",
aaauparentreq.first_name "Parent Requester",
woparent.title "Parent Subject",
stdparent.statusname "Parent Request Status",
aaauparent.first_name "Parent Request Technician",
LONGTODATE(woparent.createdtime) "Parent Request Created Time",
woschild.WORKORDERID "Linked Request ID",
wochild.title "Linked Request Subject",
aaauchild.first_name "Linked Request Technician",
LONGTODATE(wochild.createdtime) "Linked Request Created Time",
stdchild.statusname "Linked Request Status",
LONGTODATE(wochild.duebytime) "Linked Request Due By Time" from WorkOrder as woparent
left join workorderstates wosparent on woparent.workorderid=wosparent.workorderid
left join WorkOrderStates woschild on woschild.LINKEDWORKORDERID=woparent.WORKORDERID
left join workorder wochild on woschild.workorderid=wochild.workorderid
left join statusdefinition stdparent on stdparent.statusid=wosparent.statusid
left join statusdefinition stdchild on stdchild.statusid=woschild .statusid
left join aaauser aaauparent ON wosparent.ownerid=aaauparent.user_id
left join aaauser aaauchild ON woschild.ownerid=aaauchild.user_id
left join aaauser aaauparentreq ON woparent.requesterid=aaauparentreq.user_id
where woschild.LINKEDWORKORDERID!=0 AND woparent.CREATEDTIME >= <from_thisweek> AND woparent.CREATEDTIME <= <to_thisweek>
ORDER BY 1
New to ADSelfService Plus?
Related Articles
Linked request
This report is used to find the child request id that are linked to the parent request id. To make any changes to a query, refer to the KB article below. ...Query for request attachment details (MSSQL & PGSQL)
Tested in builds from PGSQL (14300) or MSSQL (14306) Requests with Attachment, its name and path SELECT ad.ORG_NAME AS "Account", wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject", ti.FIRST_NAME AS "Technician", sa.ATTACHMENTNAME "Attachment ...How to automatically create multiple child requests from a parent request with a configurable JSON file (V3)
This is a sample Python script to automatically trigger the creation of multiple child requests from a parent request, based on the request template chosen. The request ID of the child requests will be added as a Note in the parent request. This is ...How to automatically create multiple child requests from a parent request with a configurable JSON file (V3) (Copying parent UDF fields, Resource Information and parent attachments)
Deluge Equivalent: For builds 13002 and above: https://pitstop.manageengine.com/portal/en/kb/articles/create-multiple-child-requests-13002 For Older builds: ...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", ...