Inbound Drop call or Abandon issue

[heart200306]

Dear guys

Anyone help me to find Inbound Drop Call with caller id ? I am finding report >Inbound Report by DID> All drop call but here is not showing caller id: : where I found drop call with Customer ID(caller ID)? Please help .

Drop call or unanswered calls to a particular mailbox and also voicemail to mail .. is it possible ???


Asterisk 1.4.44-vici

ISO ::ViciBox.x86_64-4.0.3.iso
ViciBox Server v.4.0!
SVN Version: 1953
DB Schema Version: 1341
Server :Cluster
VERSION: 2.6-396a
BUILD: 130402-2322

: No senguma , No other SW install

[heart200306]

where I found Abandon call or Drop call list ? Please advise

[adam.greenhalgh1]

Heart,

Could you not use; Search For a Lead feature. Lists>Search For A Lead

You can search by 'status' (disposition on the call). If you type 'drop' or 'vdad' or a specific status that you would like to see. It should bring up ALL the leads with that certain status/disposition.

Alternatively, you could go to Reports>Export call report and fill in the query and export your report. Here you can search via status/disposition and I've just done a blag one then and it does export the telephone number with it.

Adam.

[heart200306]

Thanks adam .. would you help me another things . how can I find inbound and outbound cdr details ?

[adam.greenhalgh1]

Heart,

There is no direct button i don't think, but if its details on calls. You can use the methods ive stated above to get the details on the calls.

Either search for a particular number/name/status/agent and that will produce a report of the leads that fall under your criteria. Go to administration screen, * Lists>Search for a lead.*
Or
Alternatively, you could go to Reports>Export call report and fill in the query and export your report. Here you can search via status/disposition - This will present you with all the calls that fall under your criteria.

Adam.

[jamz]

Hi,

I wrote a custom SQLScript to do this. I put the script in a webpage and the managers are able to click refresh and get the data.

The script is:

select length_in_sec, a.lead_id lid, a.call_date cd, a.phone_number pn, a.user tu1, a.status, e.first_name cu1, e.last_name cu2, address1, postal_code
from vicidial_closer_log a
left join vicidial_list e on a.lead_id = e.lead_id
where date(a.call_date) = '2013-07-26' and a.campaign_id IN('XXXX','XXXX') order by a.call_date

Put in the date you want, and replace the XXXX with your inbound campign_id.

if you add and where status = 'DROP' you'll get just the drops otherwise the above will give you ALL inbound calls for the ingroup for the date selected.

I hope his helps.

[heart200306]

Thank you all

[iboam]

UPdate .....

Code: Select all

SELECT
Count(vicidial_list.`status`)
FROM `vicidial_list`
WHERE
vicidial_list.entry_date >= '2016-04-07' AND
(vicidial_list.`status` = 'DROP' OR
vicidial_list.`status` = 'TIMEOT' OR
vicidial_list.`status` = 'INBND')


[williamconley]

mysql has a date function, so you can have it automgically show "today" or "yesterday" even.

CURDATE() instead of '2016-04-07'