Carrier Log Inaccuracies

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Carrier Log Inaccuracies

Postby elyc1990 » Thu Nov 23, 2017 10:57 am

Hi all,

I tried calling myself to check the accuracy of carrier log (Admin Utilites > Carrier Log Report). I realize that it does not record time accurately.

Eg I pick up the call and answer for 10seconds but the "Dial Time" shows 7 seconds and "Answered Time" shows 0 second. If I didn't pick up the call, both "Dial Time" and "Answered Time" show 0 second.

Can anyone please help me debug this?

I'm running scratch install with the following version:
VERSION: 2.14-636a
BUILD: 171011-1450
elyc1990
 
Posts: 26
Joined: Fri Dec 16, 2016 5:35 am

Re: Carrier Log Inaccuracies

Postby mflorell » Thu Nov 23, 2017 7:02 pm

Those numbers come from the asterisk channel variables, and they are known not to be accurate. There isn't much you can do about it.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Carrier Log Inaccuracies

Postby blackbird2306 » Thu Nov 23, 2017 9:14 pm

Yes, you cannot rely 100% on these values, but for a better overview try this:
Report --> Admin Utilities --> Export Calls Report Carrier
1. Select "Export Fields" with "Extended" for detailed information.
2. Download and open the sheet with Excel.

Here are the values you are looking for:
Dial Time (only filled if there was an answer) = how long time it took until there was an answer
length_in_sec = connection time (billing time)


and for the 0 seconds Dial Time fields (no answer, busy and so on) you can use a trick:
Dial Time (convert in seconds look in excel forums for help) = (carrier log call_date field) - (dial log call_date field)
Vicibox 6.0.2 from Vicibox_v.6.0.x86_64-6.0.2.iso | Vicidial 2.12-560a build: 160617-1427 | Asterisk 1.8.32.3
blackbird2306
 
Posts: 409
Joined: Mon Jun 23, 2014 5:31 pm

Re: Carrier Log Inaccuracies

Postby elyc1990 » Fri Nov 24, 2017 10:44 am

Thanks Matt and Blackbird!

Just a follow up Blackbird, the length_in_sec for manual calls include "Dial Time". Is this normal?

One more question, may I know what is the difference between Dial Log and Carrier Log in the "Export Calls Report Carrier"? Because the SIP Response in the columns "dial log sip_hangup_cause" and "carrier log sip_hangup_cause" can be different sometimes.
elyc1990
 
Posts: 26
Joined: Fri Dec 16, 2016 5:35 am

Re: Carrier Log Inaccuracies

Postby blackbird2306 » Fri Nov 24, 2017 6:27 pm

As we have mentioned above - all these values are not 100 % . Sometimes it's possible that length_in_sec includes some extra seconds mixed with Dial Time but normally not.
Dial-Log hangup cause (db table vicidial_dial_log) and Carrier-Log hangup cause (db table carrier_log) values are generated from different database tables. But the codes from both are identical for me.
Vicibox 6.0.2 from Vicibox_v.6.0.x86_64-6.0.2.iso | Vicidial 2.12-560a build: 160617-1427 | Asterisk 1.8.32.3
blackbird2306
 
Posts: 409
Joined: Mon Jun 23, 2014 5:31 pm


Return to Support

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 85 guests