10-27-2008 06:01 AM - edited 03-14-2019 03:06 AM
I want to know if it's possible or if someone has successfully implemented a wallboard of a single queue. My scenario is like this, IPCC Express 4.0 I have multiple queues and want to monitor each one individually.
With the RtICDStatistics table (used by wallboards) I get the full statistics of the system, but I want the data separately, any ideas?
10-27-2008 06:58 AM
There is another table called RtCSQsSummary which gives stats on individual queues. To get info on a specific queue just run a query similar to below:
Select * from RtCSQsSummary where CSQ_Name = %CSQ_Name%
Replace %CSQ_Name% with the CSQ you want to report on.
Jeremy
10-27-2008 07:26 AM
Thanks Jeremy, yes indeed I was just going over the doc for the db schema, thanks!
02-17-2009 08:46 PM
Can somebody elaborate where to put this in the script?
If I have something like this currently, where does that fit in with all this? Be gentle...I'm new to SQL.
strsql = "SELECT resourceName, eventType, eventDateTime FROM Resource, AgentStateDetail WHERE Resource.resourceID = agentStateDetail.agentID AND eventDatetime IN (SELECT MAX(eventDateTime) FROM AgentStateDetail WHERE agentID IN (SELECT resourceID FROM Resource WHERE active = 1) GROUP BY agentID) ORDER BY resourceName"
Set objRS = objCN.Execute(strsql)
While Not objRS.EOF
02-18-2009 03:11 AM
I'm sorry, could you give a little more detail about what you're trying to do. If that query is what you're trying to execute then all you have to do is output the result in your wallboard site.
02-18-2009 07:51 AM
All I'm trying to do is show the agent state for every agent in a CSQ. Right now that above script I posted will show the agent state for every agent in our whole facility, but I want to only show agent state for each CSQ.
So for instance I want it to look like this
CSQ
Agent Name
Agent State (ie talking, not ready, etc..)
State Duration
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