Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: scoll7567 on March 31, 2011, 09:39:37 PM

Title: Agent skill levels and reporting
Post by: scoll7567 on March 31, 2011, 09:39:37 PM

We use skill based routing to route calls to our agents.  Each agent has roughly 12 skills and the levels of each skill changes based on the team to which the agent belongs.  Two quick question:

1. Is there a report or a way to export the agent skill information?  a report that shows skills assigned to each agent and at what level.

2. Is an historical table/data that shows me when an agent skill or skill level was changed?

Title: Re: Agent skill levels and reporting
Post by: Kevin S on April 01, 2011, 03:23:30 AM

scoll -
Re: 1, there is not a predefined report, though you should be able to create one on your own via SQL and a little bit of research.
Two of the tables you would need to query from your Config Database are cfg_person and cfg_skill, which will give you your agents and your skills. I'm pretty sure that there is another table that contains the joining of the two, but off the top of my head, I could not tell you which one.
HOWEVER -
If you turn on full logging to your config server and cfg_dbserver logs (recommend doing in lab environment) and change a skill, you should be able to see what tables you need to touch in the middle.

Re: 2, the only way I could think of would be within the database using insert/update triggers, HOWEVER
****** WARNING  *******
I would do research on this because it could adversely impact not only the integrity of the data but also the performance of the Config Server during updates. Genesys Support may also not provide support on issues that possibly were caused by such modifications to the config DB.

Determine how necessary item 2 is, then proceed with caution.

Title: Re: Agent skill levels and reporting
Post by: fnunezsa on April 01, 2011, 11:53:39 PM

If you need to track down any configuration change, then you should enable Management layer audit feature.

Do you happen to have ICON/GIM? If you do, then you can get all that data (skill assigment and modification) from ICON DB or GIM DB.

Title: Re: Agent skill levels and reporting
Post by: tony on April 02, 2011, 08:52:40 AM

Try Spotlight?

http://www.theblackchair.com/Spotlight_Presentation/player.html

TT

Title: Re: Agent skill levels and reporting
Post by: scoll7567 on April 03, 2011, 06:35:24 PM

Spotlight seems to be exactly what we need.  Any idea on the approx cost?

Title: Re: Agent skill levels and reporting
Post by: GenUser on May 24, 2013, 11:35:27 AM

If you want an audit solution that excels in feature, design and integration with Genesys, check out the functional overview and architecture slides under : http://auditgen.com/en/auditgen-overview
And all that won't cost you an arm and a leg :)

Title: Re: Agent skill levels and reporting
Post by: genesysguru on May 24, 2013, 02:50:26 PM

Spotlight - http://www.theblackchair.com/ (Expensive)
Eemaan - http://www.eemaan.com/audit-trail-for-genesys.html
AuditGen - http://auditgen.com/en/auditgen-overview

Homebrew -
http://genesysguru.com/blog/blog/2010/02/19/who-changed-that-cme-object/
http://genesysguru.com/blog/blog/2009/10/03/configuration-snapshots/