This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Serial numbers for Cisco switches / Stack Switches

I am trying to pull serial numbers for stack switches and other devices using on Solarwinds 2020.2.6

SELECT OrionNodes.Caption, OrionNodes.DetailsUrl, OrionNodes.Status, OrionNodes.ChildStatus, NcmEntityPhysical.EntityName, OrionNodes.IP_Address, OrionNodes.CustomProperties.ZL_Location, OrionNodes.CustomProperties.ZL_Region, OrionNodes.CustomProperties.ZN_Role,
OrionNodes.CustomProperties.ZN_Edge_Device, NcmEntityPhysical.EntityDescription, NcmEntityPhysical.Serial, NcmEntityPhysical.Manufacturer, NcmEntityPhysical.Model, NcmNodeProperties.NodeComments, OrionNodes.SysName, OrionNodes.NodeDescription, OrionNodes.Location, OrionNodes.Contact, OrionNodes.MachineType, OrionNodes.LastBoot, OrionNodes.IOSVersion
FROM NCM.NodeProperties AS NcmNodeProperties
INNER JOIN Orion.Nodes AS OrionNodes ON NcmNodeProperties.CoreNodeID=OrionNodes.NodeID
LEFT JOIN NCM.EntityPhysical AS NcmEntityPhysical ON NcmEntityPhysical.NodeID=NcmNodeProperties.NodeID AND NcmEntityPhysical.EntityClass='3'
WHERE (OrionNodes.Vendor='Cisco'

but i dont get any serial numbers or manufacturer or model numbers (NcmEntityPhysical.Serial, NcmEntityPhysical.Manufacturer, NcmEntityPhysical.Model)  - These 3 are not working

it used to work on 2020.2.5 - is there anything wrong in above syntax?

Parents Reply Children
No Data