Get report name, package, and path from Cognos content store database

While working with a client on a Cognos upgrade effort, I was asked to provide a list of each report by the package it sourced. Since I am a database fanatic I prefer to get this information directly from the Cognos content store. Ultimately, I was able to provide a list with each Report name,…

Get User, Group, and Role information from the Cognos content store database

The Cognos content store database has a lot of valuable information, however, it is not always so easy to find this information. The following query can be useful for returning User, Group, and Role information from the Cognos Content Store database. Many of my client engagements ask for details around their users and roles, especially…