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
