If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cognos Self service (Query Studio) Trace

Started by Asad Ch, 05 Oct 2016 12:37:42 PM

Previous topic - Next topic

Asad Ch

Can we trace Cognos Self service (Query Studio) that which user is accessing which tables in database. Cognos log table only showing only one package name against all entries. Can we segregate package name?

AnalyticsWithJay

I just responded to your post about COGIPF_NATIVEQUERY. You can join this table to COGIPF_USERLOGON on COGIPF_SESSIONID to find out which use executed which query.

There's no out of the box functionality for a list of tables.

Asad Ch

I'm trying the same thing but problem is that native query table is not populating even checks are implemented

AnalyticsWithJay

I just answered your other thread about data not populating.