Get a List of NA and ADC calls

All installation and configuration problems and questions

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

Get a List of NA and ADC calls

Postby vkad » Thu Jun 21, 2018 1:33 pm

How can I get a list of phone numbers which have either only NA or only ADC or only NA and ADC in the past 20 call attempts from both the vicidial_log and vicidial_log_archive?
Vicibox 8.0.1 (Asterisk 13.21.0-vici) + Remote WebRTC Agents
Version: 2.14b0.5 | SVN: 2990 | DB Version: 1548
1 x DB + Web + Dialer - E3 1270 v6 + 16gb ddr4 + 256gb SSD
2 x Additional Dialer - E3 1270 v6 + 8gb ddr4 + 256gb SSD
vkad
 
Posts: 208
Joined: Thu Nov 09, 2017 3:46 am

Re: Get a List of NA and ADC calls

Postby thephaseusa » Thu Jun 21, 2018 3:26 pm

Have you tried querying the asterisk database?
thephaseusa
 
Posts: 345
Joined: Tue May 16, 2017 2:23 pm

Re: Get a List of NA and ADC calls

Postby vkad » Fri Jul 13, 2018 10:23 am

What query should I run?
Vicibox 8.0.1 (Asterisk 13.21.0-vici) + Remote WebRTC Agents
Version: 2.14b0.5 | SVN: 2990 | DB Version: 1548
1 x DB + Web + Dialer - E3 1270 v6 + 16gb ddr4 + 256gb SSD
2 x Additional Dialer - E3 1270 v6 + 8gb ddr4 + 256gb SSD
vkad
 
Posts: 208
Joined: Thu Nov 09, 2017 3:46 am


Return to Support

Who is online

Users browsing this forum: Google [Bot], Majestic-12 [Bot] and 102 guests