Agents Creation Date

[Shooter]

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.

[nonny]

Do you have WFM or Info Mart?

Sent from my SM-N9005 using Tapatalk

[Shooter]

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

[Campfire]

Hi,

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

[Tambo]

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

[Dionysis]

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.