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