Splunk Search

every 5min for the last 15min

LauraBre
Communicator

Hello,

I have this following search:

source="Laura_ACS" earliest=-15m latest=now| eventstats count as "totalVE"| eventstats count(eval(STAT_VE="N")) as "totalVENO"|eval percent=(totalVENO/totalVE)*100 | stats values(totalVENO) AS COMPTEUR, values(percent) AS TAUX|search TAUX=100

I want to calculate this search every 5min for the last 15min. How can I do it?

Thx by advance,

Laura

Tags (1)
0 Karma
1 Solution

LauraBre
Communicator

I resolve my problem: this my actually search:

source="Laura_ACS" earliest=-15m latest=now| bucket _time span=5m | eventstats count as "totalVE" by _time| eventstats count(eval(SD_STAT_PA="N")) as "totalVENO" by _time|eval percent=(totalVENO/totalVE)*100  |stats values(totalVENO) AS COMPTEUR, values(percent) AS TAUX by _time |search TAUX=100

View solution in original post

LauraBre
Communicator

I resolve my problem: this my actually search:

source="Laura_ACS" earliest=-15m latest=now| bucket _time span=5m | eventstats count as "totalVE" by _time| eventstats count(eval(SD_STAT_PA="N")) as "totalVENO" by _time|eval percent=(totalVENO/totalVE)*100  |stats values(totalVENO) AS COMPTEUR, values(percent) AS TAUX by _time |search TAUX=100
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...