Page 1 of 1

Are the tables 'vicidial_agent_log' and 'call_log' related?

PostPosted: Mon Jul 27, 2009 6:07 am
by The_Assimilator
It seems that they should be able to be linked if one converts call_log.uniqueid to a datestamp and then links it to vicidial_agent_log.event_time, but this does not work.

Is there another way to join up these tables, or are they actually unrelated?

PostPosted: Mon Jul 27, 2009 3:00 pm
by mflorell
they are pretty much unrelated.

PostPosted: Tue Jul 28, 2009 3:21 am
by The_Assimilator
In that case, what is call_log used for? Simply logging all calls made via Asterisk? If that's so, is it a substitute for Asterisk's cdr table?

PostPosted: Tue Jul 28, 2009 3:34 pm
by mflorell
Exactly, you can't trust Asterisk's CDR, especially with all of the wacky call routing we do int ViciDial.