Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Anth on November 03, 2010, 03:23:19 PM

Title: Complete list of users with Agent Logon??
Post by: Anth on November 03, 2010, 03:23:19 PM
Hello all,

Just checked. dbo.cfg_agent_logon and dbo.cfg_person and there seems to be no linked reference to each other. so i guess my question is.... Is there another table which the 2 link together? so i can find out which users have what ACD Logon?

Without using Brio, etc

Regards
Title: Re: Complete list of users with Agent Logon??
Post by: bounty on November 03, 2010, 04:11:16 PM
Look at [b]cfg_login_info[/b], you will find the link between both !
Title: Re: Complete list of users with Agent Logon??
Post by: Anth on November 03, 2010, 04:35:24 PM
excellent thanks.

thats what im after
Title: Re: Complete list of users with Agent Logon??
Post by: Adam G. on November 03, 2010, 05:06:59 PM

[URL=http://img24.imageshack.us/i/agentlogin.jpg/][img width=640 height=216]http://img24.imageshack.us/img24/883/agentlogin.jpg[/img][/URL]

Using my beloved Hyperion...

Title: Re: Complete list of users with Agent Logon??
Post by: Anth on November 03, 2010, 10:41:55 PM
Whipped up an app quickly that compares the 3 tables and outputs it to a listview

[img width=523 height=480]http://img2.imageshack.us/img2/5272/genesyssqlapp.jpg[/img]