• State Suggested Answer
  • Locked Locked
  • Replies 6 replies
  • Answers 1 answer
  • Subscribers 60 subscribers
  • Views 3586 views
  • Users 0 members are here
Options
Related
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

CiscoExpert

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
  • 0

      

    I hope u are well.

    I read your comments.

    I have customized the following query in SWQL, I hope it helps you in something.

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

    SELECT
    H.ParentObjectName AS HostName,
    N.IP_Address AS IP,
    N.SysObjectID,
    H.Manufacturer,
    H.Model,
    H.ParentObjectVendor AS Vendor,
    S.RoleDescription AS Role,
    H.ServiceTag AS ServiceTag_Master, --Service Tag, is the serial number of the Master Switches
    S.SerialNumber AS ServiceTag_Standby_Member --SerialNumber, is the serial number of the Standby/member Switches
    FROM Orion.HardwareHealth.HardwareInfo AS H
    LEFT JOIN Orion.Nodes AS N
    ON H.NodeID=N.NodeID
    LEFT JOIN Orion.NPM.SwitchStackMember AS S
    ON S.NodeID=N.NodeID
    ORDER BY N.IP_Address

Reply
  • 0

      

    I hope u are well.

    I read your comments.

    I have customized the following query in SWQL, I hope it helps you in something.

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

    SELECT
    H.ParentObjectName AS HostName,
    N.IP_Address AS IP,
    N.SysObjectID,
    H.Manufacturer,
    H.Model,
    H.ParentObjectVendor AS Vendor,
    S.RoleDescription AS Role,
    H.ServiceTag AS ServiceTag_Master, --Service Tag, is the serial number of the Master Switches
    S.SerialNumber AS ServiceTag_Standby_Member --SerialNumber, is the serial number of the Standby/member Switches
    FROM Orion.HardwareHealth.HardwareInfo AS H
    LEFT JOIN Orion.Nodes AS N
    ON H.NodeID=N.NodeID
    LEFT JOIN Orion.NPM.SwitchStackMember AS S
    ON S.NodeID=N.NodeID
    ORDER BY N.IP_Address

Children
No Data

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 200,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification SolarWinds Lab Link Accounts
About THWACK Blogs Federal & Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2021 SolarWinds Worldwide, LLC. All Rights Reserved.