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.

List of all VRFs

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

Recent NPM Posts

Edit Help

View All » Join THWACK »

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
                LEFT JOIN
	                Orion.NPM.SwitchStackMember ON SwitchStack.MasterNumber = SwitchStackMember.SwitchNumber AND SwitchStack.NodeID = SwitchStackMember.NodeID
                LEFT JOIN
	                Orion.StatusInfo si ON SwitchStack.Status = si.StatusId
                LEFT JOIN
	                Orion.StatusInfo drsi ON SwitchStack.DataRingStatus = drsi.StatusId
                LEFT JOIN
	                Orion.StatusInfo prsi ON SwitchStack.PowerRingStatus = prsi.StatusId
                JOIN
                    Orion.Pollers p ON SwitchStack.NodeID = p.NetObjectID
                        AND p.NetObjectType = 'N'
                        AND p.PollerType = 'N.SwitchStack.SNMP.Cisco'
                        AND p.Enabled = 'True'
                WHERE
                    SwitchStack.Nodes.Caption IS NOT NULL

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