UCCX 10.6 - How can I get a list of all agents , their skills and skill level

[lleweyiss]

In UCCX 10.6 I can't find a way to get list of all the agents and the skills assigned along with the skill level.

I have over 300 agents that can have anywhere from 3 to 15 skills and within those skills the levels can be different depending on the expertise.

I have looked in UCCX and CUIC  to try and find a way to get this information. 

The  only way I know is in UCCX,  open up the configuration for each agent and then manually fill in a spreadsheet. Even the little box window in the config page wont let you highlight and copy all the skills.

Yes I know I can click on the link to  "open  a printable report of this resource configuration" ,  but still have to copy section at a time into a spreadsheet to get the column effect.  Again , still have to do this  for each one individually .   300 + agents , this takes way too long.

[Chris Deren]

One suggestion I can propose is to write a tool against CCX API as with the API you can pull the configuration. If you are not comfortable with programming, you can use tools such as Postman to send API calls to CCX. Here is CCX API documentation:

https://developer.cisco.com/site/uccxapi/overview/

[lleweyiss]

Chris, thanks for the information, I will check it out . and I am not comfortable with programming at all :-)

[Deepak Rawat · Accepted solution]

There you go:

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

Regards

Deepak

[Chris Deren]

+5 to Deepak, I completely forgot about this page as I recall seeing it when pointed out via another thread a while ago, probably by Deepak as well.

[lleweyiss]

Chris,  shout out from Deepak, and he is correct you have helped me previously.

And I really appreciate the developer link and the info for Postman tool ...  I will jump into the deep end of the pool once I get a few minutes to focus on the information.

[tlyons]

I know that this thread is a bit older, but I was able to find this, and tried executing the command that Deepak shared (This would be a HUGE help to us as well, as we have dozens of Skill Groups, with around 40 CSR's spread out within them.  However, when I execute it, via SSH session of our UCCX Publisher, I get the following output:

admin:run uccx sql db_cra select s.skillname, rsm.competencelevel, r.resourceLoginID, r.extension, r.resourceFirstName, r.ResourceLastName,t.teamname from skill s inner join resourceskillmapping rsm on s.skillid = rsm.skillid inner join resource r on rsm.resourceskillmapid = r.resourceskillmapid join team t on r.assignedteamid = t.teamid where s.active = 't' and r.active = 't' order by s.skillname, competencelevel, resourceloginid
Unable to start ManagerManagerImpl

Command failed.

Thoughts on what is missing or incorrect?

[Thomas G. Johannesen]

Hey tlyons

Try running this URL in your browser

https://<UCCX-address>/adminapi/resource

Login with your application username/password

This will give you a list in JSON format from the APi

[MSAGSupport]

How this will help in getting the list of agents with the skills and competency report. 

[Thomas G. Johannesen]

Because you will get a list of agents, and for each agent you will see the skillmap with comp level.

This will return data in xml or json, and with that you can import the data in excell and make a report

[MSAGSupport]

Thank you  

[MSAGSupport]

Thanks a lot for suggesting to use the adminapi to get the required data. I was able to successfully import the xml file to excel and get the required report.

Now I am going through the Cisco Unified Contact Center Express Developer Guide, Release 10.5 to understand more about this.

https://community.cisco.com/kxiwq67737/attachments/kxiwq67737/5926-discussions-contact-center/90328/1/uccx_api_developer_guide_0.pdf

- Shiv Raman

[lleweyiss]

Deepak,

This has been the single BIGGEST complaint I have had with UCCX .... and you just became my hero !!  this worked and I can easily get the txt file into a spreadsheet .....   doing my happy dance !

[Deepak Rawat]

It had been a while that I came on the Support Community as had been busy with some other stuff. Glad that I was able to help when you needed it the most. Thanks for your kind words and a big shout out to Chris as well who is always there helping customers on the Community, thanks Chris :)

Regards

Deepak

[derek.fraser]

Awesome info Deepak! +5 sir, very much appreciated.  I've done this with the API but a direct SQL query is really helpful.  I can verify it's working with 11.6.1.10000-51