Conditions set to run every 5 minutes, don't ever run again

I'm trying to create a simple condition that will check for drive space. I'm actually using the same code from a condition that is already present in Sentry:

SELECT D.HostName + ': (' + PDLD.Name + ')',
CONVERT (DECIMAL (3, 2), ((CAST (FreeSpace AS FLOAT) / (CAST (Size AS FLOAT))))) * 100
FROM PerformanceAnalysisDeviceLogicalDisk AS PDLD
INNER JOIN
Device AS D
ON D.ID = PDLD.DeviceID
WHERE D.HeartbeatDateTime IS NOT NULL
AND D.ID = @ComputerID

I have results in SQL, with both disks 0% , so I expect to receive a email every 5 minutes.

If I run this manually, it works.

but if I try to run again, or if I wait 5 minutes, I never receive any email.

I Don't know what "default evaluation frequency" means, but in the documentation we have:
Defines how often the condition is evaluated. The evaluation frequency can be adjusted individually throughout the hierarchy.

so is it ever possible, to create a condition that will execute a query every X minutes, and it doesn't matter if the past result was " true" or "false", it will evaluate the results and send and email ?

Parents

0 kekline 1 month ago

Hi Rafael, Are you just experimenting or do you actually want to be inundated with useless, noisy email notifications? At first glance to what you have here, it looks like your condition will not fire for any value 5.00 or less. But your query returns values that are no less than 15 all the way up to 93. So it looks like a simple logic condition isn't being met to fire your advisory condition (AC).

Other possible issues might be that the AC is on a level in the hierarchy that doesn't have email set as the response or that the response ruleset find that the AC is attempting to fire during a blackout window. And it might also be that the response is not email, maybe something else like Send to Log or Send to Database?

It looks like you've already checked, but just in case be sure to read the docs at https://documentation.solarwinds.com/en/success_center/sqlsentry/content/getting-started/building-advisory-conditions.htm, and perhaps watch the video there.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 kekline 1 month ago

Hi Rafael, Are you just experimenting or do you actually want to be inundated with useless, noisy email notifications? At first glance to what you have here, it looks like your condition will not fire for any value 5.00 or less. But your query returns values that are no less than 15 all the way up to 93. So it looks like a simple logic condition isn't being met to fire your advisory condition (AC).

Other possible issues might be that the AC is on a level in the hierarchy that doesn't have email set as the response or that the response ruleset find that the AC is attempting to fire during a blackout window. And it might also be that the response is not email, maybe something else like Send to Log or Send to Database?

It looks like you've already checked, but just in case be sure to read the docs at https://documentation.solarwinds.com/en/success_center/sqlsentry/content/getting-started/building-advisory-conditions.htm, and perhaps watch the video there.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data