Extracting Unsupported and Deprecated Phones Models for UCM 12.5 Migrations

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.

One thought on “Extracting Unsupported and Deprecated Phones Models for UCM 12.5 Migrations

  1. prepare for 14 !

    these are your depreciated phones:

    run sql \
    select count(*), typemodel.name as phonemodel from device inner \
    join typemodel on typemodel.enum=device.tkmodel \
    where typemodel.name in \
    ( \
    ‘Cisco 12 S’, \
    ‘Cisco 12 SP’, \
    ‘Cisco 12 SP+’, \
    ‘Cisco 30 VIP’, \
    ‘Cisco 30 SP+’, \
    ‘Cisco 7902’, \
    ‘Cisco 7905’, \
    ‘Cisco 7910’, \
    ‘Cisco 7912’, \
    ‘Cisco 7920’, \
    ‘Cisco 7935’, \
    ‘Cisco 7970’, \
    ‘Cisco 7971’, \
    ‘Cisco 7921’, \
    ‘Cisco 3911’, \
    ‘Cisco 3951’, \
    ‘Cisco 6911’, \
    ‘Cisco 6921’, \
    ‘Cisco 6941’, \
    ‘Cisco 6945’, \
    ‘Cisco 6961’, \
    ‘Cisco 7906’, \
    ‘Cisco 7911’, \
    ‘Cisco 7925’, \
    ‘Cisco 7926’, \
    ‘Cisco 7931’, \
    ‘Cisco 7936’, \
    ‘Cisco 7937’, \
    ‘Cisco 7940’, \
    ‘Cisco 7941’, \
    ‘Cisco 7960’, \
    ‘Cisco 7961’, \
    ‘Cisco 7985’, \
    ‘Cisco 8941’ \
    ) \
    group by typemodel.name \
    order by typemodel.name

    I was impressed by the numbers I need to find a solution for

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.