06-25-2015 09:29 AM - edited 03-14-2019 02:56 PM
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
Solved! Go to Solution.
06-25-2015 11:17 AM
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.
06-25-2015 11:17 AM
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.
10-31-2015 07:56 AM
Just came back around to this post. This worked, Thank you Chakshu
02-15-2019 06:38 AM
Very helpful!!!!!
Thanks!
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide