Genesys CTI User Forum
Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Dave on January 01, 1970, 12:00:00 AM
-
Is there a way to record the time of day an agent logs in and out? Our call centre supervisors are very keen to have this as evidence against naughty agents.
-
3 words that are often needed.... "Stat Server tables"
-
And 3 very fine words they are. How does that help a rather dense Genesys person? If you could be more explicit I would be grateful.
-
Dave,
StatServer has several tables to help you track what happens in your call center. One of this tables is LoginTable.
LoginTable records times when agents login and logout.
To enable this table you will need to set LoginTable=true in your StatServer options. You will also need to run a script to make that table in your db. This script comes with your StatServer just look under scripts directory.
And, yes, you will need to define a DAP pointing to that database and add it to StatServer connections.
Table itself is very straightforward (but you will need to take a deep breath before doing it)
AGENTDBID corresponds to DBID of the agent that logged in or logged out. You will need to link this DBID with agent dbid in CME.
But, don't despair since there is also a LOGINID field, which will record your agent ID as it is, so you do not have to do a lot of DB work.
Status: 0 for logout. 1 for login.
Time: time when this happened. But since this is Genesys, time is not something you can use right away. Instead it is expressed as number of seconds since 1/1/1970. So, you will need to do some math there.
Just drop me a line if you need more help.
-
Thanks for the help, everyone. Object almost achieved. The customer now wants his customised not
eady code times reported too. Any ideas?
-
I could write a custom app for you..........
B