CDR ( Call Detail Records )

[votexh]

We were using asterisk base Issabel in Issabel CDR we can get the info of CallerID use on call , Prefix used by Agent and also call connected trunk details ( like if we have multiple vendors from which vendor this call connects) shows in destination channel

We have multiple vendors in 3cx their is no detail of channels or prefix of Outbound Route used by customer when call connects or CallerID of Outbound route in CDR of 3cx . This is very difficult for us to troubleshoot the complaints of agents. It gives very little info in Call log .How we can get these info on Call log or this feature is missing in 3cx

 

[Evolute IT]

Use a packet capture?

 

[votexh]

use a packet capture is third party or additional thing to run with 3cx which is more work in asterisk issabel these reports are attached already in CDR . If they add these it should help supervisors , technical support users and audit team to work in smooth way otherwise it is very time taking to make a report or do the troubleshooting

 

[Evolute IT]

use a packet capture is third party or additional thing to run with 3cx which is more work in asterisk issabel these reports are attached already in CDR . If they add these it should help supervisors , technical support users and audit team to work in smooth way otherwise it is very time taking to make a report or do the troubleshooting

Packet captures are built-in into phones and 3CX. No need for "third-parties".

 

[VoIPTools]

3CX does provide the option to create Call Detail Records (CDR). These CDR files are simple text files that contain basic summary information about each phone call including caller ID, extension, number dialed, trunk number, duration, cost, etc.

https://www.3cx.com/docs/cdr-call-data-records/

While the data is straightforward, the stumbling block often times is getting the data into a useable form that reports can use. Like many legacy phone systems, you can either connect to the CDR data using an IP socket connection, or process the text files and place the data into a database. Once the data is in a database, then any reporting solution will work (Power BI, Crystal Reports, Excel, etc.).

I personally do not recommend the IP socket approach simply because if your socket goes down, for any reason -- network outage, software upgrade, bug, any call that take place during the outage will be lost forever. In contrast, working with the CDR files means if you have an outage, you can always catch up with any new transactions that came in since the last time you processed the files.

I encourage you to take a look at our 3CX Exporter tool. This tool monitors for new CDR files and processes them in real-time. It does not matter if your 3CX is hosted in the cloud (excluding 3CX hosting) or on-prem. We collect the data and push the information to either Microsoft SQL Server, MySQL, or MariaDB in real-time.

 

[votexh]

As per the instructions on https://www.3cx.com/docs/cdr-call-data-records/ this is old Version 18 we follow this but when we request generate it didn't generate instead it just save and move to new window no CDR file generates or ask for output file location in V20 . This option is in Admin Console-- Advance > CDR . But same their is no option to get the output of the file at any location it just give the options of what CDR output fields we need and than save no option of generation CDR

 

[VoIPTools]

The CDR files are created automatically as phone calls take place and are stored on disk on the 3CX server.

 

[votexh]

how we can extract this CDR file from 3cx Server and at which location these files stored ? And dont you think 3cx should give this feature to download it directly from GUI for ease of work like Issabel