Does anyone know how to find a device in CM by SN?
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.
SET xmlhttp = Createobject("MSXML2.serverXMLHttp")
SET vxmldocrep = Createobject("MSXML2.serverXMLHttp")
'if server needs authentication us below instead
vxmldocrep.SetRequestHeader "Content-Type", "text/xml"
ldocrep.async = FALSE
lDocrep.resolveExternals = FALSE
SET rvalrep= ldocrep.documentElement.getElementsByTagName("Device")
FOR EACH tool IN rvalrep
SET xmlhttp2 = Createobject("MSXML2.serverXMLHttp")
surl="http://"; & vceid & "/DeviceInformationX"
SET vxmldocrep2 = Createobject("MSXML2.serverXMLHttp")
vxmldocrep2.SetRequestHeader "Content-Type", "text/xml"
ldocrep2.async = FALSE
lDocrep2.resolveExternals = FALSE
SET rvalrep2= ldocrep2.selectSingleNode("//serialNumber")
'end get serial
Check the Dev forum I think someone already post a tool or there is one which generate reports.
Thanks for the fast response. I already knew how to look up the device and find the serial number but I needed to know if I was missing a way to search by the SN. HAGD