" /> SQL request in CME database - Genesys CTI User Forum
« previous next »
Pages: [1]   Go Down

Author Topic: SQL request in CME database  (Read 3789 times)

This topic contains a post which is marked as Best Answer. Press here if you would like to see it.

zazie95100

  • Guest
SQL request in CME database
« on: August 29, 2008, 08:48:33 PM »
Advertisement
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
:)
Logged

tony

  • Guest
Re: SQL request in CME database
« Reply #1 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
Logged

Offline Dionysis

  • Sr. Member
  • ****
  • Posts: 408
  • Karma: 8
Re: SQL request in CME database
« Reply #2 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)
Logged
Marked as best answer by on May 02, 2025, 01:52:51 AM

Offline René

  • Administrator
  • Hero Member
  • *****
  • Posts: 1832
  • Karma: 62
Re: SQL request in CME database
« Reply #3 on: September 11, 2008, 07:50:15 PM »
  • Undo Best Answer
    • 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.
    Logged
    Pages: [1]   Go Up
    « previous next »