CCM 7.x - get list of phone models

Version 1
    This document was generated from CDN thread

    Created by: JEAN-FRANCOIS GUAY on 06-08-2009 02:43:05 PM
    Where can I find the model to device type mapping for CCM 7.x?  I have seen in the forums that CCM 4.x had something you could query and get that list, i.e 303 = 7942 but haven't found something yet for 7.x
     
    For now I am querying the phone to get the model but I know CCM provides the model number when I request phone info and that is a better place to get it - especially useful for unregistered phones.
     
     

    Subject: RE: CCM 7.x - get list of phone models
    Replied by: David Staudt on 06-08-2009 06:06:22 PM
    The list of models recognized by the system is in the 'typemodel' table.  It is a good idea to check this table, as additions can occur if new 'device packs' are installed on the system. 
     
    You can access the table via AXL <executeSQLQuery>, for example:
     
    <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:executeSQLQuery sequence="1">
             <sql>select enum,name from typemodel</sql>
          </ns:executeSQLQuery>
       </soapenv:Body>
    </soapenv:Envelope>