Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: msrc1234 on September 21, 2016, 06:16:38 PM

Title: SQL Query needed to get the IRD Strategy names and subroutines being used in CME
Post by: msrc1234 on September 21, 2016, 06:16:38 PM

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

Title: Re: SQL Query needed to get the IRD Strategy names and subroutines being used in CME
Post by: hsujdik on September 21, 2016, 06:28:28 PM

select * from cfg_script s
where s.type = 5

Title: Re: SQL Query needed to get the IRD Strategy names and subroutines being used in CME
Post by: msrc1234 on September 21, 2016, 07:45:31 PM

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

Title: Re: SQL Query needed to get the IRD Strategy names and subroutines being used in CME
Post by: Dionysis on September 21, 2016, 08:17:20 PM

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.

Title: Re: SQL Query needed to get the IRD Strategy names and subroutines being used in CME
Post by: Adam G on September 23, 2016, 12:28:17 PM

[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]