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.

New Member

Active agents

What is the best way to find out the active agents in the system at any given time. Say for example a call center started with 500 agents and over a period of time some agents left etc.  They were not removed from the system. Now if I need to find out a approx list of agents who log in (not necessarily onlt taking calls).  What is the best way to query this ?

1 ACCEPTED SOLUTION

Accepted Solutions
Silver

If I understand your question

If I understand your question correctly, you're looking for stale agents, right? Another words, agents that have worked for your employer and have left the company, however, their agent/person ID are still in ICM? If that's the case, the best way to do it is to use the Agent_Event_Detail table to see how long ago an agent actually logged into the system. 

If you run the query below, you should be able to make good judgement on who you would consider a stale agent and who would not be. I ran this and found several agents last log in was in January. It would probably be a good idea to write those names down and verify that they are no longer employed here because if that's the case, I can remove them from ICM. 

SELECT DISTINCT P.FirstName, P.LastName, P.LoginName, MAX(AED.LoginDateTime) AS LastLoginTime
FROM Agent A, Agent_Event_Detail AED, Person P
WHERE A.SkillTargetID = AED.SkillTargetID
AND A.PersonID = P.PersonID
GROUP BY P.FirstName, P.LastName, P.LoginName
ORDER BY LastLoginTime ASC

6 REPLIES

You can check the logged

You can check the logged agents from the Cisco Supervisor Desktop. But if you don't want to waste a UCCX seat by doing that,  then you can log into the UCCX web admin page, go to Tools>Real Time Reporting. In the first tab you can see many statistics, including the logged-in resources in that moment.

Please rate helpful posts.

 

Gabriel.

New Member

You can go to Subsystems -->

You can go to Subsystems --> RmCM --> Resources. I believe this will show ALL users with a configured IPCC extension in your system.

 

I hope this helps!

Hall of Fame Super Silver

Is this CCX or UCCE? Since

Is this CCX or UCCE? Since you say 500 agents and UCCX scales up to 400 I assume UCCE. What version?

Chris

New Member

This is UCCE.(8.0.3)  Some

This is UCCE.(8.0.3)  Some agents are first shift, some 2nd etc.  So I ran a query on TCD for all the agents who showed up in TCD for say yesterday. I got all the uninue agents. Will that be an accurate count or is there a better way ?

Silver

If I understand your question

If I understand your question correctly, you're looking for stale agents, right? Another words, agents that have worked for your employer and have left the company, however, their agent/person ID are still in ICM? If that's the case, the best way to do it is to use the Agent_Event_Detail table to see how long ago an agent actually logged into the system. 

If you run the query below, you should be able to make good judgement on who you would consider a stale agent and who would not be. I ran this and found several agents last log in was in January. It would probably be a good idea to write those names down and verify that they are no longer employed here because if that's the case, I can remove them from ICM. 

SELECT DISTINCT P.FirstName, P.LastName, P.LoginName, MAX(AED.LoginDateTime) AS LastLoginTime
FROM Agent A, Agent_Event_Detail AED, Person P
WHERE A.SkillTargetID = AED.SkillTargetID
AND A.PersonID = P.PersonID
GROUP BY P.FirstName, P.LastName, P.LoginName
ORDER BY LastLoginTime ASC

New Member

Thanks Omar. Good suggestion.

Thanks Omar. Good suggestion. This looks like one of the best ways I can figure this out.

Hemal

166
Views
10
Helpful
6
Replies
CreatePlease login to create content