UCM - Find Phone Type via CLI SQL statement

To find the phone type that is supported on UCM, one of the way is to run the following SQL statement on UCM CLI:

run sql select * from typemodel where name like '%7975%'



For newer phones that are not found in the UCM database, QED definition file is required to install in order to show up in UCM