How can I show the "Inbound Called Number in CDR - Elastix Forums :: Open Source Unified Communications Server

Select

EnglishEspañol

BUY ON LINE

February 2012

Posts	User
53	soborno
38	danardf
36	Bob
30	jgutierrez
15	achilles
12	FresyMetal
9	rajtka
7	Amphibian
7	DrVoIP
7	tottocol

Welcome, Guest

Username Password:

Forgot your Password? Forgot your Username? Create Account

Elastix Forums :: Open Source Unified Communications Server

Elastix

Help

How can I show the "Inbound Called Number in CDR

(1 viewing) (1) Guest

Page: 1

TOPIC: How can I show the "Inbound Called Number in CDR

Forum Tools

#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 !!

6string

Learning to fly

Fresh Boarder

Posts: 38

#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

#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.

dicko

Ethically, I no longer support PaloSanto, Sorry.

Platinum Boarder

Posts: 4101

There are other solutions!!

#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

#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

#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

#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

#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

Page: 1

Elastix Forums :: Open Source Unified Communications Server

Elastix

Help

Moderators: rafael, Bob, jgutierrez

get the latest posts directly to your desktop