Device Info

[agup]

How can we get the following info from CallManager 4.1.3 using an SQL query or some other tool:

IP Phone Model

Device Name

Description

DN

Display or Alerting Name

[bwilmoth]

To query the phone type, you can go to:

Enterprise Manager > SQL Group > Local > DB > (select the cm) > Table > Right click 'Device' > Open Table > Return all rows

tkmodel column will tell you the model.

8 = 7940

7 = 7960

6 = 7910

[Jaime Valencia]

the numplan table contains several of the items you're asking for. device also has some of them

javalenc