SQL Query needed to get the IRD Strategy names and subroutines being used in CME

anyone has SQL Query to get the IRD Strategy names and subroutines being used from Genesys config database tables

select * from cfg_script s
where s.type = 5

Thanks..i also need only those that are currently loaded on CDN.

To do that you’ll need to compare the above query with the “cfg_flex_prop” table which holds all of the annex tab data.

There’s a thread somewhere which has useful SQL scripts, pretty sure what you’re looking for is there.

http://www.sggu.com/smf/index.php/topic,9724.msg44061.html#msg44061
http://www.sggu.com/smf/index.php/topic,9136.0.html