0 Replies Latest reply on Oct 4, 2012 3:41 PM by mwjohnson

    Interface alerts on a Group of Nodes?

    mwjohnson

      All,

       

      Running NPM version 10.3

       

      I'm trying to build an Interface alert that will only trigger when an Interfaces go down for a Group of Nodes called Stores.  I found the following SQL statement in an ealier post, but I receive an error when I attemp to use it.  Any thoughts?

       

      inner join Nodes on Interfaces.NodeID = Nodes.nodeID

      where (interfaces.Status = 2) AND (

        Nodes.Caption in (Select ContainerMemberSnapshots.Name

          from ContainerMemberSnapshots

            inner join Containers on

               Containers.ContainerID = ContainerMemberSnapshots.ContainerID

        where Containers.Name = 'XXX Stores')

       

      Here is the error I receive:

       

      SQL Error:

       

      -2147217900 - The objects "Nodes" and "Nodes" in the FROM clause have the same exposed names.  Use correlation names to distinguish them.

       

      I'm not fluent in SQL, but I can copy, paste, and edit with the best of them.  I sure could use some help.

       

      Thanks,

      Mike