How to find the Cognos Reports not running from 35 days using Audit Package

[Kiran Kandavalli]

Team,

Using Audit Package, is there a way that we can find the Cognos Reports not running from 35 days?

Thanks!
Kiran

[dougp]

That depends on the specifics of your requirement.  If it's as simple as...

List all of the reports in Cognos that have not been run in 35 days.

...that is not possible using only the Audit database.  The Audit database does not list all of the reports in the system.  I lists usage of those reports.  No usage, no entry.

You'll need to start with a query from the Content Store database to identify all of your reports.  Then you can run an audit report (join in the Audit data) for report runs in the last 35 days and see what's missing.