Hi,
I am new to reporting for Genesys and need to store agent name/ PlaceID, so that I get generate a report that will show who was logged into which place and when. Is this information already stored somewhere or will this require customer stats/layout.
any help much appreciated.
Hi,
What are you using for your historical reporting? CCON, Stat Server tables or ICON/Infomart?
Hi Ecki,
We are using CCON.
Well, then in this case the only way is to merry Genesys config database with your CCON tables. You would have to access the cfg_person table to get agent names and cfg_place or dn to get place names/numbers etc.
Thanks for the update Ecki,
I understand what you say in query the Genesys config tables to get the name/place/number but would I still collect the login/out event for the agent name via a DMA layout, or some other means?, as I’m thinking maybe I would need a trigger on the table once the agent username was passed in.
CCON Stores information about agent login when agent logs out. One record is stored in AREC table with STATUS=1, STTIME = time when agent logged in, DURATION = duration of login, AGENT = DBID of agent, DN - DBID of place on which agent was logged. You have to query CCON database itself, you can’t use DMA for that.