Call transfer logging

FreePBX
1

Is anyone aware of a way either natively through FreePBX or through a third party utility to monitor and log call transfers? For example, using CDR reports I can see when a call hits the main inbound number to the receptionist. However, when she transfers the call to an extension, there’s no record of it.

We have enabled CEL reporting and if you hit the link in CDR reports it will allow you to drill down into the call and see a transfer, but this is only useful if you already know a call was transferred and when it came in.

Is there a method for generating a report of all calls that will show any associated transfers?

2

perhaps…

select * from asteriskcdrdb.cel where eventtype in ("BLINDTRANSFER","ATTENDEDTRANSFER");
3

Thanks James. I was able to get that working, but as my MySQL skills are a bit lacking, what are the modifiers I could throw in to parse the query into say, current month, week, day, etc?

Also, it doesn’t seem to show where the call was transferred, just that a transfer occurrred.