COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS Connection => Topic started by: jriley on 15 Jul 2010 08:01:26 AM

Title: how to gather list of reports in public folder modified within a timeframe
Post by: jriley on 15 Jul 2010 08:01:26 AM
good morning.

i know i can open individual report folders and do an advanced search and filter by modified parameter, but i can only do this one folder at a time to get a detail list of reports.  is there another way to get a list of all report files modified within the public folder? 

And if so, can this be exported from within cognos connection? 

Or if there is another place to find this info on the backend that would probably be best to meet my requirements and output. 

We are using 8.3 with Oracle 11g backend. 

Thanks,
Joe
Title: Re: how to gather list of reports in public folder modified within a timeframe
Post by: jriley on 26 Jul 2010 10:48:02 AM
haven't been able to find anything further.  so have gone into each individual folder and done an advanced search and edited the modified drop to within last week.  but have to do this at each individual folder which makes it a little time consuming.  will post further info if i can find another way.  the output i've gotten is sufficient for our management requirement at this point.  just wish there was an easier way to do this.

thanks.
joe
Title: Re: how to gather list of reports in public folder modified within a timeframe
Post by: tupac_rd on 26 Jul 2010 11:50:35 AM
I think you can look for all the reports within Public Folders that are modified in the last week, but I don't think you can export from within Cognos Connection. This is in 8.4

Click on Search from the main page, Click Advanced. Under Modified, select 'In Last Week' instead of 'Any', Under Scope change it to 'Public Folders' etc.,

Hope this is what you were looking for...
Title: Re: how to gather list of reports in public folder modified within a timeframe
Post by: peritas-chris on 24 Aug 2010 12:28:46 PM
The Audit package delivered with Cognos 8 should be able to get this information for you.  If not, there is also an Extended Audit package available to Cognos customers.

Feel free to message me if you want further information!
Title: Re: how to gather list of reports in public folder modified within a timeframe
Post by: MFGF on 26 Aug 2010 05:19:38 AM
Quote from: peritas-chris on 24 Aug 2010 12:28:46 PMFeel free to message me if you want further information!

Or, preferably, ask the question publicly on here so that any supplied answers will be available to other forum members who may have similar queries. :)

MF.
Title: Re: how to gather list of reports in public folder modified within a timeframe
Post by: peritas-chris on 26 Aug 2010 02:29:41 PM
Here is the link for others who may want to use this package:

http://www.ibm.com/developerworks/data/library/cognos/development/utilities/page509.html

Have fun!