Cognos Analytics

 View Only
  • 1.  Content Store tables

    Posted Fri June 12, 2020 03:06 PM
    Hi all

    I need to find out which Content Store table contains the folder path for the report and owner. Anyone found it?

    thanks

    ------------------------------
    andy
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Content Store tables

    Posted Mon June 15, 2020 09:18 AM
    Here is some MS Sql code that I run against the CM database to get a list of all CM objects along with package names, paths and owners. Owners is tricky and for my CM it mostly returns Unknown unless the report was created recently. I attribute this to the fact that we have a very mature system. Most reports were written by people who are no longer with the company also we have gone through many different domain management systems (LDAP, AD, etc)​. My clients tell me that from within Cognos they see the owner as Linda Smith, but my report shows Unknown. I am guessing that when the report is written the owner is inserted into table cmobjprops33. But once there is a change of ownership or maybe change of domain system that it is then stored somewhere else. If you find out please post here.

    CREATE TABLE [dbo]