Script for Cisco devices Serial numbers

swf.nfs

Hi,

I have created a report which is showing the chassis ID or serial number of cisco devices but that report is either showing serviceTags or chassis IDs.

But this report is not showing serial numbers\chassis IDs of all cisco devices.

can we create a script to extract all cisco devices serial numbers\Chassis IDs including all virtual cisco devices as well?

yaquaholic

HI swf.nfs,

I think the NCM.EntityPhysical table has this data in it.
This SWQL isn't perfect but it should get you started:

SELECT TOP 1000
EP.Node.NodeCaption,
EntityID,
EntityName,
EntityDescription,
HardwareRevision,
FirmwareRevision,
SoftwareRevision,
Serial,
Manufacturer,
Model

FROM NCM.EntityPhysical AS EP
WHERE 'Cisco' IN EP.Manufacturer