Hi, Sorry, but i forgot to notice that i am already using the 'userfield' column so that's not a possibility. Is there any way i can add the IP address to a custom MySQL field in CDR? With AGI possibly? The problem is, that the CDR entry is written in MySQL when the call is hungup, so i have no possibility to write the IP address after a call.
Regards, Remco On 06/29/2010 03:53 PM, Zeeshan Zakaria wrote: > Hi, > > There is usually an empty column in the cdr table named 'userfield'. You > can also add a column of your own. Then in the dialplan use: > > Set(CDR(userfield)="user IP address") > > And this will automatically add this information into the userfield column. > > Do you already have script to capture user's IP address? If not, check > it here how I am capturing it: > > http://www.ilovetovoip.com/2010/05/getting-users-ip-address-remaining-within-the-dialplan > > Zeeshan A Zakaria > > -- > www.ilovetovoip.com <http://www.ilovetovoip.com> > >> On 2010-06-29 8:20 AM, "Faisal Hanif" <fai...@vopium.com >> <mailto:fai...@vopium.com>> wrote: >> >> Simply set it to costume field of cdrs in dialplan and you will have >> it a part of native cdr >> Regards, >> >> *Faisal Hanif* >> >> -- >> _____________________________________________________________________ >> -- Bandwidth and Colocation Provided by http://www.api-digital.com -- >> New to Asterisk? Join us for a live introductory webinar every Thurs: >> http://www.asterisk.org/hello >> >> asterisk-users mailing list >> To UNSUBSCRIBE or update options visit: >> http://lists.digium.com/mailman/listinfo/asterisk-users > -- Met vriendelijke groet, Signet bv Remco Bressers T 040 - 707 4 907 F 040 - 707 4 909 E rbress...@signet.nl altijd online? www.signet.nl -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users