Report info from tables

All installation and configuration problems and questions

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

Report info from tables

Postby Vince-0 » Mon Aug 11, 2014 9:35 am

Hi Vici forum!

Please can someone point to the tables that may hold the following info:

Minimum ring time before being dropped as No Answer (is it vicidial_dial_log on "timeout" field? which holds the "Dial Timeout" campaign setting )
Maximum time to pass a call to an agent from call pick up (Drop seconds?)
Maximum time to pass a call to the abandonment message (Drop seconds?)

--
Version: 2.8-418a BUILD: 131029-2008 from Vicibox 5.0.3 ISO
Vince-0
 
Posts: 272
Joined: Fri Mar 02, 2012 4:27 pm
Location: South Africa

Re: Report info from tables

Postby geoff3dmg » Mon Aug 11, 2014 10:40 am

These are campaign settings so live in asterisk.vicidial_campaigns. The columns you want are 'drop_call_seconds' and 'dial_timeout'.
Vicibox 5.03 from .iso | VERSION: 2.10-451a BUILD: 140902-0816 | Asterisk 1.8.28.2-vici | Multi-Server | Amfeltec H/W Timing Cards | No Extra Software After Installation | Dell PowerEdge 1850 | Pentium 4 'Prescott' Xenon Quad @ 3.40GHz
geoff3dmg
 
Posts: 403
Joined: Tue Jan 29, 2013 4:35 am
Location: Lancashire, UK

Re: Report info from tables

Postby Vince-0 » Mon Aug 11, 2014 10:45 am

Thanks for the quick reply.
I'm more interested in call log type data for every call but I will investigate.
Vin
Vince-0
 
Posts: 272
Joined: Fri Mar 02, 2012 4:27 pm
Location: South Africa


Return to Support

Who is online

Users browsing this forum: Bing [Bot] and 97 guests