Audit Report

[babu babu]

Hi,

How to get user's last login and which reports they ran and how many active users?
Please give me the advice.

Thanks!
Anand.

[sashafay]

Do you have Audit package installed? If you do, use User Logins query subject and select MAX(Logon Time) with Group By User Name to get a last user login as well as all active users. To get a list of all reports that user's run use another query subject Run Reports with combination of User Name, Report Name and Time Stamp.

Hope that helps...

[babu babu]

Hi Sashafay,

Thanks for your reply.I have audit package available in samples and it is pointing to some COGIPF_XXXX tables with datasource name audit.But i am not able to see these table in content store.when i opened that content store in toad i am not able to see any information in that.Please give me the advice where i can see that cogipf_xxxx tables.

Thanks!
Anand.

[sashafay]

Anand - why you are trying make this more complicated? You asked how to run reports, not where the tables located? You have a package that gives everything for you what you asked in your question. Anyway, you need to find a location through Cognos Configuration, where you tables are stored. If you Audit db was enable, all tables should be there. Also, make sure you change level of login from Minimal to Basic, for normal non-debug mode. Don't try over complicated, otherwise your log files will be overloaded with unnecessary information that you will never used, but instead you will kill performance of your system. Hope that will give you what to do/look next.