I need help to figure how to collect some data from CUAC. I could not find any documented API that would allow me to query CUAC box. So I decided to query the data directly from CUAC database. Unfortunately, the schema is not that easy to follow and it is not documented. Here is what I need to pull from CUAC:
1. DDI value for the given queue
This data is available in CUAC web admin at User Configuration -> Queue Management:
then click Select:
finally click the link in the Association Information panel:
This examples illustrates that US-TX-HOU2 queue has DDI set to 8476. I browsed the entire database and could not find where this mapping is stored. The closest thing found is Filter_Data column in Queue_Filter_Item table which may be joined with Queue_Filters and Queue_Details tables:
Is that the proper way to query DDI for any given queue in CUAC?
2. Operator to Queue associations
To access this data in CUAC web admin click User Configuration -> Operator Management:
then click select:
The screen-shot above illustrates that OPERATOR3 is associated with US-GA-ATL1, US-IL-LCN3 and US-WI-GRB1 queues. Where is the database this association is stored? The closest thing I found is Agent_Skills table:
which after few joins with Skill_Details and Queue_Skills tables may provide the needed data. But it doesn't look right to me.
That is all I need - just two pieces of data:
- DDI value for any given queue
- operator to queue association.
May be someone knows CUAC data model or the logic behind the database schema, or some API that can be used to query this information? Any help will be greatly appreciated!
SELECT QD.Queue_Name AS QueueName, QFI.Filter_Data AS DDI
FROM dbo.Queue_Details AS QD
INNER JOIN dbo.Queue_Filters AS QF ON QD.Queue_Unique_Ref = QF.Queue_Unique_Ref
INNER JOIN dbo.Queue_Filter_Items AS QFI ON QF.Filter_Unique_Ref = QFI.Filter_Unique_Ref
WHERE QD.Queue_Type = 'CNSLQ'
-- To get Operator Name and Queue Assosiations
SELECT AD.Login_Name AS OperatorName, QD.Queue_Name AS QueueName
FROM dbo.Agent_Details AS AD
INNER JOIN dbo.Agent_Skills AS ASk ON AD.Agent_Unique_Ref = ASk.Agent_Unique_Ref
INNER JOIN dbo.Skill_Details AS SD ON ASk.Skill_Unique_Ref = SD.Skill_Unique_Ref
INNER JOIN dbo.Queue_Skills AS QS ON SD.Skill_Unique_Ref = QS.Skill_Unique_Ref
INNER JOIN dbo.Queue_Filters AS QF ON QS.Queue_Unique_Ref = QF.Queue_Unique_Ref
INNER JOIN dbo.Queue_Details AS QD ON QF.Queue_Unique_Ref = QD.Queue_Unique_Ref
WHERE AD.Login_Type = 'CNSLA' AND QD.Queue_Type = 'CNSLQ' ORDER BY OperatorName, QueueName
to cover all bases - The script that lists operator / queue associations will only show operators that have queues associated with them. (So if they have a operator that is not associated with any queue, this operator will be visible within the data export).
SIP traces provide key information in troubleshooting SIP Trunks, SIP
endpoints and other SIP related issues. Even though these traces are in
clear text, these texts can be gibberish unless you understand fully
what they mean. This document attempts to br...
Please find the attached HTML document, download and open it on your PC.
This provides an easy to use form where you simply answer a few
questions and it will render the proper jabber-config.xml file for you
to copy/paste. There is built in logic to verif...
CUCM Database Replication is an area in which Cisco customers and
partners have asked for more in-depth training in being able to properly
assess a replication problem and potentially resolve an issue without
involving TAC. This document discusses the bas...