Page 1 of 1

Callerid and trunk info in log tables for outbound calls

PostPosted: Thu Mar 13, 2025 12:32 pm
by areon
Dear experts

Which log table stores information about the number from which the outgoing call is made (CallerID) and the trunk through which the call was made?



VERSION: 2.14-924a
BUILD: 240716-1453

Re: Callerid and trunk info in log tables for outbound calls

PostPosted: Thu Mar 13, 2025 3:47 pm
by williamconley
vicidial_carrier_log contains dial string (channel) which uses a prefix to determine which carrier to use. However: That's not technically "the carrier" which is not logged by name.

Code: Select all
+---------------+---------------------+---------------+-----------+--------------+------------+---------------------------------------+-----------+---------------+------------------+-------------------+----------------------+
| uniqueid      | call_date           | server_ip     | lead_id   | hangup_cause | dialstatus | channel                               | dial_time | answered_time | sip_hangup_cause | sip_hangup_reason | caller_code          |
+---------------+---------------------+---------------+-----------+--------------+------------+---------------------------------------+-----------+---------------+------------------+-------------------+----------------------+
| 1741807971.18 | 2025-03-12 15:32:53 | 192.168.1.249 | 872410813 |           16 | ANSWER     | Local/717035550000@default-00000002;2 |         2 |             0 |                0 |                   | V3121532500872410813 |
+---------------+---------------------+---------------+-----------+--------------+------------+---------------------------------------+-----------+---------------+------------------+-------------------+----------------------+


vicidial_dial_log has "Outbound CID" field which contains the "name" and <number> used (note that the name is actually a code for autodialed calls, which generally contains the Lead ID as the last digits in an otherwise fairly random string). This also still has the "channel" containing the dial prefix which should identify the carrier.

call_log has a "channel" field as well, which has the Account Name of the trunk used on certain types of records (one leg of a call after the call is live).