Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Bronze

Device look up in Call Manager

Does anyone know how to find a device in CM by SN?

2 REPLIES
Green

Re: Device look up in Call Manager

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.

Bronze

Re: Device look up in Call Manager

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

185
Views
14
Helpful
2
Replies
CreatePlease to create content