Historical reporting problem

[Ezzmiti]

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.

[ecki]

Hi,

What are you using for your historical reporting? CCON, Stat Server tables or ICON/Infomart?

[Ezzmiti]

Hi Ecki,

We are using CCON.

[ecki]

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.

[Ezzmiti]

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.

[borkokrz]

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.