Page 1 of 1

Tracking down Recordings based on inbound DID/Group.

PostPosted: Wed Feb 18, 2015 3:24 pm
by sbenson
I am looking to find a way to link the recordings, back to the inbound DID. Is there any suggestion on how to accomplish this? I have looked at the database and didn't see a clear path to link the recording to anything other than the leadID. Is there a way that I'm not seeing to get the leadID to the inbound call/Group/DID? Thanks in advance

Re: Tracking down Recordings based on inbound DID/Group.

PostPosted: Wed Feb 18, 2015 4:04 pm
by mflorell
There is no direct link, but you can use the uniqueid to link to a recording_log entry(vicidial_id) for outbound calls or a uniqueid to link to a closecallid to a recording_log vicidial_id.

Re: Tracking down Recordings based on inbound DID/Group.

PostPosted: Wed Feb 18, 2015 7:16 pm
by sbenson
mysql> select * from recording_log order by recording_id desc limit 1\G
1. row *
recording_id:
channel:
server_ip:
extension:
start_time:
start_epoch:
end_time: NULL
end_epoch: NULL
length_in_sec: NULL
length_in_min: NULL
filename:
location: NULL
lead_id:
user:
vicidial_id:
1 row in set (0.00 sec)

no closecallid listed on this version unfortunately. Is there a location to look up the leadid in calls based on the time it happened?

The uniqueid on outbound calls doesn't seem to match anything in the recording log, I'm not sure what I am missing here.

Re: Tracking down Recordings based on inbound DID/Group.

PostPosted: Wed Feb 18, 2015 9:42 pm
by mflorell
The vicidial_id field in recording_log should match up to the vicidial_log.uniqueid for outbound calls and the vicidial_closer_log.closecallid for inbound calls.

Re: Tracking down Recordings based on inbound DID/Group.

PostPosted: Mon Mar 16, 2015 3:08 pm
by sbenson
An update to this.

RecLog.lead_id = List.lead_id List.vlc = callmenu.menu_id
This was possible, I was looking at it in the wrong direction.