Dial attempt frequency

[jessiekidfernando]

Hello Everyone,

I am using this lead filter to have 2 hours in between dial attempts to specific numbers. However we can still seeing dial attempts every 45 minutes or less. Anyone knows what are the things that might causing this to happen?

1=1
AND
STR_TO_DATE(address3,'%m/%d/%Y')>=date_add(curdate(), interval -9 MONTH)
AND
(called_count=0 OR
date_add(last_local_call_time, INTERVAL -(if(gmt_offset_now=0,-5,gmt_offset_now) + 6) HOUR)<date_add(now(), INTERVAL -120 MINUTE))



--

Here's my vici version and settings.

PBX Core settings
-----------------
Version: 13.17.2-vici
Build Options: BUILD_NATIVE, OPTIONAL_API
Maximum calls: Not set
Maximum open file handles: 65536
Root console verbosity: 21
Current console verbosity: 20
Debug level: 0
Maximum load average: 0.000000
Minimum free memory: 0 MB
Startup time: 05:45:42
Last reload time: 05:45:42
System: Linux/3.10.0-862.3.2.el7.x86_64 built by root on x86_64 2018-06-07 18:13:29 UTC
System name:
Entity ID: 06:ac:d5:13:3d:44
PBX UUID: 59e4859c-802e-45b7-9365-221b59bce057
Default language: en
Language prefix: Enabled
User name and group: /
Executable includes: Disabled
Transcode via SLIN: Enabled
Transmit silence during rec: Disabled
Generic PLC: Enabled
Min DTMF duration:: 80
RTP dynamic payload types: 96-127

* Subsystems
-------------
Manager (AMI): Enabled
Web Manager (AMI/HTTP): Disabled
Call data records: Enabled
Realtime Architecture (ARA): Disabled

* Directories
-------------
Configuration file:
Configuration directory: /etc/asterisk
Module directory: /usr/lib64/asterisk/modules
Spool directory: /var/spool/asterisk
Log directory: /var/log/asterisk
Run/Sockets directory: /var/run/asterisk
PID file: /var/run/asterisk/asterisk.pid
VarLib directory: /var/lib/asterisk
Data directory: /var/lib/asterisk
ASTDB: /var/lib/asterisk/astdb
IAX2 Keys directory: /var/lib/asterisk/keys
AGI Scripts directory: /var/lib/asterisk/agi-bin

--

Detailed Campaign Settings:

