Agent skill levels and reporting

[scoll7567]

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?

[Kevin S]

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.

[fnunezsa]

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.

[tony]

Try Spotlight?

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

TT

[scoll7567]

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

[GenUser]

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

[genesysguru]

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/