Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Shooter on August 16, 2016, 04:21:26 AM

Title: Agents Creation Date
Post by: Shooter on August 16, 2016, 04:21:26 AM

Where I can find the date on which a particular agent gets configured in CME/GA?
I am assuming that it should be there in config DB (apart from logs), but which table not sure. Please help me out.

Title: Re: Agents Creation Date
Post by: nonny on August 16, 2016, 06:09:25 AM

Do you have WFM or Info Mart?

Sent from my SM-N9005 using Tapatalk

Title: Re: Agents Creation Date
Post by: Shooter on August 16, 2016, 06:18:40 AM

Yes WFM is here.
Where I can check in WFM when the agent is configured first time in CME/GA?

Title: Re: Agents Creation Date
Post by: Campfire on August 16, 2016, 07:55:34 AM

Hi,

Not sure if you have DataMart DB, table 'OBJECT' will have the Agent profile creation time.

Title: Re: Agents Creation Date
Post by: Tambo on August 16, 2016, 11:45:07 AM

select A.USERNAME, P.NAME, L.LOGINSESSIONID, L.AGENTID, L.LOGINID, L.STATE, L.CREATED, L.TERMINATED, (L.TERMINATED_TS - L.CREATED_TS) AS Duaration
from GIM.GIDB_G_LOGIN_SESSION_V L, GIM.GIDB_GC_AGENT A, GIM.GIDB_GC_PLACE P
WHERE (L.CREATED >= to_date ('07/06/2013' , 'DD/MM/YYYY')) and (L.CREATED < to_date ('11/06/2013' , 'DD/MM/YYYY'))
AND (L.AGENTID = A.ID)
AND (L.PLACEID = P.ID)
AND A.USERNAME IN ('agents username')


this might help

Title: Re: Agents Creation Date
Post by: Dionysis on August 16, 2016, 07:33:59 PM

There's also a "start date" in the WFM database, I don't remember the exact table details but it shouldn't be hard to find, from memory it's in a logical place.