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="" xmlns:ns="">
          <ns:executeSQLQuery sequence="1">
             <sql>select enum,name from typemodel</sql>