IBM Support

Cognos IPF Audit table descriptions

Troubleshooting


Problem

What are the tables in the Cognos IPF Audit database?

Symptom

n/a

Resolving The Problem


Description of the Cognos IPF Audit tables:

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

Related Documents:

Administration and Security Guide, chapter 15: Audit Reports
Administration and Security guide for IBM Cognos 8.3 and 8.4 , Appendix G : Data Schema for log messages

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.1;10.1.1;10.2;10.2.1;10.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SUNSET","label":"PRODUCT REMOVED"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"ReportNet","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
15 June 2018

UID

swg21339087

Page Feedback