CUCM database

Version 1
    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>