Complete list of users with Agent Logon??

General Discussion
1

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

2

Look at cfg_login_info, you will find the link between both !

3

excellent thanks.

thats what im after

2 Likes
4


http://img24.imageshack.us/img24/883/agentlogin.jpg

Using my beloved Hyperion…

5

Whipped up an app quickly that compares the 3 tables and outputs it to a listview

http://img2.imageshack.us/img2/5272/genesyssqlapp.jpg

1 Like