userdoc:tt_asterisk-odbc

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision Both sides next revision
userdoc:tt_asterisk-odbc [2014/07/03 13:41]
abelbeck [Mass Deployment SQL Table] 		userdoc:tt_asterisk-odbc [2014/07/03 13:54]
droemel [Mass Deployment SQL Table]
Line 122: Line 122:
  
 Following the examples above, adding a context to ''/etc/asterisk/func_odbc.conf'' to define a new function, the dialplan can use the PhoneProv data. Following the examples above, adding a context to ''/etc/asterisk/func_odbc.conf'' to define a new function, the dialplan can use the PhoneProv data.
 +
 +  [SIPACCOUNT]
 +  dsn=asterisk
 +  readsql=SELECT ${ARG1} FROM phoneprov WHERE ${ARG2}='${SQL_ESC(${ARG3})}'
 +
 +In the dialplan you could then use something like this:
 +
 +  same => n,Set(val=${ODBC_SIPACCOUNT(account,ext,100)})
 +
 +to get the SIP account (peer) from a given extension (100) via SQL.
  
 Detailed Mass Deployment documentation can be found here: Detailed Mass Deployment documentation can be found here:
 **[[userdoc:tt_ip_phone_provisioning|IP Phone Mass Deployment]]** **[[userdoc:tt_ip_phone_provisioning|IP Phone Mass Deployment]]**
- 
  
 ===== CDR Call Logging with SQL ===== ===== CDR Call Logging with SQL =====
  • userdoc/tt_asterisk-odbc.txt
  • Last modified: 2014/07/03 14:02
  • by droemel