I use the following in func_odbc.conf [FINDEXTN] dsn=asterisk readsql=SELECT ${ARG1} FROM extension_map as em left join sip_devices as sd on s d.id = em.name_id WHERE em.extension ='${ARG2}' and name_id IS NOT NULL
this is for our own extension_map table which is part of our mapping to our Avaya users. A simple one would be [FINDEXTN] dsn=asterisk readsql=SELECT ${ARG1} FROM sip_devices as sd WHERE sd.name ='${ARG2}' This allows pulling any field from sip_devices which is our realtime sip table. You could pull some of the other data you are looking for. Cheers Stephen -- _____________________________________________________________________ -- 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 -- _____________________________________________________________________ -- 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