Serial Number is not stored anywhere in the CM databse. But we can get this info

dynamically in CM one-by-one for each phone. Goto the Device > Phones page and then

list the IP Phones, then click on the IP Address of the IP Phone and it will open another window. This page will contain both the MAC address and the Serial number of the IP Phone

However I also found that we can do this with a HTTP script, and I found these scripts:

************************

Here is a quick vbscript that pulls the serial number back.

I have it only pulling back the first one ( using wscript.quit to finish

after the first one ) due to the huge amount on our servers.

'start script

SET xmlhttp = Createobject("MSXML2.serverXMLHttp")

surl="http:///CCMAdmin/reports/devicelistx.asp"

SET vxmldocrep = Createobject("MSXML2.serverXMLHttp")

vxmldocrep.open "GET",surl,False

'if server needs authentication us below instead

vxmldocrep.open "GET",surl,False,"",""

vxmldocrep.SetRequestHeader "Content-Type", "text/xml"

vxmldocrep.Send

SET ldocrep=CreateObject("Microsoft.xmldom")

ldocrep.async = FALSE

lDocrep.resolveExternals = FALSE

ldocrep.load (vxmldocrep.responsexml)

SET rvalrep= ldocrep.documentElement.getElementsByTagName("Device")

FOR EACH tool IN rvalrep

vceid= tool.getattribute("i")

MsgBox vceid

'get serial

SET xmlhttp2 = Createobject("MSXML2.serverXMLHttp")

surl="http://"; & vceid & "/DeviceInformationX"

SET vxmldocrep2 = Createobject("MSXML2.serverXMLHttp")

vxmldocrep2.open "GET",surl,False

vxmldocrep2.SetRequestHeader "Content-Type", "text/xml"

vxmldocrep2.Send

SET ldocrep2=CreateObject("Microsoft.xmldom")

ldocrep2.async = FALSE

lDocrep2.resolveExternals = FALSE

ldocrep2.load (vxmldocrep2.responsexml)

SET rvalrep2= ldocrep2.selectSingleNode("//serialNumber")

vserial= rvalrep2.text

'end get serial

MsgBox vserial

wscript.quit

next

'end script

Check the Dev forum I think someone already post a tool or there is one which generate reports.