How can I show the "Inbound Called Number in CDR

6string

Joined
Mar 20, 2009
Messages
44
Likes
0
Points
0
#1
I have a customer who needs to track how many Inbound calls to a particular DID
The CDR report currently shows the inbound CID as the Source and the Ext or Ring Group as the Destination. Is there a way to show the inbound DID number in this report?

Or see the CID name Prefix from the Inbound Route or Ring Group.
I currently see this information (CID name Prefix) in the ARI Monitoring, but I can't export it from there.

Thanks !!
 

gquiles

Joined
Jul 15, 2010
Messages
10
Likes
0
Points
0
#2
did you found a workaround for this issue?
im in the same problem...
 

dicko

Joined
Oct 24, 2008
Messages
4,099
Likes
0
Points
0
#3
the cdr's are stored in two places , the mysql database and in a csv format in /var/log/asterisk/cdr-csv/Master.csv

the fields are documented here:

http://www.voip-info.org/wiki/view/Asterisk+billing

you can either modify the code in the various cdr reporting pages, Elastix or FreePBX, or you could use the raw data to extract what you want, either mysql or your language of choice and the csv data.
 

gquiles

Joined
Jul 15, 2010
Messages
10
Likes
0
Points
0
#4
Thank you sir!
 

vaibhavs

Joined
Oct 2, 2009
Messages
95
Likes
0
Points
0
#5
IMO you will need to tweak the dial plan to record the DNID (called number) and store it in a custom field 'userfield'. That's how someone a friend of mine did it for me.

Not sure if there is a better way to do this. But its working well for me.
 

6string

Joined
Mar 20, 2009
Messages
44
Likes
0
Points
0
#6
Thanks for your response
Do you have any details on how to do this?
 

gquiles

Joined
Jul 15, 2010
Messages
10
Likes
0
Points
0
#7
i can all the info i need via mysql.
now im looking on how can i made a new report from mysql.

is there another way of solving this issue or im going the right way???
 

gquiles

Joined
Jul 15, 2010
Messages
10
Likes
0
Points
0
#8
is there any type of tutorial on how to add more options
to the Freepbx or CDR report of elastix???
 

shaunw

Joined
Dec 18, 2011
Messages
78
Likes
0
Points
0
#9
Say, Did you ever find a tutorial? I'm having similar difficulty.
 

Members online

No members online now.

Latest posts

Forum statistics

Threads
30,902
Messages
130,887
Members
17,565
Latest member
omarmenichetti
Top