cdr database

  1. How does myphone_callhistory_v14 link to callcent_queuecalls

    We are working on an integration to pull call logs, however I can't find a column that contains a unique identifier that exists in both callcent_queuecalls and myphone_callhistory_v14. Call Logs have call_id which is a sequential number but queuecalls have a call_history_id, how do I get the...
  2. Differences between CDR record and Total Queue Report

    Hi I have created a method to extract the information from the CDR socket and read it with an external report program, the data is stored in a database with the same characteristics as the cdr.log file. at this point everything is fine. The problem occurs when at the end of the day you...
  3. dkirk-ads

    CDR Reporting - CallSequiter & CallVitesse - you need this and may not even know it!

    I've not seen this major update posted anywhere so here goes. The CallSequiter program has been around for a spell and it slices and dices your CDR information pulled directly out of 3CX. 3CX has a nifty provision to export CDR information in real-time through a direct connection. CallSequiter...
  4. How to send outbound calls only as a CDR to TCP socket

    Hi, i am new to 3cx, I want to get only outbound calls details (from, to , date_time, duration) as CDR in real time, i read about the tcp socket but how can i filter for outbound calls only?, there is a cdr field which detect that it is an outbound call? maybe can i query 3cx somehow for it? Thanks.
  5. Connecting to the CDR database

    Hello guys, i need to connecting to the CDR database, how can i do it? I have the version 15.5. Do you know the name of database with user/password? Thanks