SQL query to show parent ticket and its child tickets (Merged Tickets)

Go to Reports-New Query Report and execute the below query




select Workorderid “Parent Request” , (SELECT STUFF((SELECT cast(Child_woid as varchar) + char(10) FROM conversation co where conversation.Workorderid=co.Workorderid FOR XML PATH (”)), 1, 0, ”)) “Merged Request” from conversation where Child_woid is not NULL group by Workorderid




Database : MSSQL

This entry was posted in Reports.

Need More Help?

Are you looking for a personalized customer support? Submit your question or Call our Toll Free Number to speak with ServiceDesk Plus MSP Expert who can offer a better solution for your requirements.

Submit a Ticket
Email : sdpmsp@manageengine.com
Toll Free : 1-888-720-9500