We are in the process of decommissioning our Pega based application called SWE (on-prem, version 8.5.5). Within this application, a Parent case (representing a group item) is associated with one or more Child cases (representing settlement items). This structure allows users to send a single email that consolidates data from all Child cases, rather than sending individual emails for each Child case. As part of the decommissioning exercise, we need to extract the mapping between Parent cases and their corresponding Child cases in a simple list format (e.g., Excel, .csv, or .txt).

We are not planning to migrate the complete case data. Our requirement is limited to obtaining the mapping data between Parent Case ID and Child Case(s) ID only.

Could you please advise on the best approach or provide guidance/tools to achieve this extraction?