Thursday, August 30, 2007

Auditing your Cognos user activity

When managing a PRODUCTION environment you may be required to log or audit user activity. Cognos 8 comes with a sample model and series of reports that can you help you achieve this goal. Ironically enough, the Framework Manager package is called Audit and can be found at …c8_location/webcontent/samples/Models/Audit/Audit.cpf.This sample Framework Manager package will give you a glimpse of some of the items that you can capture during a user session. Accompanying the Audit model is an Audit deployment package which has 10-12 reports. Some examples of the reports are:Execute reports by user -- Lists the reports that were run, by user and by package. It also includes the timestamp and execution time (in milliseconds) for each report. You can select a date and time range, one or more users, one or more packages, and one or more reports. Execution history by user -- Lists the reports that were run alphabetically, along with the package and timestamp, by user, since the logging database was created. It includes the total number of times each user ran each report and the total number of reports each user ranaltogether. It also includes the total number of reports run by all users. You can select one or more users for the report. After you run the audit report, you can choose to view the statistics for a particular report or for all reports.Logon operations by time stamp -- Shows logon and logoff timestamps and operations, by user. It also includes the total number of logons for each user and the total number of logons altogether. You can select the time period and one or more users for the report. Logon operations by user name -- Shows logon and logoff timestamp by user, along with the type of logoff operation that occurred. It also includes the total number of logons for each user and the total number of logons altogether. You can select one or more users for the report. You can also refer to Chapter 16 of the Administration and Security Guide for more details on how to implement and modify the Audit package and the Audit reports.
Posted by Ravi Sankaru Chinta at 12:00 AM
Labels:
Post a Comment