Oracle Query alert logic

[raymond.therrien]

Hello,

I would like to change the [b]Oracle Query Wizard[/b] alert logic. It seems that it only operates on a 'Greater than, or equaled' logic, but there are some cases where I want to have it as 'equaled to' or 'Less than'. Is this possible? Right now I have to add CASE operators to my queries to avoid this.

select CASE WHEN count(*) = 0 THEN '1' WHEN count(*) > 0 THEN '0' END CASE from

Thanks,
-Ray

[ssax]

It looks like it supports the standard threshold format, see here:

https://nagios-plugins.org/doc/guidelin ... HOLDFORMAT

Try using the colon (:) after the value:
- Change X to the values you want

Code: Select all

 --warning X: --critical X: