do we have a way to gather all XDO reports which contains only pdf output [please check the below]

Question

Hi Everyone,

I am looking for query or table which include the below information:

i believe this data stored somewhere in the DB. but i tried too much to get all reports which have PDF output. the main requirements is to make sure that watermark is applied to all PDF reports

Best Regards,

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/comment/76433#Comment_76433

From there, it is not possible currently.

Thanks.

Mohammad Ghannam · Answer

Dear @Mallikarjuna Kuppauru-Oracle,

Thank you for your response, actually i am working on BIP Query to fetch all reports under custom folder. still i am not able to find the proper source, providing me a solution for it will be very helpful for me. thanks in advance.

dear @MandeepGupta , i checked the query but it will give you only the reports where defined as ESS. thanks for sharing but still not the required.

requirement is: get all PDF reports under custom folder inside the BI Server. even they are not registered as ESS Job.

thank you

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/28638/do-we-have-a-way-to-gather-all-xdo-reports-which-contains-only-pdf-output-please-check-the-below

Hi Mohammad,

Please check the query on below thread:

https://fusionhcmconsulting.com/2025/01/bip-report-to-extract-bip-scheduled-jobs/

In this query, you can pull data from ess_request_property where name = 'CONTROL_XML'. Value for this name will give you data that you are looking for.

Thanks.