简介
本文档介绍如何通过GUI通过Appadmin网页在Cisco Unified Contact Center Express(UCCX)中一次检查多个座席的技能映射。
背景信息
没有特定报告可在单个页面上生成到所有座席的技能映射。逐个代理检查此配置非常耗时。


检查UCCX上所有座席的技能表
要检查所有座席的技能映射,请输入以下查询:
运行uccx sql db_cra select s.skillname、rsm.competentencelevel、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,其中s.active = 't't ID
此查询使用技能表、资源表、团队名称和资源映射中的SQL JOINS来生成报告。使用SSH通过CLI运行此查询,如以下示例输出所示:
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
SKILLNAME COMPETENCELEVEL RESOURCELOGINID EXTENSION RESOURCEFIRSTNAME RESOURCELASTNAME
TEAMNAME
--------------------------------------------------------------------------------------------
Skill1 5 agent1 62121 Agent1 Default
Skill1 5 agent2 62131 Agent2 Default
Skill1 5 arunabh 62000 CIPC Default
注意:这有助于验证座席到技能的映射。当基于技能的路由出现问题时,可以使用它来删除到座席的错误技能映射。