Campaign ID: INTAKE
Campaign Name: Intake Outbound
Campaign Description: Intake Outbound
Campaign Change Date: 2019-01-31 17:32:47
Campaign Login Date: 2019-02-08 19:21:14
Campaign Call Date: 2019-02-08 19:22:33
8 Day outbound call count for this campaign more summary stats...
2019-02-10 -none-
2019-02-09 -none-
2019-02-08 5828
2019-02-07 5529
2019-02-06 5085
2019-02-05 4587
2019-02-04 6160
2019-02-03 -none-
Active: Y
Admin User Group: ---ALL---
Park Music-on-Hold: default moh chooser
Web Form: VARhttps://citizens.my.salesforce.com/_ ... =--A--phon
Web Form Target: CRMwin
Allow Closers: Y
Allow Inbound and Blended: Y
Dial Status 1: SC - Spoke To Client REMOVE
Dial Status 2: PU - Call Picked Up REMOVE
Dial Status 3: FAILED - Failed Transfer REMOVE
Dial Status 4: DISMX - Disconnected Max Seconds REMOVE
Dial Status 5: DROP - Agent Not Available REMOVE
Dial Status 6: INC - Incomplete REMOVE
Dial Status 7: ACWT - ACW Timeout REMOVE
Dial Status 8: SETCB - Set Callback REMOVE
Dial Status 9: LM - Left Message REMOVE
Dial Status 10: VMFULL - Mailbox Full REMOVE
Dial Status 11: HU - Hang UP REMOVE
Dial Status 12: ERI - Agent Error REMOVE
Dial Status 13: TIMEOT - Inbound Queue Timeout Drop REMOVE
Dial Status 14: PDROP - Outbound Pre-Routing Drop REMOVE
Dial Status 15: NANQUE - Inbound No Agent No Queue Drop REMOVE
Dial Status 16: NA - No Answer AutoDial REMOVE
Dial Status 17: N - No Answer REMOVE
Dial Status 18: B - Busy REMOVE
Dial Status 19: AM - Answering Machine SentToMesg REMOVE
Dial Status 20: AFTHRS - Inbound After Hours Drop REMOVE
Dial Status 21: ADCT - Disconnected Number Temporary REMOVE
Dial Status 22: ADC - Disconnected Number Auto REMOVE
Dial Status 23: AB - Busy Auto REMOVE
Dial Status 24: AA - Answering Machine Auto REMOVE
Dial Status 25: A - Answering Machine REMOVE
Dial Status 26: NEW - New Lead REMOVE
Add A Dial Status to Call: - NONE - ADD
List Order: DOWN COUNT 2nd NEW
List Order Randomize: N
List Order Secondary: LEAD_ASCEND
List Mix: DISABLED - DISABLED
Lead Filter: INTAKE_FILTER - Intake Filter
Drop Lockout Time: 0
Call Count Limit: 28
Call Count Target: 3
Minimum Hopper Level: 100
Automatic Hopper Level: Y
Automatic Hopper Multiplier: 1
Auto Trim Hopper: Y
Hopper VLC Dup Check: Y
Manual Dial Hopper Check: Y
Force Reset of Hopper: N
Dial Method: RATIO
Auto Dial Level: 1 (0 = off) ADAPT OVERRIDE
Auto Dial Level Threshold: WAITING_AGENTS agents: 2
Available Only Tally: Y
Available Only Tally
Threshold: NON-PAUSED_AGENTS agents: 2
Drop Percentage Limit: 5 %
Maximum Adapt Dial Level: 1 number only
Latest Server Time: 2100 4 digits only
Adapt Intensity Modifier: 0 - Balanced
Dial Level Difference Target: -3 --- 3 Agents Waiting for Calls
Dial Level Difference Target
Method: ADAPT_CALC_ONLY
Concurrent Transfers: AUTO
Queue Priority: 50 - Higher
Multiple Campaign Drop Rate
Group: DISABLED
Inbound Queue No Dial: DISABLED
Inbound No-Agents No-Dial: ---DISABLED---
Inbound No-Agents No-Dial
Threshold: 0 number only
Auto Alt-Number Dialing: NONE
Next Agent Call: longest_wait_time
Local Call Time: TCPA_OB - TCPA Outbound
State rules defined for this call time: 15
Dial Timeout: 20 in seconds
Dial Prefix: 9 for 91NXXNXXXXXX value would be 9, for no dial prefix use X
Manual Dial Prefix:
Omit Phone Code: N
Campaign CallerID: 8665524532
Custom CallerID: AREACODE
CID Group: ---DISABLED---
Routing Extension: 8368
Campaign Rec exten: 8309
Campaign Recording: ALLFORCE
Campaign Rec Filename: FULLDATE_CUSTPHONE_CAMPAIGN_AGENT_CALLID_INGR
Recording Delay: 0 in seconds
Routing Initiated Recording: N
Call Notes Per Call: DISABLED
Comments All Tabs: DISABLED
Comments Dispo Screen: DISABLED
Comments Callback Screen: DISABLED
QC Comments History: CLICK
Hide Call Log Info: N
Agent Lead Search: DISABLED
Agent Lead Search Method: CAMPLISTS_ALL
Script: -
Clear Script: ENABLED
Get Call Launch: WEBFORM
Answering Machine Message: vm-goodbye audio chooser
WaitForSilence Options:
AM Message Wildcards: N
AMD send to Action: N
CPD AMD Action: DISABLED
CPD Unknown Action: DISABLED
AMD Inbound Group: ---NONE---
AMD Call Menu: ---NONE---
Transfer-Conf DTMF 1:
Transfer-Conf Number 1:
Transfer-Conf DTMF 2:
Transfer-Conf Number 2:
Transfer-Conf Number 3:
Transfer-Conf Number 4:
Transfer-Conf Number 5:
Enable Transfer Presets: DISABLED
Hide Transfer Number to Dial: DISABLED
PrePopulate Transfer Preset: N
Quick Transfer Button: N
Custom 3-Way Button
Transfer: DISABLED
3-Way Call Outbound
CallerID: CUSTOMER
3-Way Call Dial Prefix: 88
Customer 3-Way Hangup
Logging: ENABLED
Customer 3-Way Hangup
Seconds: 5
Customer 3-Way Hangup
Action: NONE
3-Way Recording Stop: N
Hangup Xfer Recording Start: N
Park Call IVR: DISABLED
Park Call IVR AGI:
Timer Action: NONE
Timer Action Message:
Timer Action Seconds: 1
Timer Action Destination:
Scheduled Callbacks: Y
Scheduled Callbacks Alert: BLINK_RED_DEFER
Send Callbacks Email: N
Scheduled Callbacks Count: LIVE
Scheduled Callbacks Days
Limit: 7
Scheduled Callbacks Hours
Block: 0
Scheduled Callbacks Calltime
Block: ENABLED
Scheduled Callbacks Active
Limit: 0
Scheduled Callbacks Active
Limit Override: N
Scheduled Callbacks Display
Days: 7
My Callbacks Checkbox
Default: UNCHECKED
Show Previous Callback: ENABLED
Scheduled Callbacks
Useronly Move Minutes: 0
Next-Dial My Callbacks: DISABLED
Drop Call Seconds: 5
Drop Action: HANGUP
Safe Harbor Exten: 8307
Safe Harbor Audio: buzz audio chooser
Safe Harbor Audio Field: DISABLED
Safe Harbor Call Menu:
Voicemail: voicemail chooser
Drop Transfer Group: ---NONE---
Disable Dispo Screen: DISPO_ENABLED
Disable Dispo Status:
Script on top of Dispo: N
Wrap Up Seconds: 0
Wrap Up Message: Wrapup Call
Wrap Up Bypass: ENABLED
Wrap Up After Hotkey: DISABLED
Dead Call Max Seconds: 60
Dead Call Max Status: DCMX
Dead Call to Dispo Only: ENABLED
Dispo Call Max Seconds: 420
Dispo Call Max Status: DISMX
Agent Pause Max Seconds: 0
Agent Pause Max Status: PAUSMX
Agent Ready Max Seconds
Logout: 0
Customer Gone Warning
Seconds: 30
Use Internal DNC List: Y
Use Campaign DNC List: N
Other Campaign DNC:
Agent Pause Codes Active: FORCE
Auto Pause Pre-Call Work: N
Auto Resume Pre-Call Work: N
Auto Pause Pre-Call Code: PRECAL
Campaign Stats Refresh: N
Real-Time Agent Time Stats: CALLS_WAIT_CUST_ACW_PAUSE
Disable Alter Customer Data: N
Disable Alter Customer
Phone: Y
Allow No-Hopper-Leads
Logins: Y
No Hopper Dialing: N
Owner Only Dialing: NONE
Owner Populate: DISABLED
Agent Display Dialable Leads: Y
Agent Screen Labels: INTAKE_NEW
Allow Required Fields: N
Status Display Fields: CALLID
Status Display In-Group: ENABLED
Agent Display Fields:
Agent Screen Time Display: DISABLED
Agent Display Queue Count: Y
Agent View Calls in Queue: ALL
View Calls in Queue Launch: MANUAL
Agent Grab Calls in Queue: N
Agent Call Re-Queue Button: N
Agent Pause After Each Call: N
Agent Pause After Next Call
Link: DISABLED
Manual Dial Override: ALLOW_ALL
Manual Dial Override Field: DISABLED
Manual Dial List ID: 998
Manual Dial Filter: DNC_ONLY
Manual Preview Dial: PREVIEW_ONLY
Manual Dial Search
Checkbox: SELECTED_LOCK
Manual Dial Search Filter: CAMPLISTS_ALL
Manual Dial by Lead ID: N
Manual Call Time Check: DISABLED
Manual Dial API: STANDARD
Manual Dial CID: CAMPAIGN
Manual Dial Timeout: 60 in seconds
Phone Post Time Difference
Alert: DISABLED
In-Group Manual Dial: DISABLED
In-Group Manual Dial Select: CAMPAIGN_SELECTED
Manual Alt Num Dialing: N
Timer Alt Seconds: 0
Agent Screen Clipboard
Copy: NONE
Group Alias Allowed: N
CRM Popup Login: Y
CRM Popup Address: https://citizens.my.salesforce.com
Start Call URL:
Dispo Call URL: ALT Alternate Dispo URLs Defined: 1
No Agent Call URL:
Extension Append CID: N
Blind Monitor Warning: DISABLED
Blind Monitor Notice: Someone is blind monitoring your session
Blind Monitor Filename: audio chooser
Max Inbound Calls: 0
Max Inbound Calls Outcome:
Allowed Inbound Groups:
AGENTDIRECT - Single Agent Direct Queue - 99
AGENTDIRECT_CHAT - Agent Direct Queue for C hats - 99
CS - CS - 0
DNC_INBOU ND - IB Calls from number on DNC - 0
GOV_CALLS - Government Calls - 0
GOV_CONFIRM - Gov_Confirm - 0
INTAKE_DIALER - Intake_Inbound - 99
IVR - IVR TRACKING GROUP - 0
MED_AUDIT - Med_Audit_Callbac ks - 0
MED_PRO_CALLBACKS - Med Provider Callbacks - 0
SCHEDULING - Scheduling - 0
SUP_TEST - Supervisor Test - 0
TEST_INTAKE - Test Ingroup for INTAKE - -99
WETSIG - Wet Sig Callbacks - 0
Default Transfer Group: ---NONE---
Agent Transfer In-Group
Validation: N
Allowed Transfer Groups:
AGENTDIRECT - Single Agent Direct Queue
AGENTDIRECT_CHAT - Agent Direct Queue for Chats
CS - CS
DNC_INB OUND - IB Calls from number on DNC
GOV_CALLS - Government Calls
GOV_CONFIRM - Gov_Confirm
INTAKE_DIALER - Intake_Inboun d
IVR - IVR TRACKING GROUP
MED_AUDIT - Med_Audit_Callb acks
MED_PRO_CALLBACKS - Med Provi der Callbacks
SCHEDULING - Scheduling
SUP_TEST - Supervisor Test
TEST_INTAKE - Test Ingroup for INTAKE
WETSIG - Wet Sig Callbacks
SUBMIT
LISTS WITHIN THIS CAMPAIGN:
LIST ID LIST NAME DESCRIPTION LEADS COUNT Call Time ACTIVE LAST CALL DATE MODIFY
103 INTAKE Intake Leads 28995 campaign Y 2019-02-08 19:08:34 MODIFY
SUBMIT ACTIVE LIST CHANGES
This campaign has 1 active lists and 0 inactive lists
STATUSES WITHIN THE ACTIVE LISTS FOR THIS CAMPAIGN: - HIDE
STATUS STATUS NAME CALLED NOT CALLED DIALABLE PENETRATION
ACWT ACW Timeout 0 6 0 100%
ADC Disconnected Number Auto 0 160 0 88%
AFTHRS Inbound After Hours Drop 0 15 0 73%
AUTCON Spoke to AUTH. Contact 0 1 0 100%
B Busy 0 538 1 86%
CBHOLD Call Back Hold 0 126 28 4%
DA Dead Air 0 1 0 100%
DISMX Disconnected Max Seconds 0 113 3 77%
DISQ Disqualified 0 8038 0 100%
DN Dead Number 0 130 34 100%
DNC DO NOT CALL 0 682 0 100%
DNCL DO NOT CALL Hopper Sys Match 0 1997 0 100%
DROP Agent Not Available 0 35 0 68%
ERI Agent Error 0 16 0 81%
FAILED Failed Transfer 0 10 0 80%
INC Incomplete 0 923 18 86%
INCALL Lead Being Called 0 1 0 0%
LM Left Message 0 5165 77 88%
NA No Answer AutoDial 0 7886 132 83%
NANQUE Inbound No Agent No Queue Drop 0 8 1 75%
NEW New Lead 0 1008 12 0%
PDROP Outbound Pre-Routing Drop 0 1 0 100%
PU Call Picked Up 0 1 0 0%
QUAL Qualified 0 1427 0 100%
SC Spoke To Client 0 23 0 73%
SETCB Set Callback 0 28 2 46%
VMFULL Mailbox Full 0 415 9 100%
WAITTO 0 14 1 7%
WRONG Wrong Number 0 227 54 100%
SUBTOTALS 0 28995
TOTAL 28995 372 88%
This campaign has 255 leads to be dialed in those lists - HIDE
This campaign has 102 leads in the dial hopper
Click here to see what leads are in the hopper right now
Click here to see a VDAD report for this campaign
Click here to see all CallBack Holds in this campaign
Test Outbound Call: code: number: server: DEFAULT - 172.24.8.91
PLACE TEST CALL
Click here to see Admin changes to this campaign
LOG ALL AGENTS OUT OF THIS CAMPAIGN
DELETE THIS CAMPAIGN
VERSION: 2.14-664a
BUILD: 180310-2321
© 2018 ViciDial Group

