CUCM Query for Phone Models

[joeharb]

I am trying to get an inventory device types from CUCM, but not having a lot of luck with the sql queries.  I have looked at RTMT but it doesn't appear to be a way to export.

I have found multiple sites that have examples but all give a syntax error.

Any assistance would be appreciated.

Joe

[wasosa]

You can also get this kind of information via the web interface. Go to Device and choose the option “Device Type” to search for a particular phone model 

[Mohammadreza Hadi]

on Web interface, you can go to 
>> Bulk Administration >> Phones >> Export Phones >> and get report based on Specific or All details
>> then open text file in Excel with Delimited with Comma..

also, see this post, maybe help >>

https://community.cisco.com/t5/collaboration-knowledge-base/getting-a-report-of-cucm-devices-with-ip-mac-firmware-version/ta-p/3995302

[Alexis Amaro · Accepted solution]

If you just want to see what is configured in the DB, you can use:
run sql select d.name as device, description, m.name as model from device d inner join typemodel m on d.tkmodel = m.enum where m.tkclass = 1 order by model.

[Nithin Eluvathingal]

The Device Count Report From the CUCM reporting page will provide an inventory of phone models configured with their counts.