COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: Kiran Kandavalli on 26 May 2021 03:04:34 PM

Title: How to find the Cognos Reports not running from 35 days using Audit Package
Post by: Kiran Kandavalli on 26 May 2021 03:04:34 PM
Team,

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

Thanks!
Kiran
Title: Re: How to find the Cognos Reports not running from 35 days using Audit Package
Post by: dougp on 27 May 2021 10:15:19 AM
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.