Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: rvl102 on October 19, 2017, 06:50:56 PM

Title: DN Registration
Post by: rvl102 on October 19, 2017, 06:50:56 PM

All,

I'm trying to figure out if  there is a historical report that shows the last time a particular DN has been registered. Im trying to do some clean up of DNs that are unused to get a handle on licensing.

thanks,

Title: Re: DN Registration
Post by: hsujdik on October 19, 2017, 07:30:20 PM

Unfortunately, there is no such report. You can use CCPulse or a custom application connecting to Stat Server through PSDK to see for how long a DN is in state "Monitored" or "Logged Out". But this timer is reset every time you restart Stat Server.

If you have Genesys Info Mart, you can query on GIDB_GX_SESSION_ENDPOINT_V table. It will contain one record every time an agent logs in at one DN. But this table will only contain data as old as days-to-keep-gidb-facts option on gim-etl section of your GIM application. So you can see exactly the opposite: which "Extension"/"ACD Position" DNs are being used. Same thing can be obtained on ICON Database on table GX_SESSION_ENDPOINT.

You can also run the following query on GIM database which will give you a clue on Extensions that have had the oldest State changes. It will give you data as old as days-to-keep-gim-facts option in gim-etl section:

select r.resource_name, r.switch_name, max(dt.label_yyyy_mm_dd_hh24_30mi) from sm_res_state_fact srsf
inner join resource_ r on r.resource_key = srsf.primary_media_resource_key
inner join date_time dt on dt.date_time_key = srsf.start_date_time_key
where r.resource_type_code != 'NONE'
and srsf.active_flag = 0
group by r.resource_name, r.switch_name
order by 3 asc