list of persons

[Adroit]

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!

[vjicecool]

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

[Adroit]

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

[genesysguru]

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

[eduardosaito]

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 =)