Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: PFCCWA on June 27, 2023, 11:14:30 AM

Title: Last Login report
Post by: PFCCWA on June 27, 2023, 11:14:30 AM

Hello,
i want to use ICON or infomart to produce a report on last login for agents so we know if their genesys account has been in use for a period of time.
is there a way and where is it described or documented?
i am aware we can enable last-login options in confserv and extract this from the relevant table but want to use infomart if possible.

regards

Title: Re: Last Login report
Post by: hsujdik on June 27, 2023, 01:35:06 PM

I dare say that this is not a good idea. The login-session table of InfoMart is not structured or indexed for that kind of query and this might take lots of resources of the DBMS, or the query might timeout, or take a loooot of time to return.

If still you want to try, I believe it would be something similar to this (assuming oracle dbms):


Select r.employee_id as employee_id, to_char(max(to_date('1970-01-01','yyyy-mm-dd') + srsf.start_ts/86400 + dt.label_tz/24),'dd/mm/yyyy hh24:mi:ss') as last_login
from sm_res_session_fact srsf
inner join resource_ r on r.resource_key = srsf.resource_key
inner join date_time dt on dt.date_time_key = srsf.start_date_time_key
group by r.employee_id
order by 1 asc

Title: Re: Last Login report
Post by: cavagnaro on June 27, 2023, 10:48:23 PM

Maybe use statserver tables?

Enviado de meu SM-N9600 usando o Tapatalk