Hi Josef,
To be able to report on this you first need to set an extra parameter in the configuration of the Cognos environment. It is described here:
https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=reference-report-service-batch-report-service-advanced-settingsLook for RSVP.PARAMETERS.LOG. You will need to add this extra parameter in the Advanced settings section accessible by starting the Administration Console, System, with value TRUE. After that you will need to restart your dispatchers.
Beside this extra parameter also check your settings regarding the logging levels as they need to be set to Basic as a minimum.
After this the run option of your report will now be logged in the AUDIT database in table COGIPF_PARAMETER, column COGIPF_PARAMETER_VALUE_BLOB. Despite the name of the column it is a value in Text format. The format is part of a very large string.
Goodluck
Han
------------------------------
Han Frieling
------------------------------
Original Message:
Sent: Mon September 06, 2021 12:03 PM
From: Josef Minarik
Subject: Cognos Audit Report Format
Anyone has an idea?
------------------------------
Josef Minarik
https://www.linkedin.com/in/josef-minarik/
Original Message:
Sent: Wed May 12, 2021 06:57 AM
From: Josef Minarik
Subject: Cognos Audit Report Format
Hi, is there any way how to get REPORT FORMAT of run reports from audit data? I do not see it in COGIPF_RUNREPORT Table. I found the option only for view option of saved reports. We use CA 11.1.7
Thank you.
------------------------------
Josef Minarik
------------------------------
#CognosAnalyticswithWatson