Regards,

Jessie

[williamconley]

1) Welcome to the Party!

2) As you are obviously new here, I have some suggestions to help us all help you:

When you post, please post your entire configuration including (but not limited to) your installation method (7.X.X?) and vicidial version with build (VERSION: 2.X-XXXx ... BUILD: #####-####).

This IS a requirement for posting along with reading the stickies (at the top of each forum) and the manager's manual (available on EFLO.net, both free and paid versions)

You should also post: Asterisk version, telephony hardware (model number is helpful here), cluster information if you have one, and whether any other software is installed in the box. If your installation method is "manual/from scratch" you must post your operating system with version (and the .iso version from which you installed your original operating system) plus a link to the installation instructions you used. If your installation is "Hosted" list the site name of the host.

If this is a "Cloud" or "Virtual" server, please note the technology involved along with the version of that techology (ie: VMware Server Version 2.0.2). If it is not, merely stating the Motherboard model # and CPU would be helpful.

Similar to This:

Vicibox X.X from .iso | Vicidial X.X.X-XXX Build XXXXXX-XXXX | Asterisk X.X.X | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel DG35EC | Core2Quad Q6600

3) While you may find it interesting to post your entire system's massive data in various areas, what you're really doing is obfuscating any information which may be useful. Try to avoid posting 3000 lines of unrelated data in a post. You may find that the attention span of the reader (who may be very busy) is not long enough to read through that long of a post.

4) Simpler if you test the sql query in question on your vicidial_list table directly and see what you get for results. Skip the "1=1" of course (which shouldn't be there anyway). There's even a function for testing within the filter modify page. Another option is to use the filter on a campaign and see how it affects your available leads count. If you modify the time to several hours, it should omit all the leads you've called in the last several hours. Also test one step at a time to see if each piece works before you begin assembly, then assemble one piece at a time and see if the results are what you expect. Directly executing the sql in the mysql command line or phpmyadmin will give you legible error reports if you screw anything up, plus very visible lead results so you can see what is returned vs what you expected.

[jessiekidfernando]

Thank you so much for your inputs William.