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.

  • Check if the 2nd device is being monitored.

  • Hi,

    It seems like the issue may be related to the way the switch stack data is being pulled for Cisco devices. For accurate reporting, you may want to ensure that your system or report generator is able to fetch information from all stack members, not just the first device. If the stack is being detected as a single unit, try verifying the configuration or query settings to ensure each individual device in the stack is identified and its details are being fetched.

    Regarding Aruba and Juniper, since they are not supported, you may want to explore other compatible options or methods for gathering data from those devices.

    Feel free to reach out if you'd like more assistance with resolving the issue. Visit us for additional support!

  • 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