Hi There,
I have been struggling to retrieve data from the audit tables in the Cognos 8.4.0 environment I am working on.
I writing a dashboard to show failed reports in a past period. It is all good with the data coming from COGIPF_RUNREPORT Table.
What I am finding extremely challenging is to retrieve information on failed events and link the failed events with their respective reports, when applicable. I tried COGIPF_AGENTRUN Table with no success. One of the problems is that the table does not hold the Event name.
According to IBM documentation on http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_cra.8.4.0.doc/ug_cra_id3087LoggingLevels.html, REQUEST ID is the key to link the tables, however I noticed the REQUEST IDs in the two tables mismatch.
Does anyone know if it is possible:
- Is it possible to retrieve Event name ?
- Is there any relationship between the two above-mentioned tables ?
Thanks,
I managed to retrieve agent name. There is a sample report in the SMM - AUditing showing how to do it. However, I can't find any documentation and no luck with answers how to retrieve information on failed agents.
From what I notice, only successful agents are stored in COGIPF_AGENTRUN.
Much appreciate if anyone knows how to do it.