Page 1 of 1

SQL or API to determine number of calls ringing?

PostPosted: Mon Sep 10, 2018 12:43 am
by mrgunston
Is it possible to determine how many numbers are being dialed as well as whether there are calls waiting for agents by using MySQL OR API?

For example: Exactly the same feature as found in the Real-Time Main Report which looks like this:
1 calls ringing 1 calls waiting for agents

Cheers,
Paul


Vicibox 2.12-565a from vicibox_v7x68_65.iso | Vicidial 2.12-565a Build 160827-0917 | Asterisk 11.23.1-vici | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | DELL R710 | Intel Xeon CPU X5690 @ 3.47Ghz 6 Cores

Re: SQL or API to determine number of calls ringing?

PostPosted: Mon Sep 10, 2018 5:06 am
by mflorell
Yes, the vicidial_auto_calls table can tell you this information.

Re: SQL or API to determine number of calls ringing?

PostPosted: Mon Sep 10, 2018 5:43 pm
by mrgunston
mflorell wrote:Yes, the vicidial_auto_calls table can tell you this information.


Perfect! This is exactly what I was looking for. Thanks for your help :)