Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Advanced Alert logic question :)

I want to be alerted when a Node is down, there is any text in the custom property "NodeType" field, and the text in the custom property "Alert_Supression" is "suppressed". (There is no actual "alert suppression" configured in this alert). However, I am not getting alerts.

Trigger Alert when all of the following apply
   Node Status is equal to Down
   NodeType is not empty
   Alert_Supression is not equal to suppressed

Am I interpreting the "is not empty" criterian correctly as meaning there is no text in the custom property field? What's wrong with this?

Debbi

Find more posts tagged with

Accepted answers

All comments

mcbridea

Can you explain your custom properties further?

It looks strange that you want an alert if the suppression is true. Do those conflict?

mcbridea

Oppps - I see that the suppression would be not true to alert. Read it too fast.

I would take out one of the custom property critera and see if the other is OK. This will let you know which one is not working.

sedmo

It's very possible that the "is not empty" criteria is causing you problems. There are two different ways that database fields can be empty, they can be blank or they can be Null.

when creating an SQL query to find blanks in a field you would use syntax like this (note that the quotes are two single quotes):

Field1 = ''

When creating SQL to find fields that are not blank you would use this:

Field1 <> ''

To find fields with Null values you would use this syntax:

Field1 is null

And this would find fields that are not null:

Field1 is not null

Once you understand this then the trick is how to create the SQL syntax you want with the alert GUI.

To find blank fields use this syntax. Note that to get an * as the criteria you just leave it blank:

Field1 is equal to *

This would find fields that are not blank:

Field1 is not equal to *

This would find fields that are Null:

Field1 is empty

And this finds fields that are NOT Null:

Field 1 is not empty

If you know that your NodeType field does not contain any Null values then you can use an alert like this:

Trigger Alert when ALL of the following apply

Node Status is equal to Down

NodeType is not equal to *

Alert_Supression is not equal to suppressed

On ther other hand, if it is possible that the NodeType field can contain both blank and Null values then your alert would need to be configured like this:

Trigger Alert when ALL of the following apply

Node Status is equal to Down

Alert_Supression is not equal to suppressed

Trigger Alert when ANY of the following apply

NodeType is not equal to *

NodeType is not empty

Hope this helps.

Debbi

Thanks! I just want to verify that you mean to leave the * at default, not enter a text string of "*". I will try these suggestions!

Debbi

sedmo

Correct. Don't enter anything in for the criteria.

Debbi

Thanks. Will see what happens.