SQL or API to determine number of calls ringing?

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

SQL or API to determine number of calls ringing?

Postby mrgunston » Mon Sep 10, 2018 12:43 am

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
mrgunston
 
Posts: 33
Joined: Tue Oct 11, 2016 9:51 pm

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

Postby mflorell » Mon Sep 10, 2018 5:06 am

Yes, the vicidial_auto_calls table can tell you this information.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

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

Postby mrgunston » Mon Sep 10, 2018 5:43 pm

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 :)
mrgunston
 
Posts: 33
Joined: Tue Oct 11, 2016 9:51 pm


Return to Support

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 93 guests