Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
userdoc:tt_asterisk-odbc [2014/07/03 13:41] abelbeck [Mass Deployment SQL Table] |
userdoc:tt_asterisk-odbc [2014/07/03 14:02] (current) droemel [Mass Deployment SQL Table] |
||
---|---|---|---|
Line 121: | Line 121: | ||
); | ); | ||
- | Following the examples above, adding a context to ''/ | + | Following the examples above, adding a context to ''/ |
+ | |||
+ | [SIPACCOUNT] | ||
+ | dsn=asterisk | ||
+ | readsql=SELECT ${ARG1} FROM phoneprov WHERE ${ARG2}=' | ||
+ | |||
+ | In the dialplan you could then use something like this: | ||
+ | |||
+ | same => n, | ||
+ | |||
+ | to get the SIP account (peer-name) from a given extension (100) via SQL. | ||
Detailed Mass Deployment documentation can be found here: | Detailed Mass Deployment documentation can be found here: | ||
**[[userdoc: | **[[userdoc: | ||
- | |||
===== CDR Call Logging with SQL ===== | ===== CDR Call Logging with SQL ===== |