List of reports with Search path

[jeeva]

Hi,

we need to create a list report in report studio to list out all the report names from public folder and my folder for each user with search path.
for this we are using content store tables to get all report names,store id's, but we are unable find the report search path.

how can we get the search path for each report. please give me your suggestions.

Thanks.

[cognos810]

Hello Thanay,
I really doubt that you would be able to get to a column in some table in the content store that holds the path value for the objects. What you do have is the CMID and the PCMID(CMID of the parent) in the CMOBJECTS table, which you will have to recursively query to get to the parent of each object all the way to the top, at each recursion checking for type of the container(package or folder) and getting its name from the CMOBJNAMES table. You may have to write a Function/Stored Procedure to achieve this. To narrow it down to reports only, you can filter the records in CMOBJECTS to CLASSID=10 which I believe is of type report.
Lets see what others have to input.

-Cognos810

[Andrew Weiss]

Thanay,

Avnet's MetaManager can document this to PDF, Excel or even a database for you easily.  There is a short video on the Content Documenter module located here: http://www.bspsoftware.com/products/metamanager/Document/

From that page you can also access the downloads and try it for your self.

Thanks,
-Andy

[Cognos KW]

Thanay,

Attached SQL Query gives Folder name and Search path from Cognos Public Folder. You could modify the query to return the report name and Search Path.

Cheers,
KW