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

 

How to get Cognos module names with the users who use them in the repo?

Started by jc.castellana, 30 Mar 2015 04:31:59 AM

Previous topic - Next topic

jc.castellana

Hi everyone,

I need to get these infos from the Cognos repository (AS or CS ?) and also the number of simultaneous connexions to a module for a certain period.

Example :

Period : from 01/03/2015 to 30/03/2015

User    | Module           | Nb connections

user 1 | Query Studio  | 5
user 2 | Report Studio | 2
user 3 | Event Studio   | 3
...........|......................|.......


Thanks in advance !

bdbits

You might be able to extract this from the audit logs, if you have them enabled. Also you should probably take a look at the "audit extension" from IBM (free). This provides a thin metadata layer to audit data. I do not know if these particular items are in there, but it is worth a look.
http://www.ibm.com/developerworks/data/library/cognos/development/utilities/page574.html

jc.castellana

I don't find the infos from the Audit package and I wanna do this without extensions.
Can you show me the place where I can find the module infos?

vasudevdchavan

SDK is the only solution and also there are some paid tools from BSP,MOTICI which give this function i think.

Andrew Weiss

jc,

Our Integrated Control Suite (Version Control) solution does some high level tracking of Studio Usage by User.  The use case behind this is to help justify keeping or releasing certain licenses for users based on how much they actually use the studio.  There is a tracking report in the product that indicates by day whether or not the user used the studio.  This way you can report "Joe used Query Studio 100 of the last 120 days where as Bob used it twice.  Perhaps Joe can build reports for Bob and we can re-purpose his license".

There is some information on the user tracking and broadcast messaging features located here:
http://www.bspsoftware.com/Products/ICS/Version/

We're also showing a webinar next week on our Version Control Solution which you can check out here:
http://www.bspsoftware.com/version-control-for-ibm-cognos-webinar/

Thanks!
-Andy
MetaManager makes administering IBM Cognos a breeze.  http://www.bspsoftware.com/MetaManager