bar top left
bar top right
left curve
right curve
Welcome, Guest

How can I show the "Inbound Called Number in CDR
(1 viewing) (1) Guest
Go to bottom
Post Reply
Post New Topic
Page: 1
TOPIC: How can I show the "Inbound Called Number in CDR
#55705
How can I show the "Inbound Called Number in CDR 1 Year, 7 Months ago Karma: 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 !!
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
6string
Learning to fly
Fresh Boarder
Posts: 38
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: Salt Lake City, Utah USA Birthday: 06/30
Reply Quote
 
#55934
Re: How can I show the "Inbound Called Number in CDR 1 Year, 6 Months ago Karma: 0
did you found a workaround for this issue?
im in the same problem...
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
gquiles
Fresh Boarder
Posts: 10
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#55939
Re: How can I show the "Inbound Called Number in CDR 1 Year, 6 Months ago Karma: 155
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:

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.
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
dicko
Ethically, I no longer support PaloSanto, Sorry.
Platinum Boarder
Posts: 4101
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: Not available Birthday: 01/21
There are other solutions!!
Reply Quote
 
#55961
Re:How can I show the "Inbound Called Number in CDR 1 Year, 6 Months ago Karma: 0
Thank you sir!
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
gquiles
Fresh Boarder
Posts: 10
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#56412
Re:How can I show the "Inbound Called Number in CDR 1 Year, 6 Months ago Karma: 0
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.
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
vaibhavs
Junior Boarder
Posts: 85
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#56418
Re:How can I show the "Inbound Called Number in CDR 1 Year, 6 Months ago Karma: 1
Thanks for your response
Do you have any details on how to do this?
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
6string
Learning to fly
Fresh Boarder
Posts: 38
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: Salt Lake City, Utah USA Birthday: 06/30
Reply Quote
 
#56445
Re:How can I show the "Inbound Called Number in CDR 1 Year, 6 Months ago Karma: 0
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???
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
gquiles
Fresh Boarder
Posts: 10
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#56549
Re: How can I show the "Inbound Called Number in CDR 1 Year, 6 Months ago Karma: 0
is there any type of tutorial on how to add more options
to the Freepbx or CDR report of elastix???
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
gquiles
Fresh Boarder
Posts: 10
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
Go to top
Post Reply
Post New Topic
Page: 1
Moderators: rafael, Bob, jgutierrez