Export to PDF

NPM Summary

Help

Manage Nodes

All Nodes managed by NPM

Grouped by Vendor, Status

Widget is hidden on dashboard,
there is no data to show now.

Help

All Wireless Heat Maps

Widget is hidden on dashboard,
there is no data to show now.

List of all VLANs

Widget is hidden on dashboard,
there is no data to show now.

Help

VLAN Overview

Widget is hidden on dashboard,
there is no data to show now.

List of all VRFs

Widget is hidden on dashboard,
there is no data to show now.

MPLS Network

Widget is hidden on dashboard,
there is no data to show now.

Intelligent Map

Widget is hidden on dashboard,
there is no data to show now.

List of Switch Stacks

SELECT
                    SwitchStack.Nodes.Caption,
                    SwitchStack.NodeID AS _NodeID,
                    SwitchStack.Nodes.IPAddress,
                    SwitchStackMember.MacAddress,
                    MemberCount,

-- Status
                    SwitchStack.Status,
                    si.IconPostfix AS _Status,
                    StatusDescription AS _StatusDescription,

-- DataRingStatus
                    SwitchStack.DataRingStatus,
                    drsi.IconPostfix AS _DataRingStatusIcon,
                    drsi.ShortDescription AS _DataRingStatusDescription,

-- PowerRingStatus
                    SwitchStack.PowerRingStatus,
                    prsi.IconPostfix AS _PowerRingStatusIcon,
                    prsi.ShortDescription AS _PowerRingStatusDescription
                FROM
	                Orion.NPM.SwitchStack (nolock=true)
                LEFT JOIN
	                Orion.NPM.SwitchStackMember (nolock=true) ON SwitchStack.MasterNumber = SwitchStackMember.SwitchNumber AND SwitchStack.NodeID = SwitchStackMember.NodeID
                LEFT JOIN
	                Orion.StatusInfo (nolock=true) si ON SwitchStack.Status = si.StatusId
                LEFT JOIN
	                Orion.StatusInfo (nolock=true) drsi ON SwitchStack.DataRingStatus = drsi.StatusId
                LEFT JOIN
	                Orion.StatusInfo (nolock=true) prsi ON SwitchStack.PowerRingStatus = prsi.StatusId
                JOIN
                    Orion.Pollers (nolock=true) p ON SwitchStack.NodeID = p.NetObjectID
                        AND p.NetObjectType = 'N'
                        AND p.PollerType LIKE 'N.SwitchStack.SNMP.%'
                        AND p.Enabled = 'True'
                WHERE
                    SwitchStack.Nodes.Caption IS NOT NULL

Widget is hidden on dashboard,
there is no data to show now.