In case this helps anyone here are some SQL queries that I made (don't judge too hard I'm no DBA). The first alert is helpful for say when a remote device you are polling via snmp has its community string changed, or the snmp service is having an issue. The second alert for volumes is when the snmp service and string are still working but the settings on what can be polled on the remote device have changed.
To alert when a node being polled by SNMP no longer responds:
Under Trigger Condition select-
I want to alert on: Custom SQL Alert
Set up your SQL condition: Node
WHERE (
Nodes.Status = '1' AND
((DATEDIFF(ss, Nodes.LastSystemUpTimePollUtc, getUTCdate())) > 480) AND
Nodes.ObjectSubType <> 'ICMP'
)
To alert when a volume being polled by SNMP no longer responds:
Under Trigger Condition select-
I want to alert on: Custom SQL Alert
Set up your SQL condition: Volume
WHERE (
((DATEDIFF(ss, Volumes.NextPoll, getUTCdate())) > 480) AND
Volumes.Status <> '9'
)
