Hello,
How can I get the following details about the reports?Is it possible?
Number of reports / queries defined (by folder??)
Last time executed
Number of times executed in last week/month/year
How the data was output (PDF, Excel, HTML)
Regards,
Joker
Take a look at the (free) audit extension package. It comes with a bunch of reports that have most of what you want. You can modify them or build your own - a Cognos package and FM model is provided.
http://www.ibm.com/developerworks/data/library/cognos/development/utilities/page574.html (http://www.ibm.com/developerworks/data/library/cognos/development/utilities/page574.html)
Quote from: bdbits on 08 Sep 2014 09:11:30 AM
Take a look at the (free) audit extension package. It comes with a bunch of reports that have most of what you want. You can modify them or build your own - a Cognos package and FM model is provided.
http://www.ibm.com/developerworks/data/library/cognos/development/utilities/page574.html (http://www.ibm.com/developerworks/data/library/cognos/development/utilities/page574.html)
Thanks for the reply bdbits..
Actually we have a audit package and timestamp field is there that shows the report run time. But the reuirement is to get the time period between the last 2 runs (for example, for a report scheduled on a weekly basis, you would expect to see 7 days between report runs).How should I achieve this?
Warm regards,
Joker