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!
------------------------------
Nabin Poudyal
------------------------------