Is there any way to show all the ip phone that registered in cucm 7 with serial number, i can check the mac address with find that start with SEPXXXXXX, but i couldn't see the serial number for that ip phone, i have to click into that ip phone and check the serial number one by one?
Yes there is, download the software Serial Grabbler:
You need the Net Framework 3.0 on XP.
After installed you will put the ip address range of the ip phones network and he will collect the serial number of the phones and other informations:
The ouput file is an html file and you can copy to word or excel
|IP Address||Phone DN||Serial No||MAC Address||Model No|
Rate this if is useful to you
So, it looks like the serial number of the phones is not stored in the CUCM database, and you have to go to the phone to get it. That means it's not available if the phone is off, and much more difficult if the phone is not registered (and is not displaying an IP in CUCM.)
I suspect this also means the phone's web server must be 'on' for it to reply.
... still researching ...
No, because CUCM doesn't care about the phone's SN and that information is nowhere in CUCM, most tools would just use CUCM to get the info of what phones were configured/registered, and then query the phones directly to get the SN