Cognos 10.2 Audit database
Hi All,
The scheduled reports need to pull from audit db. The audit table cogipf_runreport is being used to pull scheduled reports. This table have target_type filed, which has more than 6 values, so which one to take to pull scheduled reports ?
If you have any detail document please provide.
BR,
Kumar
One answer
Hi Kumar,
CORRECTION: If you are a report designer, and would like to know how this column is used, here is the answer.
The values in COGIPF_TARGET_TYPE include:
- Report ReportService is an interactive report
- PromptForward ReportService is a report generated after a prompt
- PromptBackward ReportService is a report generated after the user moved to the previous prompt page
- Report BatchReportService is a batch or scheduled run report
Note: The value of this column is expressed in two parts: the object type of execution and from which service the report is run, for example "Report ReportService" and "Query BatchReportService".
Reference: Cognos Administration and Security Guide, page 761