Export Skill Group Members list for UCCE 8.5

[Seth Tavis]

Hello,

We are working with UCCE 8.5 and will be making some major bulk skill group changes.  We are looking to do the following:

-Export a list of the members of specific skill groups so that we can revert to original skilling if necessary.

-Bulk editing the members of specific skill groups.  The current method of adding/removing skills via Agent Explorer or Skill Group Explorer will not be scalable in the future.

I've tried a variety of SQL queries and manipulation of the Bulk Insert/Edit tools, but have not come up with a solution yet and am hitting my head against the desk at this point.  Any direction or advice is appreciated.  Thanks!

[Gergely Szabo · Accepted solution]

Hi,

exporting is easy with SQL. The simplest query may be:

USE [icmInstance]_awdb

GO

SELECT

ag.*, sg.*

FROM Skill_Group_Member sgm

LEFT OUTER JOIN Agent ag ON sgm.AgentSkillTargetID = ag.SkillTargetID

LEFT OUTER JOIN Skill_Group sg ON sgm.SkillGroupSkillTargetID = sg.SkillTargetID

The Database Schema docs contain all the necessary info:

http://www.cisco.com/en/US/products/sw/custcosw/ps1844/prod_technical_reference_list.html

Bulk editing: this is what the various "Bulk edit" options are within ICM Configuration Manager. Yes, that's it.

Before you start experimenting with writing into the configuration tables: that's an excellent way of losing Cisco's support. And no, there's no public configuration API available.

G.

[Seth Tavis]

Thanks!