One of my customers who is targeting a migration to 12.5 is running a number of legacy phone and VC models that will fall in the unsupported bucket.  As part of our upgrade planning, we wanted to ringfence these numbers ahead of the planned migration later this year.

The deprecated and supported phone lists are included in the 12.5 compatibility matrix.  The following two queries helped me extract the necessary data for deprecated and unsupported device models and phone counts.

Deprecated Phone Models

select count(*), typemodel.name as phonemodel from device inner \
join typemodel on typemodel.enum=device.tkmodel \
where typemodel.name in \
( \
'Cisco 7970', \
'Cisco 7971', \
'Cisco 7921', \
'Cisco 12 SP+', \
'Cisco 12 SP', \
'Cisco 12 S', \
'Cisco 30 VIP', \
'Cisco 30 SP+', \
'Cisco 7902', \
'Cisco 7905', \
'Cisco 7910', \
'Cisco 7912', \
'Cisco 7920' \
) \
group by typemodel.name \
order by typemodel.name

Unsupported Phone Models

This query is a lot longer and lists all phone models/counts by excluding system devices, supported models and deprecated models.

select count(*), typemodel.name as phonemodel from device \
inner join typemodel on typemodel.enum=device.tkmodel \
where typemodel.name not in \
( \
'Cisco 3905', \
'Cisco 6901', \
'Cisco 7841', \
'Cisco 7811', \
'Cisco 7821', \
'Cisco 7841', \
'Cisco 7861', \
'Cisco 7832', \
'7915 12-Button Line Expansion Module', \
'7915 24-Button Line Expansion Module', \
'7916 12-Button Line Expansion Module', \
'7916 24-Button Line Expansion Module', \
'Cisco 7942', \
'Cisco 7962', \
'Cisco 7945', \
'Cisco 7965', \
'Cisco 8811', \
'Cisco 8821', \
'Cisco 8841', \
'Cisco 8851', \
'Cisco 8851NR', \
'Cisco 8861', \
'Cisco 8831', \
'Cisco 8845', \
'Cisco 8865', \
'Cisco 8865NR', \
'Cisco 8832', \
'Cisco 8945', \
'Cisco 8961', \
'Cisco 9951', \
'Cisco 9971', \
'Cisco Dual Mode for Android', \
'Cisco Dual Mode for iPhone', \
'Cisco Jabber for Tablet', \
'Cisco Jabber for Mac', \
'Cisco Unified Client Services Framework', \
'Cisco IP Communicator', \
'Cisco ATA 190', \
'Cisco ATA 191', \
'Cisco DX650', \
'Cisco DX70', \
'Cisco DX80', \
'Cisco TelePresence IX5000', \
'Cisco TelePresence EX60', \
'Cisco TelePresence EX90', \
'Cisco TelePresence MX200 G2', \
'Cisco TelePresence MX300 G2', \
'Cisco TelePresence MX700', \
'Cisco TelePresence MX800', \
'Cisco TelePresence MX800 Dual', \
'Cisco TelePresence SX10', \
'Cisco TelePresence SX20', \
'Cisco TelePresence SX80', \
'Cisco Webex DX80' \
) \
and typemodel.name not in \
( \
'Analog Phone', \
'Cisco VGC Phone', \
'Cisco IOS Conference Bridge (HDV2)', \
'MGCP Trunk', \
'CTI Port', \
'Conference Bridge', \
'Media Termination Point', \
'Interactive Voice Response', \
'Cisco IOS Media Termination Point (HDV2)', \
'Third-party SIP Device (Advanced)', \
'Tone Announcement Player', \
'SIP Trunk', \
'Universal Device Template', \
'Voice Mail Port', \
'MGCP Station', \
'Music On Hold', \
'CTI Route Point', \
'Remote Destination Profile', \
'Cisco IOS Software Media Termination Point (HDV2)', \
'SCCP gateway virtual phone', \
'Route List', \
'Cisco TelePresence Conductor', \
'Gatekeeper' \
) \
and typemodel.name not in \
( \
'Cisco 7970', \
'Cisco 7971', \
'Cisco 7921', \
'Cisco 12 SP+', \
'Cisco 12 SP', \
'Cisco 12 S', \
'Cisco 30 VIP', \
'Cisco 30 SP+', \
'Cisco 7902', \
'Cisco 7905', \
'Cisco 7910', \
'Cisco 7912', \
'Cisco 7920' \
) \
group by typemodel.name \
order by typemodel.name

There are clearly still outliers not catered for in the “system devices” exclusionary set – adjust as necessary for your environment.