Getting Ip address of phone from an extension number using a sql query

[mattswainston]

Hi All,

Trying to do some tapi stuff and would like to know a way of accessing the phones IP if I know its domain and extension number.

lots of tables that look like they might do it: v_extension and v_devices, but can't work out a way of linking extension to ip in a join....

TIA

 

[ad5ou]

That info isn’t stored in the Fusionpbx database. The registration IP is in Freeswitch database and LAN IP isn’t always consistent.
The registration status page source might help show how to extract the info you want.