Is this stored somewhere in the SQL DB I can query?
It's inventory time and I was hoping to run a quick report to get all my Cisco Serial numbers.
I don't believe they are in there by default. You'll need to use a UnDP to poll for the serial numbers. I have two UnDPs that I use to gather model type and serial numbers for Cisco gear. Unfortunately, these OIDs don't always return a value. They work for most of our devices though.
OID - 1.3.6.1.4.1.9.3.6.3
Name - chassisID
Description - Unique ID string. Defaults to chassis serial number if available , otherwise empty. Can also be set with 'snmp-server chassis-id'.
OID - 1.3.6.1.4.1.9.3.6.1
Name - chassisType
Description - chassisType
You'll need to create a report that reports the values of the UnDPs. There used to be an inventory report with serial numbers in the content exchange zone. It's a custom SQL report, so you'll have to tweak it for your environment. I think this is it:
Hope this helps!
Thank you the first OID got all my Serial numbers!
(Except ASA's, AP's, and WLC's, but I can deal with that, the routers outnumber them all)
Now I am just trying to get it in a report.
I have looked at the following thread:
However, not all my reports let me add the Custom Pollers.
I got it, Thanks!!
Glad you got it working. If you need them, you can use the following OID to grab the serial numbers from your ASAs:
1.3.6.1.2.1.47.1.1.1.1.11
CiscoASAserialNumbersALL
The vendor-specific serial number string for the physical entity. The preferred value is the serial number string actually printed on the component itself (if present). On the first instantiation of an physical entity , the value of entPhysicalSerialNum associated with that entity is set to the correct vendor-assigned serial number , if this information is available to the agent. If a serial number is unknown or non-existent , the entPhysicalSerialNum will be set to a zero-length string instead.
Excellent thank you!
How do you correlate the OID to what it really is? MIB Walk or is it in Cisco documentation?
