compile alist of telephone number and ip-phone mac address

[Mary]

can we compile a ist of cisco ip-phone number ,  ip-phone mac address, ip-phone IP address easily? now our company is distributed into three buildings and different floor, it will be troublesoom to collect all the details. is there any command we can run?

[Deepak Rawat]

http://www.cisco.com/c/en/us/support/docs/unified-communications/unified-communications-manager-callmanager/117726-technote-cucm-00.html

Also, take a look at the below guide for various options that BAT tool provides for this purpose

http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/bat/10_0_1/CUCM_BK_CDB9A6A4_00_cucm-bulk-administration-guide-100/CUCM_BK_CDB9A6A4_00_cucm-bulk-administration-guide-100_chapter_01100.html

Regards

Deepak

[Deepak Rawat]

Adding to my previous reply, you can also run show risdb query phone that gives the IP address details and then you can probably play in Excel to merge it with the output you get by running below command that give you the MACAddress details along with the DN to get the final report with all the required three fields:

run sql select d.name, d.description, n.dnorpattern as DN from device as d,numplan as n, devicenumplanmap as dnpm where dnpm.fkdevice = d.pkid and dnpm.fknumplan = n.pkid and d.tkclass = 1

Regards

Deepak