01-04-2011 11:21 AM - edited 03-14-2019 07:08 AM
I am using
gila-wallboard. I wondering if anyone has an example of a script that displays one queue stats instead of all the queues stats. Thanks.
01-04-2011 11:36 AM
You jsut need to modify the wallboard.asp file, and adjust the database SELECT statements.
Your exact version may vary, but here's what I did (red bold text was added to the original source)...
strsql = "SELECT CSQName, loggedInAgents, availableAgents, callsWaiting, callsHandled, totalCalls, callsAbandoned, convoldestContact, convLongestWaitDuration, endDateTime FROM RtCSQsSummary where (CSQName = 'MyCSQname') ORDER BY CSQName"
Note that there's multiple SELECT statements, one for each wallboard page.
05-13-2011 11:46 AM
Hi Thomas,
I can use that code for a single CSQ. However I cannot seem to modify the syntax for multiple queues. I just want to have the wallboard display 3 out of the 10 queues. I want to filter based on department.
Do you have the syntax to filter on two or more queues?
05-18-2011 07:43 AM
You can just use OR statements.
strsql = "SELECT CSQName, loggedInAgents, availableAgents, callsWaiting, callsHandled, totalCalls, callsAbandoned, convoldestContact, convLongestWaitDuration, endDateTime FROM RtCSQsSummary where (CSQName = 'MyCSQ1') or (CSQName = 'MyCSQ2') or (CSQName = 'MyCSQ3') ORDER BY CSQName"
05-24-2011 09:14 AM
Thanks Thomas.
That worked great. However I changed my version of Wallboard to 2.5. I was getting prompted to login to the web page everytime I launched it via the browser for the GilaWallboard version. When I switched to V2.5, I never got prompted for login credentials.
I just have another question.
I have numerous queues. The "Agent Status" will show the same agent multiple times because of being a resource in the various queues.
Is there a way to only show the agent once in wallboard? Also, is there a way to filter the agent instead of listing all agents in UCCX?
Thanks,
Bryant
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