05-27-2016 08:44 AM - edited 03-14-2019 04:10 PM
I have a need to try and figure out resource skilling. I need to know what skill a user had at a particular time. We relinquished agent skilling to the Call Center and the queues are behaving strangely. We believe this is because the agents are getting dynamically skilled but we have no way to really see if UserX held SkillY at time Z.
Can anyone think of a way to do this?
Solved! Go to Solution.
05-28-2016 09:47 AM
This is something not very straightforward and you will need to join information from one table and then use it with other. Refer below:
Run below query from UCCX CLI first to get the skillname and skillid
run uccx sql db_cra select * from skill
After running above query, run below:
run uccx sql db_cra select (resourceSkillMapID) from resource where resourceloginid='derawat' and dateinactive > '2015-09-28 00:00:00'
resourceSkillMapID is nothing but the skillid only that you got from the skill table and derawat is the userid. You will ofcourse need to change the userid and dateinactive as per your requirements
You can refer to below DBSchema guide to know more about the tables and available fields within UCCX database:
http://www.cisco.com/c/dam/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/crs/express_10_6/reference/guide/dbschema.pdf
Note: You might see some records associated with the resource that may not be available in skill table anymore so nothing can be done about that. Even though it is not full proof but this is the maximum you can get in regards to what you are looking for.
Regards
Deepak
05-27-2016 05:14 PM
You'll have to write something which queries the API to have this kind of information. And even then you would not know who make the change.
david
05-28-2016 09:47 AM
This is something not very straightforward and you will need to join information from one table and then use it with other. Refer below:
Run below query from UCCX CLI first to get the skillname and skillid
run uccx sql db_cra select * from skill
After running above query, run below:
run uccx sql db_cra select (resourceSkillMapID) from resource where resourceloginid='derawat' and dateinactive > '2015-09-28 00:00:00'
resourceSkillMapID is nothing but the skillid only that you got from the skill table and derawat is the userid. You will ofcourse need to change the userid and dateinactive as per your requirements
You can refer to below DBSchema guide to know more about the tables and available fields within UCCX database:
http://www.cisco.com/c/dam/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/crs/express_10_6/reference/guide/dbschema.pdf
Note: You might see some records associated with the resource that may not be available in skill table anymore so nothing can be done about that. Even though it is not full proof but this is the maximum you can get in regards to what you are looking for.
Regards
Deepak
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