Custom Alert Changes since Version 12

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)

Find more posts tagged with

Alerts

Accepted answers

All comments

mesverrum

Man that is some dense spaghetti to try and untangle. It seems like a piece is missing, where rawstatus is what? It looks like the interfaces tables are joined to make sure the alert only goes off when the interface is up, correct?

What exactly is it supposed to be notifying you of?

kiza25

Hi,

The report basically reports on multiple interfaces on a single device, all lines are bonded together to create a group and the report basically tells us if one of the loines within the group or multiple go down and the total interface speed drops below 10%.