Hello Cognos Experts,

I'm looking SQL query for the Cognos content store database to extract details about scheduled reports. Specifically, I need a query that will provide:

• Schedule Owner Name
• Schedule Owner Email
• Report Name/View Name
• Report Location
• Status (filtering for "Failed" reports)
• Failure Reason

Your expertise in helping with this query would be greatly appreciated.

Thank you!

Hi Nabin,
Take a look at this discussion. I think this query has everything you will need.

https://community.ibm.com/community/user/businessanalytics/discussion/create-a-report-from-the-content-store-db-providing-details-of-schedules#bm36d34b4a-1746-4fa1-961d-c47c56be2023

Hello Cognos Experts,

I'm looking SQL query for the Cognos content store database to extract details about scheduled reports. Specifically, I need a query that will provide:

• Schedule Owner Name
• Schedule Owner Email
• Report Name/View Name
• Report Location
• Status (filtering for "Failed" reports)
• Failure Reason

Your expertise in helping with this query would be greatly appreciated.

Thank you!

Thank you for the information, Thomas. It seems we need to input the XML values to retrieve the data. Could you please provide further details on what needs to be added?

                         FROM CMOBJPROPS26 t
                              CROSS JOIN
                              XMLTABLE (
                                  '/SOAP-ENC/value/item[@xsi:type="bus:addressSMTP"]'
                                  PASSING XMLType (
                                                 '<?xml version="1.0" encoding="utf-8"?>
<SOAP-ENC xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">'
                                              || t.delivoptions
                                              || '</SOAP-ENC>')
                                  COLUMNS address    VARCHAR2 (200) PATH 'text()')
                              x

Hi Nabin,
Take a look at this discussion. I think this query has everything you will need.

https://community.ibm.com/community/user/businessanalytics/discussion/create-a-report-from-the-content-store-db-providing-details-of-schedules#bm36d34b4a-1746-4fa1-961d-c47c56be2023

Hello Cognos Experts,

I'm looking SQL query for the Cognos content store database to extract details about scheduled reports. Specifically, I need a query that will provide:

• Schedule Owner Name
• Schedule Owner Email
• Report Name/View Name
• Report Location
• Status (filtering for "Failed" reports)
• Failure Reason

Your expertise in helping with this query would be greatly appreciated.

Thank you!

Hello Cognos Experts,

I'm looking SQL query for the Cognos content store database to extract details about scheduled reports. Specifically, I need a query that will provide:

• Schedule Owner Name
• Schedule Owner Email
• Report Name/View Name
• Report Location
• Status (filtering for "Failed" reports)
• Failure Reason

Your expertise in helping with this query would be greatly appreciated.

Thank you!