All Report names in public folder with SQL query

[Shamar]

Hello Gurus !!!

I need to get the list of Folders, Sub-folders and report names  which is in public folder.
We have some 15 folders and it has sub folders with nearly 400 reports . Purpose of this, is for documenting.
Can anyone please provide me the ContentStore query.


Thanks,
Shantha kumar

[Andrew Weiss]

Shamar,

Have a look at MetaManager's Content Store Documenter Module.  You can download a trial version here.
http://www.bspsoftware.com/products/metamanager/Document/

With Content Documenter you can easily document the Public Folders as well as the My Folders.  You can document everything or filter on specific object types.  In addition you document information that isn't readily available in the content store tables, such as security, linkage to other objects, usage, etc.  The documents supports outputting the information to PDF, HTML, Native Multisheeet Excel documents, XML and direct to a SQL Server or Oracle database.

Let me know if you need any help.

Thanks,
-Andy