Call Reporting Unique Case

[MicroChop]

Good evening all,

I'm trying to pull off a report from 3CX to find out how many times a extensions is called and a parked call wasn't picked up afterwards.

As a full example:

External call comes in via IVR, callers press 1 to speak to "Reception"
Reception answers, call is placed on SP1 (Parked 1)
Internal extension is called and internal extension picks up but refuses to take SP1 call, call ends.
Reception calls another extension and that extension picks up SP1 instead.

While I know that call type is specific I wondered if anyone knew if I can pull off such a reporting feat.

 

[VoIPTools]

I don't think you are going to get that specific of a report natively out of 3CX. You are going to have to build the report from scratch.

The only way you can do that is to get to the call history information. To do that, you only have a couple of options: (1) generate reports in 3CX and export to CSV, then use that data as a source, or (2) configure 3CX to create CDR files and then parse those files -- they include a list of all the call legs (list of extensions), or (3) go to the 3CX database directly, but that is STRONGLY discouraged by 3CX and could get you into a lot of trouble if you don't do it very carefully.

The last option is to look at some of our tools. For example, we have a carefully crafted read-only REST API you can use to get the data. It returns a list of json objects (records) which you can use, or you can look at our Exporter tool which automatically synchronizes the data in 3CX (and CDR files) with your SQL or MySQL database.