COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: bensah on 01 Oct 2015 06:28:31 AM

Title: Cognos 10.1 object details extraction
Post by: bensah on 01 Oct 2015 06:28:31 AM
Hi All,

Do you have query or way to find out the below information in my environment.

Information Required:-
Object Name
Object Type
Location or path
Last time it was executed
User who have executed

Cognos version:- 10.1
CM DB- Oracle 10g

I appreciate if you can share any query that I can execute in CM or audit db to get the above information.
Title: Re: Cognos 10.1 object details extraction
Post by: FerHidalgo on 14 Oct 2015 10:56:18 AM
Hi,

You should be able to get most or all of that information from the Audit Sample Model:
https://www-304.ibm.com/support/knowledgecenter/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cra.10.2.2.doc/c_sampleauditreports.html

Good luck!