Get a List of NA and ADC calls
Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
3 posts
• Page 1 of 1
Get a List of NA and ADC calls
by 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
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
by 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
by 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
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
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: Bing [Bot] and 90 guests