Dial plan to insert database entry

[rhasan]

I have multiple inbound DID. I want report for how many calls entered using each DID. Any one can help me regarding this please.

my inbound dial plan is as below:

exten => 2000,1,Set(__FROM_DID=${EXTEN})
exten => 2000,n,Gosub(app-blacklist-check,s,1)
exten => 2000,n,ExecIf($[ "${CALLERID(name)}" = "" ] ?Set(CALLERID(name)=${CALLERID(num)}))
exten => 2000,n,SetMusicOnHold(121citycell)
exten => 2000,n,Set(__MOHCLASS=121citycell)
exten => 2000,n,Set(__CALLINGPRES_SV=${CALLERPRES()})
exten => 2000,n,Set(CALLERPRES()=allowed_not_screened)
exten => 2000,n(dest-ext),Goto(ivr-3,s,1)

exten => 5000,1,Set(__FROM_DID=${EXTEN})
exten => 5000,n,Gosub(app-blacklist-check,s,1)
exten => 5000,n,ExecIf($[ "${CALLERID(name)}" = "" ] ?Set(CALLERID(name)=${CALLERID(num)}))
exten => 5000,n,Set(__CALLINGPRES_SV=${CALLERPRES()})
exten => 5000,n,Set(CALLERPRES()=allowed_not_screened)
exten => 5000,n(dest-ext),Goto(ext-trunk,4,1)

exten => 5009,1,Set(__FROM_DID=${EXTEN})
exten => 5009,n,Gosub(app-blacklist-check,s,1)
exten => 5009,n,ExecIf($[ "${CALLERID(name)}" = "" ] ?Set(CALLERID(name)=${CALLERID(num)}))
exten => 5009,n,SetMusicOnHold(121citycell)
exten => 5009,n,Set(__MOHCLASS=121citycell)
exten => 5009,n,Set(__CALLINGPRES_SV=${CALLERPRES()})
exten => 5009,n,Set(CALLERPRES()=allowed_not_screened)
exten => 5009,n(dest-ext),Goto(ivr-243,s,1)

 

[soborno]

Hi,

You can look here how to interact with mysql database:
http://www.voip-info.org/wiki/view/Asterisk+cmd+MYSQL
It gives some cool examples!

Regards,
Claudio