Hello all,
I would like to create an alert on devices where the polling method is set with "SNMP and ICMP" and where the resource item "CPU & Memory" is not selected.
A started with the trigger action "Custom SQL alert (Advanced)" and using the query:
SELECT N.[NodeID]
FROM [SolarWindsOrion2].[dbo].[Nodes] AS N
WHERE
N.UnManaged = 0 AND
N.Status = 1 AND
N.ObjectSubType <> 'ICMP' AND
( N.CPULoad = '-2' AND N.MemoryUsed = '-2' )
I am not 100% sure of this is the correct way to trigger an alert.
Strange enough some devices don't have the "CPU & Memory" option under the resource list.