Trigger alert on a calculated value

wlbaird · ‎06-24-2021

My search ends with:

...

| stats count(Request) as RequestCnt, count(FailedRequest) FailedRequestCnt

| eval FaildRequestPercentage = RequestCnt / FailedRequestCnt * 100

How would I specify a trigger for FaildRequestPercentage > 10?

How would I include: RequestCnt, FailedRequestCnt , and FaildRequestPercentage values in my alert message?

richgalloway · ‎06-24-2021

Have the alert trigger when the number of results is not zero and let the query determine when the alert triggers.

...
| stats count(Request) as RequestCnt,  count(FailedRequest) FailedRequestCnt
| eval FaildRequestPercentage =  RequestCnt / RequestCnt * 100
| where FaildRequestPercentage > 10
| table RequestCnt RequestCnt FaildRequestPercentage

---
If this reply helps you, Karma would be appreciated.

Trigger alert on a calculated value

alert action

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Deep Dive: Optimizing Telemetry Pipelines in Splunk Observability Cloud

Announcing Modern Navigation: A New Era of Splunk User Experience

Data Drivers: How We're Streaming Real-Time F1 Telemetry Directly into Splunk ...

Join the Conversation

Trigger alert on a calculated value

alert action

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Deep Dive: Optimizing Telemetry Pipelines in Splunk Observability Cloud

Announcing Modern Navigation: A New Era of Splunk User Experience

Data Drivers: How We're Streaming Real-Time F1 Telemetry Directly into Splunk ...