CUCM database

[cdnadmin]

This document was generated from CDN thread

Created by: Prem Yadav on 09-12-2009 06:56:37 AM
Hi,
I need to know the name of the database that stores the mac addres of the ip phone.
How can I update a new IP phone with already reggistered DN? and remove the old IP phone.
we don't want to use the addphone- to add the new phone
we need to add the new phone in place of an old phone and have the previous DN as well.

CUCM version:6.1
Thanks

Subject: RE: CUCM database
Replied by: David Staudt on 09-12-2009 04:51:51 PM
The 'device' table stores the list of devices and their names (i.e. 'SEPxxxxxxxxxxxx').  You can use executeSQLUpdate to modify the name for a record in place.  I think this should work ok if the phone types/models are identical, not sure what can happen if you change phone models, though; the safest mechanism will be to use getPhone/addPhone/removePhone.
 

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/7.0">
   <soapenv:Header/>
   <soapenv:Body>
      <ns:executeSQLUpdate sequence="1">
         <sql>update device set name='SEP00070EB9C4B4' where name='SEP837363738373'</sql>
      </ns:executeSQLUpdate>
   </soapenv:Body>
</soapenv:Envelope>
--------------------

<SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
   <SOAP-ENV:Header/>
   <SOAP-ENV:Body>
      <axl:executeSQLUpdateResponse sequence="1" xmlns:axl="http://www.cisco.com/AXL/API/7.0" xmlns:xsi="http://www.cisco.com/AXL/API/7.0">
         <return>
            <rowsUpdated>1</rowsUpdated>
         </return>
      </axl:executeSQLUpdateResponse>
   </SOAP-ENV:Body>
</SOAP-ENV:Envelope>