Cognos Audit Report – Extracting Report XML and Data Item Usage

[Good Friend]

Is there a way to create a Cognos Audit Report that includes report details such as report name, report location/path, report owner, package name, report specification/XML, and the data items used in each report?

I'm able to retrieve most of the report and audit details, but I'm having difficulty incorporating the report XML/specification and extracting the data items used within each report into the same output.

Has anyone implemented something similar or have suggestions on the best approach to retrieve and combine this information? All our content data is stored in Oracle database.

[dougp]

The official answer would be to use the Cognos Analytics REST API.  But I'm not using it for this.  I don't remember if it's because I had a working solution before the REST API came along and I'm just lazy, or if I found that the REST API couldn't (yet?) do what I needed in this regard.

If you can query the Content Store database, report specs are on CMOBJPROPS7.

[Good Friend]

Thanks, that helps. I do have access to query the Content Store, so I'll look into CMOBJPROPS7 and trace the CMID back to the report metadata. My main goal is to combine the report specification XML with the audit details and then parse the XML to identify the data items used by each report.