Configured device report

Unanswered Question
Mar 3rd, 2008


I'm using CCM 4.1 SR4.

I need to prepare a report detailing list of all configured devices (IP Phones) with their MAC Address, Description and Line id(extension).

Also, we have extension mobility for some of users.

I tried from CCM database table name 'Device', I could see MAC address and Description but Extension assigned to that phones are not in that table.

Could you pls assist me in finding this report.


S Nair.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 3 (1 ratings)
kailencbi Mon, 03/03/2008 - 09:53

The fastest way to get a complete list of phones with macs and extensions is by using the realtime monitoring tool and going under Device->DeviceSearch and then you can perform a search based on the criteria you specify. Unfortunately this does not provide a printable report. There is a 3rd party tool at CMRreports that will do this but it is fairly expensive.

Otherwise you will need a SQL report that links the Device table to the NumPlan Table.

Another option would be to poll the phones themselves via a pearl script. Reading the phones HTML into a file and then parsing the data.

Unfortunately there is no pretty way to do this in 4.1

Good Luck

mdury Mon, 03/10/2008 - 07:02

Hi, I did a google search on CMRreports and did not find anything. Can you elaborate on this software? thanks

Adrian Saavedra Mon, 03/10/2008 - 07:35


What about using Bulk Administration Tool?

You can export all details of the phones (MAC address, description, line fields, etc).


-- adrián

somannairv Mon, 03/10/2008 - 23:24

Dear All,

I used generate report tool to get Phone and Users report using BAT. This covered all configured devices for corresponding cluster. Best part is that, its free.

Thank you all for their response.


Soman Nair.


This Discussion