topic Re: Which table of CUCM DB store the IP address of IP Phones？ in Management

Which table of CUCM DB store the IP address of IP Phones？

yuexp0929 — Thu, 28 May 2020 02:44:03 GMT

Hello All

I'd like to run SQL query to get the IP address of IP Phone like this, but "lastknownipaddress" is empty.

select d.name, d.description, rd.datetimestamp,rd.lastknownipaddress from device as d left join registrationdynamic as rd on rd.fkdevice = d.pkid where d.name like "SEP%"

Do you know which table of CUCM DB store the IP address of IP Phones？

Re: Which table of CUCM DB store the IP address of IP Phones？

dstaudt — Thu, 28 May 2020 16:42:05 GMT

For CUCM versions 12.5SU2+, see the `registrationdynamic` table.

For versions prior to that, IP/registration state are not stored in the database; you will need to explore the Serviceability Risport SOAP API for this info: https://developer.cisco.com/docs/sxml/#!risport70-api-reference