Table Definitions

Log messages are recorded in a table in the logging database under certain conditions. These conditions depend on the logging level that you configure in the Web portal.

For information about logging levels, see Log Messages.

When a user logs on to IBM® Cognos® software, a session ID is assigned and recorded in all log messages. You can use the session ID to identify all actions performed by a user.

The database table definitions that are created in the logging database are described in the following table, with a cross-reference to associated column definitions.

Table 1. Logging database table definitions
Table Name	Description
COGIPF_ACTION	Stores information about operations performed on objects
COGIPF_AGENTBUILD	Stores information about agent mail delivery
COGIPF_AGENTRUN	Stores information about agent activity including tasks and delivery
COGIPF_ANNOTATIONSERVICE	Stores audit information about Annotation service operations
COGIPF_EDITQUERY	Stores information about query runs
COGIPF_HUMANTASKSERVICE	Stores audit information about Human Task service operations (tasks and corresponding task states)
COGIPF_HUMANTASKSERVICE _DETAIL	Stores additional details about Human Task service operations (not necessarily required for every audit entry, for example, notification details and human role details)
COGIPF_NATIVEQUERY	Stores information about queries that IBM Cognos software makes to other components
COGIPF_PARAMETER	Stores parameter information logged by a component
COGIPF_RUNJOB	Stores information about job runs
COGIPF_RUNJOBSTEP	Stores information about job step runs
COGIPF_RUNREPORT	Stores information about report runs
COGIPF_THRESHOLD _VIOLATIONS	Stores information about threshold violations for system metrics
COGIPF_USERLOGON	Stores user logon and logoff information
COGIPF_VIEWREPORT	Stores information about report view requests