how to check when users have logged in stat

[cognos05]

Hi All,

We have many users using products like report studio , analysis studio. We are not sure if they really use analysis studio for their analyses or just view the standard reports.
Can anyone let me know how can I track of this. Which logs should I enable.

Thanks,
Nithya

[cognos05]

Hi ,

Went through some previous post and got an idea of steps to be followed.

1) Create a separate database to store audit contents( in my case it will be a sql database)
2) In the IBM Cognos Configuration go to environment ,lgging and create a connection to this database with the credentials.
3) Test the connection,
4) Go to cognos administration and select the dispatcher and set the related properties with respect to logging level,

Is that all

Thanks,
Nithya

[cognos05]

The audit data is now being stored in my sql server tables. I am not sure which table will give me the information about which users have logged in to Analysis studio.
I want to report on this information.
USERLOGON gives who ever have logged in.but to differentiate from analysis or report studio is there any specific field.

Also how easy is to move these tables to Framework manager and create package and report from there.

Thanks,
Nithya

[bdbits]

If you are using the audit tables, you may want to look at the "audit extension" package from IBM Cognos - it is free. You could at least use the FM model as a starting point for your own package.

http://www.ibm.com/developerworks/data/library/cognos/development/utilities/page574.html

I am not sure studio usage is in there, but it might be. If not, you would probably have to build something off of the Cognos server log files. I am afraid this will likely be a lot more difficult to parse out.

[cognos05]

Hi bdbits,

I will check on that and thanks for the information.

How do we manage the audit data tables, because it adds an entry for user actions. how do we have control over it.

Thanks,
Nithya

[bdbits]

nithya1224, in retrospect maybe you just need the sample audit package bundled with Cognos.
http://pic.dhe.ibm.com/infocenter/cfpm/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ug_cra.10.1.0.doc%2Fug_cra_id4425SampleAuditReports.html

This or the previously linked audit extension (or maybe a combination) should get you want you want.

General control over audit logging is set in Cognos administration.
http://www-01.ibm.com/support/knowledgecenter/SSEP7J_10.2.1/com.ibm.swg.ba.cognos.ug_cra.10.2.1.1.doc/t_asg_setthelogginglevel.html%23asg_SettheLoggingLevel?lang=en