COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: mnirsber on 09 Jul 2020 02:08:45 PM

Title: Identify Pending Reports with Audit Tables
Post by: mnirsber on 09 Jul 2020 02:08:45 PM
Hi - I'm running Cognos 11.0.13.

Is it possible to identify reports running in current activities with a 'Pending' status within the audit tables?

I'm looking at the cogipf_runreport table.  The cogipf_status field is blank while the report is executing.  I'm also looking at the cogipf_action table. 

Hoping someone can share a solution or any ideas.

Thank you,
Mark