Genesys CTI User Forum
Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Gabriel Madoz on January 01, 1970, 12:00:00 AM
-
We have to know exactly on format hh:mm:ss what is the time for login and logout of an agent in our Call center.
Genesys provides only the Total_login_time but we need the exactly values.
Someone told me about two tables: LOGIN and OBJ_TO_OBJ and from there you could do some extra work to resolve..
Does anyone have a suggestion?
Thanks in advance
-
Have you had a look at the Stat Server documentation regarding the LOGIN table that you can activate within Stat Server. This table should store this kind of information.
-
Ok, we have already use LOGIN table and cfg_person and create a new view that looks the following:
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER view Tabla_Login as
select TOP 1000 LOGINID,CASE STATUS WHEN 1 THEN 'Login' ELSE 'Logout' END AS STATUS,dateadd(ss,[TIME]10800, '01/01/1970') as TIME,last_name,first_name
from LOGIN
left outer join cfg_person on LOGIN.AGENTDBID=cfg_person.DBID
ORDER BY last_name,first_name,LOGINID,TIME asc
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
-
Ok, we have already use LOGIN table and cfg_person and create a new view that looks the following:
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER view Tabla_Login as
select TOP 1000 LOGINID,CASE STATUS WHEN 1 THEN 'Login' ELSE 'Logout' END AS STATUS,dateadd(ss,[TIME]10800, '01/01/1970') as TIME,last_name,first_name
from LOGIN
left outer join cfg_person on LOGIN.AGENTDBID=cfg_person.DBID
ORDER BY last_name,first_name,LOGINID,TIME asc
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO