If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Direct SQLs Identification

Started by vummadis, 10 Aug 2016 04:06:50 PM

Previous topic - Next topic

vummadis

Hi - I have report folder with 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. 

bdbits

This was originally on the tail end of an unrelated thread so I split it out. Then found it was a dupe - please refer to point 4 in the Forum Etiquette http://www.cognoise.com/index.php/topic,24030.0.html.

Followups to http://www.cognoise.com/index.php/topic,31287.0.html.