FYI: NPM Alert that triggers when an SAM template is NOT assigned to a node

cgregors

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

  objectsubtype='SNMP' and

  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.