Cognos Analytics

Hello,

You won't find any information about the schema of the Content Store. It is designed to store metadata to be read and updated by the IBM Cognos service principal only. I think you will find some instances where well meaning admins have destroyed their instance. For this reason you should not be connecting to this database and is the reason there is no published schema.

In addition, each fix pack and update will potentially alter tables. 

https://www.ibm.com/support/pages/faq-security-concerns-regarding-credentials-stored-content-store "Content Store is considered a black box environment, one MUST NOT access the tables with anything but IBM Cognos BI functionality."

Not sure what you are trying to achieve, but you should investigate extracting information with report schedules, audit reports, audit extension, or SDK. This will ensure security of your database and stability of the Cognos application. 

Hello,

You won't find any information about the schema of the Content Store. It is designed to store metadata to be read and updated by the IBM Cognos service principal only. I think you will find some instances where well meaning admins have destroyed their instance. For this reason you should not be connecting to this database and is the reason there is no published schema.

In addition, each fix pack and update will potentially alter tables. 

https://www.ibm.com/support/pages/faq-security-concerns-regarding-credentials-stored-content-store "Content Store is considered a black box environment, one MUST NOT access the tables with anything but IBM Cognos BI functionality."

Not sure what you are trying to achieve, but you should investigate extracting information with report schedules, audit reports, audit extension, or SDK. This will ensure security of your database and stability of the Cognos application.