ServiceDesk Plus - Generate a report on Parent Request and its linked requests

ServiceDesk Plus - Generate a report on Parent Request and its linked requests

select wo.WORKORDERID "Parent request ID",wol.WORKORDERID "Linked Request ID" from WorkOrder as wo  left join WorkOrderStates as wol on wol.LINKEDWORKORDERID=wo.WORKORDERID where wol.LINKEDWORKORDERID!=0  order by 1

Use the above query to generate a quick report on the parent request id and the linked request ids.