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.
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
aed.DateTime, ag.PeripheralNumber AS LoginID, ag.EnterpriseName AS Agent
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')
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
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.
You have reached the Cisco Logistics Support Center.. To Check Status of
your RMA, visit Product Returns & Replacements (RMA). Need help? Contact
us by Phone or Email. North Americas Phone: 1800 553 2447 Option 4
Email: firstname.lastname@example.org Europe Phone: +3...
The short answer is that you don't.... That isn't entirely true while at
the same time it kind of is, but for the most part you don't configure
the softkeys. You enable or disable them via TCL. Here is the long
answer. Be sure to read the whole thing or e...
Topology: IP Phone > Switches > Microsoft NPS setup to forward 802.1x
proxy to > ISE 2.1 patch 3 Authentication: EAP-TLS using Cisco MIC SANs
Phone Models 802.1X support? 802.1x flavor Addtl Comment EAP-MD5 EAP-TLS
Cisco 3905 Y Y N Cisco 6911 Y Y N Cisco ...