Report: Total talk time per extension

[pmterp]

I had what I thought was a reasonable request but haven't been able to find a suitable answer.
The client wants a report that shows total inbound and total outbound talk time on an extension level (not limited to queue calls).
I've looked through the list of reports and can't find that. The best I came up with is pulling 2 call reports per extension, 1 for inbound and 1 for outbound, and getting the totals from the bottom. With about 40 extensions they want this data on, that would be too time consuming to be practical.
Anyone know of a report that has that data?

 

[VoIPTools]

I am not an expert on 3CX built-in reports. What I can offer is how to build your own custom reports should you find the 3CX reports don't meet your specific needs.

3CX can be configured to save Call Detail Records (CDR) information to a file. My preference is to save a separate file for each call. The CDR data is very straightforward and has all the information you need. The only challenge is how to get this data into a format that you can use to build a custom report.

The CDR file is a simple CSV file. You could, for example, import the files into Excel, then use Excel to build your report. Alternatively, you could use our Exporter tool to automatically parse the data and save it in Microsoft SQL Server.

Once you have the data in a database, building your desired report should be straightforward. Any reporting tool such as Crystal Reports, Excel, or SQL Reporting Services can read SQL data.