I made a custom report in Crystal Reports to view all the tickets that are created by our department or which tickets still are open.
When I run the report I see a few more requests than I see in ServiceDesk. After doing some research on this issue I saw the difference.
In my report I also see the tickets that are merged with another ticket. The merged tickets are shown as individual tickets. When I do a search on one of these tickets I can't find them in ServiceDesk because these tickets are merged.
Where in the database or in which table can I find the relation between merged tickets?