Audit tables - how to retrieve information on failed Events

[andrewpontes]

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,

[andrewpontes]

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.