cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
151
Views
0
Helpful
1
Replies
Highlighted
Beginner

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

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?

 

 

           

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Cisco Employee

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

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

View solution in original post

1 REPLY 1
Highlighted
Cisco Employee

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

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

View solution in original post

This widget could not be displayed.