Exact time of an agent Login and Logout

[Gabriel Madoz]

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

[Gauthier]

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.

[Gabriel Madoz]

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

[Gabriel Madoz]

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