Hi - I have report folder with around 500 reports in it. Only few of the reports were using Direct SQLs in it. I want identify those reports which are using Direct SQLs.
I can open each report in report studio and identify, but I would like to know better method to do this. My current method is taking too long time..
Also tried reading the XML file for the entire 500 reports. But couldn't help much.
It will be a great help if you can throw some ideas to resolve this problem. I appreciate your help.
Thank You.
If I'm not mistaken the CM Browser tool from Cognos allows you to search report specifications. You just need to find out the search string for a SQL query in the report.
1. Create a blank report and add a SQL query
2. Copy the report specifications to clipboard, paste them in a word editor like notepad.
3. Find the XML reference to the SQL query. It will have some type of unique XML string.
4. Paste the unique string in CM Browser and search. It should return all reports that contain custom SQL queries in their specs.
Jay