Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: susmiths on 07 Dec 2016 09:04:04 PM

Title: Query to list all reports in Public Folders
Post by: susmiths on 07 Dec 2016 09:04:04 PM
Hi Guys,

I am looking for a query to get all reports and their locations (which were not deleted) from content store. I tried getting it from COGIPF_RUNREPORT, but it doesn't have report shortcuts and it has reports which were deleted or moved too.

Any help is appreciated.
Title: Re: Query to list all reports in Public Folders
Post by: Raghuvir on 30 Dec 2016 02:15:15 AM
Quote from: susmiths on 07 Dec 2016 09:04:04 PM
Hi Guys,

I am looking for a query to get all reports and their locations (which were not deleted) from content store. I tried getting it from COGIPF_RUNREPORT, but it doesn't have report shortcuts and it has reports which were deleted or moved too.

Any help is appreciated.

Hi,

Please find the below link, it might be helpful.

http://www.cognoise.com/index.php?topic=7243.0

Regards
Text only | Text with Images