We have a number of standard SAM templates that need to be assigned to nodes that are SNMP compliant.
If a node is added via discovery, we sometimes forget to assign the template. Thus the following alert:
Here's the SQL:
SELECT Nodes.NodeID AS NetObjectID, Nodes.Caption AS Name
FROM Nodes /*SplitMarker*/where
nodeid not in (select nodeid from APM_Application where name='SNMP availability')
For a trigger action, we use an email reminder to our monitoring team.