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

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

Highlighted
New 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
New 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

128
Views
0
Helpful
1
Replies
CreatePlease login to create content