Find Deprecated Phones via SQL

Table of Contents

As with every CUCM release, some phones will not be supported anymore. For this example, let us look at how to find a list of phones on CUCM 11.X that are deprecated in release 12.X and newer.

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

Deprecated Phone Models #

The following table lists all the phone models that are deprecated for this release of Unified Communications Manager, along with the Unified CM release where the phone model first became deprecated.

Deprecated Phone Models for this Release	First Deprecated as of Unified CM
Cisco Unified Wireless IP Phone 7921 Cisco Unified IP Phone 7970 Cisco Unified IP Phone 7971	12.0(1) and later releases
Cisco IP Phone 12 S Cisco IP Phone 12 SP Cisco IP Phone 12 SP+ Cisco IP Phone 30 SP+ Cisco IP Phone 30 VIP Cisco Unified IP Phone 7902G Cisco Unified IP Phone 7905G Cisco Unified IP Phone 7910 Cisco Unified IP Phone 7910G Cisco Unified IP Phone 7910+SW Cisco Unified IP Phone 7910G+SW Cisco Unified IP Phone 7912G Cisco Unified Wireless IP Phone 7920 Cisco Unified IP Conference Station 7935	11.5(1) and later releases

Relevant data, attributes, tables #

Tables #


`device`	contains information about the phones
`typemodel`	translates the typemodel integers (enums) to the human-readable phone model names

Attributes #


`typemode.name`

Conditions #


`typemodel.name in ( list of deprecated phones)`

Query #

Use the following query to get the count for each deprecated phone model.

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

Return #

The query will return a table with two columns, one containing the deprecated phone model and the other the count of how many there are in the environment.

run sql 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 

(count(*)) phonemodel 
========== ========== 
7          Cisco 7921 
1          Cisco 7970
...

Unsupported Phone Models #

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

Cisco Endpoints at End of Support
Cisco Unified SIP Phone 3911, 3951
Cisco Unified IP Phone 6911, 6921, 6941, 6945, 6961, 7906G, 7911G, 7931G, 7940G, 7941G, 7960G, 7961G, 8941
Cisco Unified IP Phone Expansion Module 7925G, 7925G-EX, 7926G
Cisco Unified IP Conference Station 7935, 7936, 7937G
Cisco TelePresence EX60
Cisco TelePresence MX200-G1, MX200-G2, MX300-G1, MX300-G2
Cisco TelePresence 500-32, 500-37, 1000 MXP, 1100, 1300-65, 1300-47, 3000 Series