IBM Cognos Audit

Cognos Audit is a lifesaver for the Cognos Administrators all over the world. IBM Cognos software provides a sample model and multiple reports. Cognos Audit is very handy to track different operations being performed in the Cognos environment. A separate database called Audit DB will have to be created for storing this information. This is typical Cognos Administration work.

Here is the complete documentation for Cognos Audit configuration:
http://www-01.ibm.com/support/docview.wss?uid=swg21996317

Video tutorial for Cognos Audit:

List of tables that get created once Cognos Audit is configured:

COGIPF_ACTION : Stores information about the operation performed on an object.
COGIPF_USERLOGON : Stores user logon (including log off) information
COGIPF_NATIVEQUERY : Stores information about third-party queries to Cognos components
COGIPF_PARAMETER : Stores custom information logged by a component
COGIPF_RUNJOB : Stores information about job requests
COGIPF_RUNJOBSTEP : Stores information about job request steps
COGIPF_RUNREPORT : Stores information about report executions
COGIPF_VIEWREPORT : Stores information about report view requests
COGIPF_SYSPROPS : Stores version information about the schema for upgrade purposes
COGIPF_EDITQUERY: Stores information about query runs
COGIPF_AGENTBUILD: Stores information about agent mail delivery
COGIPF_AGENTRUN: Stores information about agent activity including tasks and delivery
COGIPF_THRESHOLD _VIOLATIONS : Stores information about threshold violations for system metrics

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

Up ↑

%d bloggers like this: