03-03-2008 06:41 AM - edited 03-15-2019 09:11 AM
Hi,
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.
Regards,
S Nair.
03-03-2008 09:53 AM
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
03-10-2008 07:02 AM
Hi, I did a google search on CMRreports and did not find anything. Can you elaborate on this software? thanks
03-10-2008 07:35 AM
Hi,
What about using Bulk Administration Tool?
You can export all details of the phones (MAC address, description, line fields, etc).
Regards,
-- adrián
03-10-2008 07:45 AM
Here is the address for CM Reports. They charge you $60 per cluster CM report.
http://www.cmreports.com/shop/
HTH
03-10-2008 11:24 PM
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.
Regards,
Soman Nair.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide