There is no out-of-the-box solution to this query.
- Some of this information is stored in the Data Warehouse.
You may query the Data Warehouse to get this information.
- Some of the information is stored in Jasper Reports files.
These are not stored in either the Data Warehouse database or the PPM database. They typically exist locally to computers and therefore you would need access to the file system/s, and the ability to read the information.
Providing a business solution to this is out of scope for Broadcom Support. Our Global Delivery or a third party may be able to suggest a solution to meet the business requirement.
Factors that a site looking at such a solution may wish to consider:
- What is the business need? What is the value/cost of the risk/opportunity?
- Can it be accomplished some other way? Eg CCing reports.
- Can you get sufficient information from the Data Warehouse (which is relatively easy to query), to meet the business need?
- Is it worth getting Global Delivery (or another third party) engaged to scope and quote?