Setting up audit reporting

Before you can create audit reports or use the sample audit reports that come with IBM® Cognos® software, you must set up audit reporting.

To enable audit reporting, set the logging level for all or selected IBM Cognos services to Basic (auditing enabled) or Request. If you set the logging level to Minimal, auditing is disabled. Use Full logging and Trace levels only for detailed troubleshooting purposes, under the guidance of customer support. They might significantly degrade the server performance.

Procedure

Set up a logging database in the database system that is used by your organization.

For more information, see the guidelines for creating a logging database in the IBM Cognos Analytics Installation and Configuration Guide.
In IBM Cognos Configuration, under Environment > Logging, configure log messages to be sent to the database that you created in step 1.
In Cognos Administration, set the appropriate logging levels for the Cognos services.
1. Go to Manage > Administration console.
2. On the Status tab, select System.
3. In the Scorecard pane, select the All dispatchers view.
4. From your dispatcher actions menu, click Set properties, and click the Settings tab.
5. From the Category drop-down list, select Logging.
6. Set the logging level to Basic for the following services: Content Manager Cache service, Content Manager service, query service. You can enable audit logging for other services, depending on your organization requirements, or even for all services if you are not concerned about the impact on server performance.
7. To enable native query logging in Compatible Query Mode (CQM), select both of these check boxes:
  - Audit the native query for batch report service
  - Audit the native query for report service
8. To enable native query logging in Dynamic Query Mode (DQM), set Audit logging level for query service to Request or higher.
9. Click OK.
In Cognos Configuration, restart the IBM Cognos service.