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

[msrc1234]

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

[hsujdik]

select * from cfg_script s
where s.type = 5

[msrc1234]

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

[Dionysis]

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.

[Adam G]

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