Looking for all resources and their competency levels within specific csq UCCX 10.5

[jbaker2bvn]

UCCX System version: 10.5.1.10000-24

Does anyone know how to pull a list of all resources and their competency levels within a specific csq?

Looking for the similar info that you get from the "Open printable report of this csq configuration"

but also need to know what each of the resource competency levels are without looking up each resource individually.

Thanks all

[Chakshu Piplani · Accepted solution]

Hi,

You can run the following query on CLI/SSH session of CCX.

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

Make sure spacing is correct else the query might return an error, also turn on logging on your SSH client as this query will return a a huge output.

Source:

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

HTH

Regards,

Chakshu

Please rate helpful posts.

[jbaker2bvn]

Just came back around to this post. This worked, Thank you Chakshu

[KEITH HATHCOCK]

Very helpful!!!!!

Thanks!