A quick report on CPU and Memory thresholds for nodes. This quickly identifies which ones have been customized.
SELECT n.caption, n.CPULoad as [CurrentCPU], ntc.Level1Value as [CPUWarning], ntc.Level2Value as [CPUCritical],
ntc.GlobalWarningValue as [CPUWGlobal], ntc.GlobalCriticalValue as [CPUCGlobal], n.PercentMemoryUsed as [CurrentMEM], ntm.Level1Value as [MEMWarning], ntm.Level2Value as [MEMCritical], ntm.GlobalWarningValue as [MEMWGlobal], ntm.GlobalCriticalValue as [MEMCGLobal]
FROM Orion.Nodes n
left join orion.NodesThresholds ntc on ntc.InstanceId=n.nodeid and ntc.name='Nodes.Stats.CpuLoad'
left join orion.NodesThresholds ntm on ntm.InstanceId=n.nodeid and ntm.name='Nodes.Stats.PercentMemoryUsed'
Thank you,
Amit
