cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
2337
Views
0
Helpful
2
Replies
Beginner

Export Skill Group Members list for UCCE 8.5

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!

Everyone's tags (6)
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Advocate

Re: Export Skill Group Members list for UCCE 8.5

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.

View solution in original post

2 REPLIES 2
Highlighted
Advocate

Re: Export Skill Group Members list for UCCE 8.5

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.

View solution in original post

Highlighted
Beginner

Export Skill Group Members list for UCCE 8.5

Thanks!

CreatePlease to create content