Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Highlighted
Community Member

Agent skill report

Does anyone know of a report which shows each agent and what skills and levels within those skills each agent are set to?

CRS 4.0.5sr1build40

1 REPLY
Community Member

Re: Agent skill report

Typing this from memory, so please forgive typos:

SELECT p.FirstName, p.LastName, p.LoginName, a.EnterpriseName, a.PeripheralNumber, sg.SkillTargetID, sg.EnterpriseName

FROM Agent a

INNER JOIN Person p ON a.PersonID = p.PersonID

INNER JOIN Skill_Group_Member sgm ON a.SkillTargetID = sgm.AgentSkillTargetID

INNER JOIN Skill_Group sg ON sgm.SkillGroupSkillTargetID = sg.SkillTargetID

Let me know if this does not work for you

Sam

166
Views
0
Helpful
1
Replies