-
Re: Configuring Basic & Advanced Alerts
bleearg13 Apr 23, 2009 11:29 AM (in response to mickwombat)Advanced alerts can only be configured to trigger based upon values in the nodes, interfaces, pollers, and virtual machines tables. I'm pretty sure that you cannot configure the advanced alert to trigger based upon the status of another alert, either basic or advanced.
I would just configure one advanced alert and forget about the basic alerts. The advanced alerts offer you much more flexibility and can be configured to do everything that a simple alert can do and more.
-
Re: Configuring Basic & Advanced Alerts
mickwombat Apr 28, 2009 1:30 AM (in response to bleearg13)Hi,
Thanks for the advice. Have managed to configure the alarm as I wanted.
I think I just missed a drop down menu when trying to setup.
;-)
-
Re: Configuring Basic & Advanced Alerts
ch.aichhorn Apr 28, 2009 5:41 AM (in response to mickwombat)Hi,
i´d like to get an alert if my routers loses a special ospf neighbor. I´ve configured an universal device poller for the ospf neighbor table.
The Problem is that the alert definition triggers an alert when the SQL Statement in the AlertDefinition Table returns an Value. But i need a triggered Alert when the statement returns no value (the special ip is not in the ospf neighbor table).
So i modified the sql statement with an if statement that another ospf neighbor is returned when my special ip is not in the ospf neighbor table, otherwise nothing will be returned.
the sql statment works fine in sql management studio, but there is no alert triggerd.
my sql statement:
if
(SELECT CustomPollerStatus.Status AS Status
FROM (CustomPollerStatus INNER JOIN CustomPollerAssignment ON (CustomPollerStatus.CustomPollerAssignmentID = CustomPollerAssignment.CustomPollerAssignmentID)) LEFT OUTER JOIN CustomPollers ON (CustomPollerAssignment.CustomPollerID = CustomPollers.CustomPollerID)
WHERE
(
(CustomPollers.UniqueName = 'ospfNbrRtrId') AND
(CustomPollerStatus.Status = '10.0.0.1')
)) = '10.0.0.1'
(
SELECT CustomPollerAssignment.CustomPollerAssignmentID AS NetObjectID, CustomPollerAssignment.AssignmentName AS Name
FROM (CustomPollerStatus INNER JOIN CustomPollerAssignment ON (CustomPollerStatus.CustomPollerAssignmentID = CustomPollerAssignment.CustomPollerAssignmentID)) LEFT OUTER JOIN CustomPollers ON (CustomPollerAssignment.CustomPollerID = CustomPollers.CustomPollerID)
WHERE
(
(CustomPollers.UniqueName = 'ospfNbrRtrId') AND
(CustomPollerStatus.Status LIKE 'noreturn')
))
else
(
SELECT CustomPollerAssignment.CustomPollerAssignmentID AS NetObjectID, CustomPollerAssignment.AssignmentName AS Name
FROM (CustomPollerStatus INNER JOIN CustomPollerAssignment ON (CustomPollerStatus.CustomPollerAssignmentID = CustomPollerAssignment.CustomPollerAssignmentID)) LEFT OUTER JOIN CustomPollers ON (CustomPollerAssignment.CustomPollerID = CustomPollers.CustomPollerID)
WHERE
(
(CustomPollers.UniqueName = 'ospfNbrRtrId') AND
(CustomPollerStatus.Status NOT LIKE '10.0%')
))
goThe LastExecuteTime colum increments every minute and the LastErrorTime Date is some days in the past.
Any Ideas?
-
Re: Configuring Basic & Advanced Alerts
ch.aichhorn Apr 28, 2009 6:18 AM (in response to ch.aichhorn)Update: got it working!
had to delete the "go" statement at the end!
-
-
-