Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: zazie95100 on August 29, 2008, 08:48:33 PM

Title: SQL request in CME database
Post by: zazie95100 on August 29, 2008, 08:48:33 PM

Hi ! 
I need help for writing an SQL request to extract agents list in a virtual group,
I don't know witch tables, fields to use ?
Is there any CME Model database diagram ?
I also need some examples of SQL request to list a folder


Thanks
:)

Title: Re: SQL request in CME database
Post by: tony on September 01, 2008, 08:50:29 AM

You may want to look at using the Genesys Config SDK for this purpose.  Although you [i]can [/i] create Queries in SQL against the Config Database, it is not recommended since it is intended as a single-threaded application.

Tony

Title: Re: SQL request in CME database
Post by: Dionysis on September 07, 2008, 01:31:58 PM

You definitely want to use the config SDK for this, much simpler, and safer.

I have had people bring down a config server by running complex queries on the cfg database, it's not pretty.

With that said though, if you are searching for a list of agents in a virtual skill group then you can do this by joining the cfg_person and cfg_skill_level tables on the person_dbid where skill = x.

If you want to use the actual virtual agent group then that will take a lot more joining, using the agent group and flex prop tables.  I would not do this on a live copy of the database.
8)

Title: Re: SQL request in CME database
Post by: René on September 11, 2008, 07:50:15 PM

Hi,

You can't get such information from configuration database as it isn't there. Virtual Agent Group = dynamic group where membership is based on defined conditions. Genesys added ability to view list of agents for particular VAG in CME but that request is processed by Configuration Server in its memory.

You have to use Genesys SDK to get required list.

R.