Get Device Serial Number

[cdnadmin]

This document was generated from CDN thread

Created by: Mayank Sharma on 12-01-2009 03:56:36 PM
Hi again,

Is there a way to access the device information like Serial Numbers? I could not find any table that stores that.

I am using CUCM 6.1.

Thanks,
Max

Subject: Re: Get Device Serial Number
Replied by: EDWARD BROWN on 12-01-2009 04:22:34 PM
As far as I know that is not included in the database at all.
I know there are commercially available tools that do an HTML get from the phone and parse the response to get that type of information.

Subject: Re: Get Device Serial Number
Replied by: Mayank Sharma on 12-01-2009 04:27:02 PM
Thanks a lot for your response.

I wish that information was in the database or somewhere readily accessible .

You mentioned there are some commercial tools available.

I wonder if there are any CISCO APIs that can do that?

Thanks,
Max

Subject: Re: Get Device Serial Number
Replied by: David Staudt on 14-01-2009 02:22:25 AM
If an individual phone's internal web server is enabled (default) you can request

http://ip-phone-address/DeviceInformationX

This will return an XML object with information including the serial number.

Subject: Re: Get Device Serial Number
Replied by: Mayank Sharma on 14-01-2009 02:47:18 PM
Thanks David.
That looks interesting. How do I get all the IP addressess of phones in my network?

Subject: Re: Get Device Serial Number
Replied by: David Staudt on 14-01-2009 07:35:44 PM
Note what you ask can require a lot of database and CPU resources to present on systems with large numbers of phones. Something like this is the usual approach:

Use Admin AXL <listPhoneByName> with <searchString> of % to get all phones in the CUCM cluster:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/1.0">
<soapenv:Header/>
<soapenv:Body>
<ns:listPhoneByName sequence="1">
<searchString>%</searchString>
</ns:listPhoneByName>
</soapenv:Body>
</soapenv:Envelope>

This list may contain phones that do not have a web server to query, so you will want to filter out those devices.

Then use AXL Serviceability <SelectCmDevice> to query for the real time statistics - including registration status and last IP address - of phones by device name. This request can only return 200 devices at a time, and devices can have duplicate entries if they have registered to more than one CUCM node in the past, so you can try requesting 100 at a time:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Body>
<ns1:SelectCmDevice soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:ns1="http://schemas.cisco.com/ast/soap/">
<StateInfo xsi:type="xsd:string"/>
<CmSelectionCriteria href="#id0"/>
</ns1:SelectCmDevice>
<multiRef id="id0" soapenc:root="0"
soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
xsi:type="ns2:CmSelectionCriteria"
xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:ns2="http://schemas.cisco.com/ast/soap/">
<MaxReturnedDevices xsi:type="xsd:unsignedInt">200</MaxReturnedDevices>
<Class xsi:type="xsd:string">Any</Class>
<Model xsi:type="xsd:unsignedInt">255</Model>
<Status xsi:type="xsd:string">Registered</Status>
<NodeName xsi:type="xsd:string" xsi:nil="true"/>
<SelectBy xsi:type="xsd:string">Name</SelectBy>
<SelectItems soapenc:arrayType="ns2:SelectItem[2]" xsi:type="soapenc:Array">
<item href="#id1"/>
</SelectItems>
</multiRef>
<multiRef id="id1" soapenc:root="0"
soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
xsi:type="ns3:SelectItem" xmlns:ns3="http://schemas.cisco.com/ast/soap/"
xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/">
<Item xsi:type="xsd:string">SEP00070EB9C4B4</Item>
</multiRef>
</soapenv:Body>
</soapenv:Envelope>

Subject: Re: Get Device Serial Number
Replied by: Mayank Sharma on 15-01-2009 01:04:22 PM
Thanks so much David. This is exactly what I was looking for. I really appreciate all your help.

Thanks,
Max

[royp1]

@dstaudt Thanks, David, for the detailed solution.

Am I correct to assume the webaccess for device would need to be enabled for the DeviceInformationX to work?

Regards

[dstaudt]

Correct

[jgarner1]

All links here are not working. I need to find a serial number from a known MAC address.

[Guillermo_PY]

As part of a project, I wrote this Python script to retrieve the following information:

• Version
• Serial Number
• Model

If anyone would like to test it, here is the script:

---------------------------------------------------------

import requests
from bs4 import BeautifulSoup
import ipaddress
from datetime import datetime

def recorrer_red(red_str):
"""
Recorre una red dada en notación CIDR (ej: '192.168.1.0/24')
y devuelve una lista con todas las direcciones de host.
"""
red = ipaddress.ip_network(red_str)
return [str(ip) for ip in red.hosts()]

def guardar_log(texto, archivo="registro_de_logs.txt"):
"""
Guarda un texto en un archivo de logs con fecha y hora.
"""
fecha_hora = datetime.now().strftime("%d/%m/%Y %H:%M:%S")
with open(archivo, "a", encoding="utf-8") as file:
file.write(f"[{fecha_hora}] {texto}\n")

# Ejemplo de uso
ips = recorrer_red("192.168.100.32/28")

for ip in ips:
url = f"http://{ip}/"
try:
response = requests.get(url, timeout=2)

if response.status_code == 200:
html = response.text
soup = BeautifulSoup(html, "html.parser")

filas = soup.find_all("tr")

version = None
serial = None
model = None

for fila in filas:
celdas = fila.find_all("td")
if len(celdas) >= 3:
campo = celdas[0].get_text(strip=True)
valor = celdas[2].get_text(strip=True)

if campo == "Version":
version = valor
elif campo == "Serial Number":
serial = valor
elif campo == "Model Number":
model = valor

resultado = f"IP: {ip} | Version: {version} | Serial: {serial} | Model: {model}"
print(resultado)
guardar_log(resultado)

else:
error_msg = f"{url} -> Error HTTP {response.status_code}"
print(error_msg)
guardar_log(error_msg)

except requests.exceptions.RequestException as e:
error_msg = f"{url} -> Error: {e}"
print(error_msg)
guardar_log(error_msg)

---------------------------------------------------------