05-27-2020 07:44 PM
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?
Solved! Go to Solution.
05-28-2020 09:42 AM
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
05-28-2020 09:42 AM
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
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide