Solved Activity LOG- DIDs DINs

Discussion in '3CX Phone System - General' started by VPCIII, Feb 17, 2018.

Tags:
Thread Status:
Not open for further replies.
  1. VPCIII

    Joined:
    Feb 6, 2018
    Messages:
    9
    Likes Received:
    2
    I am looking for a way to list the numbers that were dialed in by customers, in coming callers, so I can tell where the calls are generated from.(which ads). We are using ATT and COX SIP service, I only see the Caller ID, not the DIN used to place the call. Is there a way to get this info from 3CX logs?? Both ATT and COX do not provide this information...
     
  2. mariosM_3CX

    mariosM_3CX Support Team
    Staff Member 3CX Support

    Joined:
    Nov 1, 2017
    Messages:
    406
    Likes Received:
    38
    Well this information is in the logs, but not in a way that you can easily and automatically manipulate it. Getting the CDR from the PBX might help. The trunk number is logged in CDR so you can match the DID to the trunk number. In case of multiple DIDs per trunk, you can append the name of the inbound rule to the caller id(MMC>>Contacts>>Options>>Add Group, Queue or DID/DDI Names to Caller ID) and this will be shown in CDRs as well.
    For more info on CDR check this guide https://www.3cx.com/docs/cdr-call-data-records/
     
  3. voiptoys

    voiptoys Active Member

    Joined:
    Feb 13, 2013
    Messages:
    727
    Likes Received:
    125
    If you want to automate parsing the 3CX CDR files into a database for easy querying, we have released a new version of our Exporter tool that has this feature built in. Once the data is in SQL, it would be fairly simple to automate scheduled reports (or ad-hoc reports) to get the information you need.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 voiptoys, Feb 20, 2018
    Last edited: Mar 1, 2018
  4. VPCIII

    Joined:
    Feb 6, 2018
    Messages:
    9
    Likes Received:
    2
    Thanks Marios, working on your suggestion now..
     
  5. mariosM_3CX

    mariosM_3CX Support Team
    Staff Member 3CX Support

    Joined:
    Nov 1, 2017
    Messages:
    406
    Likes Received:
    38
Thread Status:
Not open for further replies.