CUCM database

Version 1
    This document was generated from CDN thread

    Created by: Prem Yadav on 09-12-2009 06:56:37 AM
    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

    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="" xmlns:ns="">
          <ns:executeSQLUpdate sequence="1">
             <sql>update device set name='SEP00070EB9C4B4' where name='SEP837363738373'</sql>

    <SOAP-ENV:Envelope SOAP-ENV:encodingStyle="" xmlns:SOAP-ENV="">
          <axl:executeSQLUpdateResponse sequence="1" xmlns:axl="" xmlns:xsi="">