COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: svccxtech on 14 Oct 2014 07:00:49 PM

Title: Listing all reports in Public folder and subfolders
Post by: svccxtech on 14 Oct 2014 07:00:49 PM
I have been asked to make a list of all existing reports in the Public folder and subfolders.
Has anyone done this?  We are using an Informix db. 
I am hoping that I don't have to go through each folder manually and write them down....   :P
Title: Re: Listing all reports in Public folder and subfolders
Post by: svccxtech on 16 Oct 2014 12:57:26 PM
I ended up doing a copy/paste of the screen contents.  Not too painful...

But if anyone has knowledge of a better way, please let me know!
Title: Re: Listing all reports in Public folder and subfolders
Post by: CognosPaul on 16 Oct 2014 05:22:48 PM
Third party tools, like MetaManager or Motio can do this.

I wrote a script (http://cognospaul.com/2014/03/11/export-report-xmls-file-system-updated/) that will loop through and pull out all of the reports in the content store. You might be able to adapt that to meet your needs. The SQL is based on SQL Server 2005, so you'll need to adapt the SQL, especially the nested loop.
Title: Re: Listing all reports in Public folder and subfolders
Post by: Yunus on 20 Oct 2014 12:00:59 PM
Use search results to get multiple folders at once.  It's still a copy/paste operation but it works.