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. If you'd prefer to explore, try our test area to get started.

New Member

In need of a UCCE 7.5 SQL Query

Would anyone happen to know of a SQL query that that can be run on the HDS what would give the avarage skillgroups assigned to an agent.  Also, another one that would give average number of agents to a supervisor? 

  • Contact Center
1 ACCEPTED SOLUTION

Accepted Solutions

Re: In need of a UCCE 7.5 SQL Query

Hi,

try

SELECT COUNT(*)/CAST(COUNT(DISTINCT sgm.AgentSkillTargetID) AS FLOAT) FROM Skill_Group_Member sgm

and

SELECT COUNT(*)/CAST((SELECT COUNT(DISTINCT SupervisorSkillTargetID) FROM Agent_Team_Supervisor) AS FLOAT) FROM Agent_Team_Member

But please remember agents don't have to be in teams, so the above query does not count with agents who aren't assigned to a team.

G.

2 REPLIES

Re: In need of a UCCE 7.5 SQL Query

Hi,

try

SELECT COUNT(*)/CAST(COUNT(DISTINCT sgm.AgentSkillTargetID) AS FLOAT) FROM Skill_Group_Member sgm

and

SELECT COUNT(*)/CAST((SELECT COUNT(DISTINCT SupervisorSkillTargetID) FROM Agent_Team_Supervisor) AS FLOAT) FROM Agent_Team_Member

But please remember agents don't have to be in teams, so the above query does not count with agents who aren't assigned to a team.

G.

New Member

Re: In need of a UCCE 7.5 SQL Query

Thanks Gergely!

624
Views
0
Helpful
2
Replies