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.
Do you have WFM or Info Mart?
Sent from my SM-N9005 using Tapatalk
Yes WFM is here.
Where I can check in WFM when the agent is configured first time in CME/GA?
Hi,
Not sure if you have DataMart DB, table ‘OBJECT’ will have the Agent profile creation time.
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
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.