NPM Alerts with SQL Queries

greg.remer

Hi Guys,

Recently we created alerts to provide us with BGP Neighbor information

I'm having a problem as such as when the SQL Query returns NULL values for neighbors that don't have the IP address in the database, instead of the alert displaying "nothing" if pastes the SQL query in the alert.

Is this an issue within NPM or is there a way to tell NPM to leave it BLANK..?

Thanks

greg.remer

Hey Guys,

UPDATE:

So I created an "IF EXISTS" in my query and tested within SQL Management Studio, and so it works.

Below is what is displayed when i run the query;

When I try and add to the Solarwinds Alerts as a SQL statement it doesn't work

Does anyone know if the SQL feature supports the IF EXISTS?

Thanks in advance

alexslv​ i_like_eggs​