In the process of some of what I do, I realized I didn't see any sort of report (or widget) that specifically tries to identify switch stack problems. This widget should generally highlight power or data ring issues in general. Hopefully this helps some folks out.
Query:
SELECT TOP 1000 Displayname
, DataRingRedundant as DataRing_Active
, StatusDescription
, ONS.Nodes.IP_Address
, DataRingStatusDescription as DataRing_Status
, PowerRingStatusDescription as PowerRing_Status
, RingFailure
, Membercount as Switch_Count
, ONS.Nodes.DetailsURL as _linkFor_DisplayName
FROM Orion.NPM.Switchstack ONS
WHERE DataRingRedundant = 'False' OR PowerRingStatusDescription != 'Up'
ORDER BY RingFailure, PowerRingStatusDescription DESC
fixed typos