Print Page - Content store DB(COGCM) details for Past activities in Conos

Title: Content store DB(COGCM) details for Past activities in Conos
Post by: Anisha_digit on 31 Mar 2020 01:28:12 AM

Hi All,

Please help to find out the past activity details from the Content store DB.
Could anyone please suggest how to get the below columns " report name"," Requested time ", " Run By "," Status" or " scheduled by " from the Content store DB.

Thank you in advanced.

Title: Re: Content store DB(COGCM) details for Past activities in Conos
Post by: MichaelB on 31 Mar 2020 08:47:50 AM

What you are referring to is not found in the Content Store but is found in the Audit tables. Those tables are actually labeled fairly well to let you know what they are referring to. In the Audit tables, if you are looking for report info COGIPF_RUNREPORT should be what you need.

Title: Re: Content store DB(COGCM) details for Past activities in Conos
Post by: Anisha_digit on 01 Apr 2020 07:28:28 AM

Hi ,

Please refer for the same format in the Content Store database, not the Audit database.

Thanks in advanced

Title: Re: Content store DB(COGCM) details for Past activities in Conos
Post by: MichaelB on 02 Apr 2020 11:44:59 AM

There is no historical run data in the Content Store.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Administration and Security => Topic started by: Anisha_digit on 31 Mar 2020 01:28:12 AM