cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 9

Daily Email Alert (regardless of network status)

Jump to solution

OK, my manager wants a daily email notification just to make sure the notification functions of the server are running.  So I created this:

Name of Alert:  Daily Alert Test

Enabled

Check this Alert every: 1 Minute

Trigger Condition:

Type of Property to Monitor:  Node

Trigger Alert when all of the following apply

     IP Address is equal to 10.0.1.1 (this device is always up)

     Node Status is equal to Up

Do not trigger this action until condition exists for more than 5 Minutes

Reset Condition:

Reset Alert when all of the following apply

     IP Address is equal to 10.0.1.1

     Node Status is equal to Up

do not reset this action until condition exists for more than 24 Hours

Its never getting triggered.  Shouldn't this trigger, and reset itself every 24 hours and 5 minutes?

Thanks,

Tim

0 Kudos
1 Solution

Change where statement to

WHERE CAST(LastSync AS TIME) BETWEEN '8:00' and '8:10'

Use the time as military time.  this should work

View solution in original post

0 Kudos
13 Replies

The problem is with your trigger alert. Even with no reset condition, your trigger will still not email. Unless 10.0.1.1 was turned off and then back on. Then your trigger would email.

You can have a trigger alert (with no reset alert) of just "IP Address is equal to 10.0.1.1" and then you will get an email. If you acknowledge the alert, it resets the trigger and you'll get another email.

I haven't worked out as yet how to reset it after 24 hours.

0 Kudos
Level 10

Trigger condition is set to same as reset. Set the reset to node = down.

0 Kudos

v_andrewj,

If I did that it would never reset correct (so I would only get the alert once)?  The device I'm monitoring never goes down.

bsciencefiction.tv,

I selected Type of Property to Monitor: Custom SQL Alert

Set the Trigger Query to: Node

WHERE

(

(Nodes.IP_Address = '10.0.1.1') AND

(CurTime() Between '12:00' and '12:10')

)

And received the error:

SQL Error:

-2137217900 - 'CurTime' is not a recognized built-in function name.

Thanks for the help all.

Tim

0 Kudos

Yeah, didn't think about that... But having a trigger and a reset the same is your problem.

0 Kudos

Change where statement to

WHERE CAST(LastSync AS TIME) BETWEEN '8:00' and '8:10'

Use the time as military time.  this should work

View solution in original post

0 Kudos

Oh, and just set the rest trigger to when alert trigger is no longer true

0 Kudos

bsciencefiction.tv,

I selected Type of Property to Monitor: Custom SQL Alert

Set the Trigger Query to: Node

WHERE CAST (LastSyn AS TIME) BETWEEN '8:45' and '8:55'

And received the error:

SQL Error:

-2147217900 - Invalid column name 'LastSyn'.

I am running Orion Alert Manager 2011.2.0.  Is there a SQL plug in I have to enable?

I appreciate the help. 

tim

0 Kudos

Typo on LastSync

bsciencefiction.tv

Thank you for the help (and I apologize for my poor typing skills).  It worked as expected, but I did get a couple hundred email notifications (it fired off the entire 10 minutes).  What I ended up doing is modifying the command to look like this:

WHERE CAST (LastSync AS TIME) BETWEEN '11:59:00' and '11:59:05'

And set the 'do not trigger till' condition exists for more than 4 seconds and it now only sends 1 (or sometimes 2) emails.

Thanks again,

tim

0 Kudos

Why don't you just have an scheduled report emailed to him each day with the status of this device.

0 Kudos

He wants proof that the actual alerting functionality is up and running. 

0 Kudos

You could select custom sql and use the GetDate() and set it to trigger at a certain time each day.

0 Kudos

For example

Select Node, Status

From Nodes

Where IP_Address = '10.0.1.1' and ( CurTime() Between '12:00' and  '12:10')

that should set off the alarm when it polls between that time period each day regardless of status.