If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Listing all reports in Public folder and subfolders

Started by svccxtech, 14 Oct 2014 07:00:49 PM

Previous topic - Next topic

svccxtech

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

svccxtech

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!

CognosPaul

Third party tools, like MetaManager or Motio can do this.

I wrote a script 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.

Yunus

Use search results to get multiple folders at once.  It's still a copy/paste operation but it works.