Callers data hangup during ivr

[muyousif]

Hi,

Is it possible to extract inbound callers data who hangup during ivr/call menus before reaching to inbound group?

Thanks.

[ambiorixg12]

What data exactly would you like to extract ?

[muyousif]

Callers info who disconnected during ivr before reaching to agents, who just listened to ivr options but didn't press 0 to reach agent and disconnected call.

[ambiorixg12]

All calls inbound and outbound are stored on table call_log, but using this table I dont see a way for you to indentify if caller listen to the IVR and then hangup. I would suggest make little script in a custom context and catch ${CALLERID(num)} variable and time before send the call to the call menu. In this way you will have a least a list of caller who dial in to the IVR. Dont know if is there is an easy method using vicidial GUI, as I used to custom code most of the things I need, dont blame me, I'm a frustrated developer lol

[muyousif]

Thanks for your help, following query helped me to catch required data.

select distinct(phone_ext) from live_inbound_log where uniqueid NOT IN (select distinct(uniqueid) from vicidial_closer_log);