topic Re: alert in Alerting

alert

vinod_52791 — Fri, 19 Nov 2021 11:08:20 GMT

I am getting success percentage from the query as 97.00% and my requirement is to add an alert when success percentage is below 95.00%

i am getting success % from below query

please suggest the query to add an alert when successrate is 95.00% in one hour span

Re: alert

ITWhisperer — Fri, 19 Nov 2021 12:01:17 GMT

Don't add the % to the successrate field, then you can do numeric comparisons on it. If you still want it displayed with the % sign, you can use fieldformat.

| eval successrate=100*successcount/total | fieldformat successrate=successrate."%"

Re: alert

vinod_52791 — Mon, 22 Nov 2021 10:19:24 GMT

hi @ITWhisperer

i want to send an alert when result is below 95.00%

Re: alert

ITWhisperer — Mon, 22 Nov 2021 10:43:36 GMT

| where successrate < 95

If you get any results, raise an alert