topic Re: How to write condition in Alerting

How to write condition

yvreddy90 — Wed, 30 Sep 2020 02:20:59 GMT

(index=logs OR index=audit) AND source="commtasks-logger" AND id=finishedcommtask |stats count by data.succeeded | transpose header_field="data.succeeded" | eval false perc = (f/(f+t))*100 | eval true perc = (t/(f+t))*100

This my query based on this how to write a condition is "false perc >10" trigger alert

Please help me anyone

Re: How to write condition

adonio — Thu, 26 Sep 2019 20:25:00 GMT

did you try ... | top data.succeeded instead of your ... | stats count ... ?

Re: How to write condition

gcusello — Wed, 30 Sep 2020 02:16:13 GMT

Hi yvreddy90,
At first you should try your search putting attention to the field names (don't use spaces); false_perc.
Then you have to be sure that "f" and "t" fields have values, so you can calculate the false_perc field.

(index=logs OR index=audit) source="commtasks-logger" id=finishedcommtask 
| stats count by data.succeeded 
| transpose header_field="data.succeeded" 
| eval false_perc=(f/(f+t))*100

then, when you'll be sure of this, at the end of your search you can add the condition:

| where false_perc>10

So if you have results you can trigger the alert.

Bye.
Giuseppe