Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Adroit on April 10, 2013, 06:29:29 PM

Title: list of persons
Post by: Adroit on April 10, 2013, 06:29:29 PM

Hi All,

Need a query to list all the agents (who does not have agent login id mapped to them) and the folder name(with the parent folders name) where they are present.

Please help.

Thanks!

Title: Re: list of persons
Post by: vjicecool on April 11, 2013, 12:41:42 AM

I think you need to query the config db
using the query tool log in there and write some query

Title: Re: list of persons
Post by: Adroit on April 11, 2013, 08:53:18 AM

yeah i need to query config db...i wanted help in writing a query for the result required for the above mentioned scenario. :)

Title: Re: list of persons
Post by: genesysguru on April 11, 2013, 09:28:53 AM

PSDK is the officially supported method for accessing the configuration database ....

Title: Re: list of persons
Post by: eduardosaito on April 12, 2013, 11:26:14 AM

I think you will have to use these cfg tables :

- cfg_agent_login
- cfg_login_info
- cfg_person
- cfg_obj_folder
- cfg_folder

Depending on how many folder levels you are using in your setup, you will have to use more than one cfg_obj_folder and cfg_folder combo.

Hope you could understand what I meant since I am kinda asleep because my children woke up very early today =)