cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1432
Views
0
Helpful
5
Replies

skill report

Roman Rodichev
Level 7
Level 7

Has anyone ever created an SQL report in UCCX to get the skill configuration per agent?

5 Replies 5

Chris Deren
Hall of Fame
Hall of Fame

Not sure about SQL, but if you have recent version of CCX you can use the API and access skill info per agent with the following GET, and then parse the XML with some programming i.e Python, etc. 

http://uccx-server/adminapi/resource/<userid>

Thank you Chris

Deepak Rawat
Cisco Employee
Cisco Employee

http://www.cisco.com/c/en/us/support/docs/customer-collaboration/unified-contact-center-express/118987-check-skill-map-uccx-00.html

Regards

Deepak

Deepak,

when I run this command, I'm getting error "Unable to start ManagerManagerImpl. Command failed". Are you familiar with this?

Here's the simple version of the query:

admin:run uccx sql db_cra select s.skillname from skill s
Unable to start ManagerManagerImpl
Command failed.

Thanks!

You're hitting a bug where a file (MMIStart.txt) on CCX is either missing or has the wrong permissions.  You'll have to open a TAC case to fix that.

Not sure if it's the same bug, but here's the file in question if you wanted to reference a bug ID when contacting TAC: CSCuq99787.

Not sure what version of CCX you're running, but I've seen that same error message on CCX 10.5, 10.6, & 11.0.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: