How to know reports using Native SQL in FM from content store.

[joseph123]

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

[joseph123]

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

[kilaru2772]

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

[joseph123]

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.

[joseph123]

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

Thanks
Joseph

[Lynn]

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?

[joseph123]

Lynn

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