COGNOiSe.com - The IBM Cognos Community

Hi All

I have a req. of listing all the reports using Native SQL for Query subjects created in FM.
Does any one knows where the SQL stores (which table in Content Store) in Content Store.

Thanks & Regards,
Joseph

Does any one knows what are the tables to be joined to pull Native SQL reports.

i am not sure if this helps, this is something for finding sql based reports


select n.cmid, n.name, p.spec from CMOBJNAMES n, CMOBJPROPS7 p where n.cmid = p.cmid and p.spec like '<report %' and p.spec like '%<sqlText>%' order by n.name

Thanks for your response.

This SQL works well only for the reports with Native SQL in Report Studio.
It doesn't work, If I run the same SQL report after embedding and  publishing in FM.

Is some one knows the SQL to find out the reports using native SQl.
I need this very urgent.

Thanks
Joseph

If you know which FM query subjects are SQL-based then could you use the report dependencies tool in FM to find what you are looking for?

Lynn

Thanks for Reply.
We have hundreds of reports built on SQL arranged in a specific folder.