I have web application and connect to Cisco UCCX (db_cra) database with uccxhruser username and ODBC driver.
If I query on Database manager program, it's response fast (less than 1 second) but
If I query in my web application, it's response very slow (wait more than 10 minutes).
Example query script
It's count number of total call in 6 months
from contactcalldetail t1 inner join
(select t2.sessionid, t2.sessionseqnum, t2.nodeid, t2.profileid, t2.targetid, t2.disposition, t1.csqname
from contactservicequeue t1 inner join contactqueuedetail t2
on t1.recordid = t2.targetid and t1.profileid = t2.profileid
where t1.csqname = 'XXXX' and t2.disposition in (2,4)
on t1.sessionid = t2.sessionid and t1.sessionseqnum = t2.sessionseqnum and t1.nodeid = t2.nodeid and t1.profileid = t2.profileid
where t1.contactdisposition <> 1 and t2.disposition in (2,4) and t2.csqname = 'XXXX' and t1.startdatetime between '2020-06-30 17:00:00' and '2020-12-31 16:59:59'
My web application developed with PHP and Laravel framework.
Please advise whether I should change my query script or make a configuration change at UCCX.
MARS Emergency Alerts helps an organization to create, distribute and manage enterprise wide notification to all employees in the enterprise in a systematic and efficient manner.The application allows alerts to be broadcasted to Cisco IP phones by the app...
The acronym "STUN" stands for two definitions with two different meanings as follows:
STUN - Simple Traversal of User Datagram Protocol (UDP) ---> RFC 3489 published in 2003 - works only with static NAT to establish a direct connectivity between...
Inbound CSS and Rerouting CSS with Cisco Unity Connection Transfer rules:Release to Switch: this type of transfer uses the SIP Refer method to reroute the call to the specified extension, it is sent in dialog in other words in the existing SIP conversatio...
As mentioned previously in my previous article and following the same idea of certificate pinning in Cisco Meeting Server, to demonstrate this concept added since version 3.0. I used two different CA to sign :1-The WebBridge certificate with CA's certific...