01-27-2014 08:51 PM - edited 03-14-2019 01:00 PM
Hi All,
I am trying to calculate how many agents are logged on at particular time say 9:00 am, 9:15 am etc.
Could anyone please let us know if there is any way from HDS database or any other source we can find this information.
At the moment, I am calculating manually by taking the screenshots of CUIC which we customised to display real time information . If we dont take screenshots , we are going to loose the real time information . Hence is there any way so that we can get this from any other source.
Your comments are highly appreciated.
Thanks.
Regards
Deepak
01-27-2014 11:25 PM
You simply could query the Agent_Real_Time table and determine what's going on with your agents based on the value of their agent state. The ucce database schema doc details what the agent state values are.
This might not really help you... but maybe you can take this query and run with it
SELECT
aed.DateTime, ag.PeripheralNumber AS LoginID, ag.EnterpriseName AS Agent
FROM
Agent ag
join Agent_Event_Detail aed on aed.SkillTargetID = ag.SkillTargetID
join Skill_Target st on ag.SkillTargetID = st.SkillTargetID
where aed.Event = '1'
and (aed.LoginDateTime between '2014-01-27 07:00:00.000' and '2014-01-27 09:14:59.999')
Order By aed.DateTime
01-28-2014 01:49 PM
Assuming you're running UCCE on 2008 R2, the other option you have is to log onto your CUCM PG, launch Performance Monitor, expand Performance (Local) > Monitoring Tools > Performance Monitor, right click Performance Monitor and go to properties. You should see the Performance Monitor Properties window appear - click on the Data tab and remove any counters that's in there. Once the counters are clear, click Add, look for Cisco ICM OPC and expand it; you'll see a lot of counters that you can add, but in this case you'll want to add Logged-In Agent Count and click Add >>
You'll probably see this displayed as a line graph, however, you can change this to a real-time report by clicking CTRL+G a couple times - this will change from line graph to histogram bar to a readable report.
This is equivalent to running this query against the awdb
SELECT COUNT(*)
FROM Agent_Real_Time
WHERE AgentState <> 0
01-28-2014 07:53 PM
I've used a similar process with CTIOS, this obviously assumes you're using CTIOS, but similar metrics can be observed from varous components:
http://dmacias.org/2012/02/01/how-many-cisco-cti-os-agents-are-current-logged-in/
david
01-28-2014 01:58 PM
I just checked in CUIC on UCCX. Running the agent summary report for a period, even down to a single second, appears to create a record for every logged in agent. You could use the row count to get the number of logged on agents at that time.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide