Page 1 of 1

Carrier CDR consolidation

PostPosted: Thu Oct 01, 2015 3:58 pm
by Vince-0
I'm trying to compare carrier CDRs with Vici because we have a way higher than normal bill (double the amount of live agents.)

I realise that the seconds may differ slightly for each call, especially because the Vicidial carrier trunk is connected via a FreePBX to get to the carrier (legacy reasons)
I'd like to sum the total length_in_min in vicidial_log table to get some indication of talk time from Vicidial.

Do I need to exclude inbound calls somehow?
How can I best consolidate CDRs with the carrier's?

Thanks,
Vin.

Re: Carrier CDR consolidation

PostPosted: Fri Oct 02, 2015 4:42 am
by mflorell
Asterisk CDRs have never been that accurate unfortunately. As for Vicidial, if you only want outbound calls, those are in the vicidial_log table, and inbound calls are in the vicidial_closer_log table.

Re: Carrier CDR consolidation

PostPosted: Fri Oct 02, 2015 4:53 am
by Vince-0
Thanks Matt, explains a lot.

Re: Carrier CDR consolidation

PostPosted: Mon Oct 12, 2015 11:22 pm
by nandotech
Personally, I always fall back to the carrier log and take that as the final word.

By that time, I've already paid them--after all. ;)

edit:

and by carrier log, I mean the CDR reports pulled directly from my different carriers.
Otherwise I do also have an SBC that logs outbound calling, but not inbound :)