2 Replies Latest reply on May 3, 2017 9:19 AM by kiza25

    Custom Alert Changes since Version 12

    kiza25

      Hi,

       

      I recently have upgraded from version 11.5.3 NPM to 12.0 NPM, One of the alerts which was built many years ago has stopped working, I assume it is because of some changes within the database and is most likely looking at the wrong table, Would anyone be able to shed some light on what i would need to change i have pasted the query below, Thanks in advance

       

      WHERE CustomPollerAssignmentID IN (SELECT u.NetObjectID FROM (SELECT CustomPollerAssignment.CustomPollerAssignmentID AS NetObjectID, CustomPollerAssignment.AssignmentName AS Name

      FROM ((Interfaces INNER JOIN CustomPollerAssignment ON (Interfaces.InterfaceID = CustomPollerAssignment.InterfaceID)) INNER JOIN CustomPollers ON (CustomPollerAssignment.CustomPollerID = CustomPollers.CustomPollerID)) INNER JOIN CustomPollerStatus ON (CustomPollerAssignment.CustomPollerAssignmentID = CustomPollerStatus.CustomPollerAssignmentID) /*SplitMarker*/ WHERE

      (

      (CustomPollers.UniqueName = 'LineSpeed') AND

      (CustomPollerStatus.RawStatus )

      AND

      (

      (NetObjectPrefix = 'I') AND (Interfaces.Status = 1)

       

      )) as u)