Hello friends,
Is there a way to extract details about report query/queries using Content Store tables? For each report, we want to extract information about the package each query is built upon and list items pulled in each query. Also we want to extract SQL definition of each item.
The version we're using is 10.2.2.
I would really appreciate if you could share a query to extract all such information or give me some pointers.
Thank you.
- John.
Hi,
Below is a post regarding querying the Content Store DB to get basic info for reports and packages used.
https://www.cognoise.com/index.php/topic,28289.msg113869.html#msg113869 (https://www.cognoise.com/index.php/topic,28289.msg113869.html#msg113869)
maybe you can start from here.
I had already looked at that posting, but didn't find it useful. The query posted by the user has a table named as "CognosContent", but there is no such table in our Content Store database.
Quote from: johnmsp on 27 Jul 2018 09:15:05 AM
I had already looked at that posting, but didn't find it useful. The query posted by the user has a table named as "CognosContent", but there is no such table in our Content Store database.
Directly accessing the content store is not recommended as a best practice since it can change from one version to another. The table in question may have existed once upon a time. The SDK is a more reliable way to access information if you have access and skills necessary. There are also 3rd party tools that might be useful.
Having said all that, I do think I've seen more posts on Cognoise and elsewhere about direct access to the content store. Maybe others will chime in with more information.