All installation and configuration problems and questions
Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
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
-
vkad
-
- Posts: 208
- Joined: Thu Nov 09, 2017 3:46 am
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
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
-
vkad
-
- Posts: 208
- Joined: Thu Nov 09, 2017 3:46 am
Return to Support
Who is online
Users browsing this forum: Majestic-12 [Bot] and 74 guests