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

[yuexp0929]

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？

[dstaudt · Accepted solution]

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