Integrating Cisco CUCM with Asset Management – Retrieving Cisco IP Phone Serial Number

ImaduddinM
Tera Contributor
Hello ServiceNow Community,

I am currently working on an integration between Cisco Unified Communications Manager (CUCM) and ServiceNow CMDB / Asset Management to automatically synchronize Cisco IP Phone inventory information.


Current Integration:

Using ServiceNow SOAP Messages and the Cisco AXL API, we have successfully integrated ServiceNow with CUCM and can retrieve the following information:
  • Cisco Phone Device Name
  • MAC Address
  • Phone Model
  • Device Pool
  • Description
  • Assigned User / Owner
The data is being used to create and update Configuration Items (CIs) and Asset records within ServiceNow.


Main Challenge: Retrieving Physical Serial Number

The primary challenge is obtaining the actual hardware serial number of Cisco IP Phones.
I have evaluated several Cisco interfaces:

AXL API

  • Successfully retrieves device configuration data.
  • Returns MAC address and device details.
  • Unable to identify a supported field that provides the physical phone serial number.

RISPort70 API

  • Provides IP Address, Registration Status, Model Information, and Firmware Details.
  • Does not appear to return the physical hardware serial number.

CUCM Database Queries (executeSQLQuery via AXL)

  • Tested multiple queries against CUCM tables.
  • Unable to locate a field containing the physical serial number.

ServiceNow Objective

My goal is to automatically populate and maintain the following CI / Asset attributes:
ServiceNow Field Source
NameCisco Device Name
Serial NumberCisco Phone Serial Number
IP AddressCUCM
MAC AddressCUCM
ModelCUCM
ManufacturerCisco
LocationPhysical Location
Assigned ToUser Association

Questions

  1. Has anyone successfully integrated Cisco CUCM with ServiceNow CMDB or Asset Management and automatically populated the serial number field for Cisco IP Phones?
  2. If serial numbers are not available through AXL or RISPort70, what approach did you use?
    • ServiceNow Discovery
    • MID Server
    • Cisco Prime Infrastructure
    • Cisco DNA Center
    • SNMP Queries
    • Custom Integration
  3. Are there any recommended ServiceNow patterns, Discovery solutions, or CMDB best practices for collecting Cisco IP Phone hardware inventory data, including serial numbers?
  4. For organizations managing large numbers of IP Phones, what is the preferred source of truth for hardware attributes such as:
    • Serial Number
    • Model
    • Location
    • Assigned User
Any implementation guidance, architectural recommendations, or examples would be greatly appreciated.

Thank you for your support.
0 REPLIES 0