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

Report of usage of *Studio by User

Started by birliban, 05 Feb 2010 07:22:38 AM

Previous topic - Next topic

birliban

Hi,

as written in the subject i try to get an overview of the usage for the different studios. Like:
User A started Report Studio at ABC o'clock
User A closed Report Studio at FGE o'clock

So i did set up database auditing (all samples working fine) and hoped to finde clues in there....
Well looks like i'm not smart enough -.-

Anyone can point me to where to gather the informations i need ?

Thx in advance!

PS: Cognos 8.4

redmist

I create audit report using the following logic

Adhoc cube analysis using Analysis Studio is identified by the combination of
[Audit].[COGIPF_EDITQUERY].[QUERY NAME] = 'adHocReport'
AND
[Audit].[COGIPF_EDITQUERY].[TARGET TYPE] = 'Analysis ReportService'

Predefined cube analysis using Analysis Studio is identified by the combination of
[Audit].[COGIPF_EDITQUERY].[QUERY NAME] <> 'adHocReport'
AND
[Audit].[COGIPF_EDITQUERY].[TARGET TYPE] = 'Analysis ReportService'


Query Studio users identified by
[Audit].[COGIPF_EDITQUERY].[TARGET TYPE] = 'Query ReportService'


Users running Prompt report identified by
[Audit].[Run Reports].[Report type] in ('Report reportservice', 'Report promptforward reportservice')

birliban


birliban

Well, I got execution reports for Analysis Studio, Report Studio and Query Studio (by user and timestamp).

Only Event Studio is still silent ... any more advice ?