Call manager and type of Voip phones

[Mark Bench]

Just wanted to thank everyone for the help.

My background is Telepresence and minimal on Call Manager 8.

Just wanted to ask if I can somehow pull a list of all type of phones connected to the call manager - we currently have 7942 and 7975. I need the list which phone number is using which type of phone.

[Stephen Welsh]

Hi Mark,

Here are 3 suggestions:

1) Goto Device > Phone, add the 'Directory Number' and 'Device Type' as search criteria and click 'Find'. This is limited as it can't be exported.

2) Run the following SQL Query:

SELECT d.name, n.dnorpattern, dn.numplanindex, m.name as Model FROM numplan AS n JOIN devicenumplanmap AS dn ON n.pkid=dn.fknumplan JOIN device AS d ON d.pkid=dn.fkdevice JOIN typemodel AS m ON d.tkmodel=m.enum JOIN typeclass AS c ON d.tkclass=c.enum WHERE c.name="Phone" ORDER BY m.name, d.name, dn.numplanindex

3) Use a 3rd Party product to extract and export the required data such as PhoneView from UnifiedFX

PhoneView is the most advanced endpoint management product available including the ability to gather extensive device/user information and then interact and export that data.

Thanks

Stephen Welsh

CTO

http://www.unifiedfx.com

[Rob Huffman]

Hi Mark,

In addition to the great info from Stephen (+5 )

A simple way to get this info from CUCM is to go to;

Device> Phone> Find phone where Directory number begins with (enter the first

digits of your phones)> Find

This will populate a list of DN's, in numerical order, along with the phone

model for each.

Cheers!

Rob

"go easy...step lightly...stay free " 

- The Clash