COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: cognos_guru on 05 May 2009 01:22:13 PM

Title: Cognos Auditing Tables - Where is the Data Source info stored?
Post by: cognos_guru on 05 May 2009 01:22:13 PM
Does anyone know which table in the Cognos audit database contains information related to the data source a report uses when it is being executed? 

I can't seem to find it... 
Title: Re: Cognos Auditing Tables - Where is the Data Source info stored?
Post by: nimmyjis on 22 May 2009 02:07:12 AM
Hi
The content manager table CMOBJPROPS11 stores the data sources configuration details like connect
string, the cube location etc.It will be ther in C82_Content DB
Title: Re: Cognos Auditing Tables - Where is the Data Source info stored?
Post by: engineerairborne on 02 Nov 2009 10:00:56 AM
I'm running into this same issue, did you ever figure out what it was? I have some entries that have the AD information, but I think that it was placed in this table from version 8.1 and carried over when we upgraded to 8.2 a long time ago.