Request for suggestion on Report to include switch stack device.

Hi Team,

I am creating a report on all onboarded nodes as per the organization’s requirements. The report needs to include the following details: Machine Name/Caption, Machine Type, Vendor Name, IP Address, Model Number, and Service Tag/Serial Number.

I have created a report based on these requirements, as shown below. However, I am facing an issue where the report does not display the service tag and other details for all switch stack devices. It only shows these details for one device in the stack.

  

In the switch stack, two Cisco devices are visible (as shown in the attached snapshot), but the report includes only one of them, as seen in the report snapshot.

Kindly assist in resolving this issue. For other vendor like Aruba & Juniper, As these two vendors are not supported so not possible to get the switch stack details.

Parents
  • I hope below SWQL Query will help to get the required data for all switchstack members in the orion 

    SELECT onsm.Displayname
    , DataRingRedundant as DataRing_Active
    , StatusDescription
    , ONS.Nodes.IP_Address
    , DataRingStatusDescription as DataRing_Status
    , PowerRingStatusDescription as PowerRing_Status
    , RingFailure
    ,onsm.serialnumber as serialnumber
    , Membercount as Switch_Count
    , ONS.Nodes.DetailsURL as _linkFor_DisplayName
    FROM Orion.NPM.Switchstack ONS
    left join orion.npm.switchstackmember as onsm on onsm.nodeid = ons.nodeid
    ORDER BY RingFailure, PowerRingStatusDescription DESC

Reply
  • I hope below SWQL Query will help to get the required data for all switchstack members in the orion 

    SELECT onsm.Displayname
    , DataRingRedundant as DataRing_Active
    , StatusDescription
    , ONS.Nodes.IP_Address
    , DataRingStatusDescription as DataRing_Status
    , PowerRingStatusDescription as PowerRing_Status
    , RingFailure
    ,onsm.serialnumber as serialnumber
    , Membercount as Switch_Count
    , ONS.Nodes.DetailsURL as _linkFor_DisplayName
    FROM Orion.NPM.Switchstack ONS
    left join orion.npm.switchstackmember as onsm on onsm.nodeid = ons.nodeid
    ORDER BY RingFailure, PowerRingStatusDescription DESC

Children
No Data