Splunk Enterprise

help on timechart

jip31
Motivator

hello

I need to do a timechart from a stats count 

this stats count is used to pre filter events (sante=OK)

index=toto sourcetype=tutu 
| stats count(hang) as hang, count(crash) as crash, count(web) as web by site 
| eval sante=if((hang>5) AND (crash>2) AND (webduration>=1), "OK","KO")   
| search sante=OK

 Now I wonder how to do to timechart these events?

Thanks

Tags (1)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

Your stats command needs to include some sort of time element

index=toto sourcetype=tutu 
| bin _time span=1h
| stats count(hang) as hang, count(crash) as crash, count(web) as web by _time site 
| eval sante=if((hang>5) AND (crash>2) AND (webduration>=1), "OK","KO")   
| search sante=OK

View solution in original post

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Your stats command needs to include some sort of time element

index=toto sourcetype=tutu 
| bin _time span=1h
| stats count(hang) as hang, count(crash) as crash, count(web) as web by _time site 
| eval sante=if((hang>5) AND (crash>2) AND (webduration>=1), "OK","KO")   
| search sante=OK
0 Karma
Get Updates on the Splunk Community!

See Splunk Platform & Observability Innovations at Cisco Live EMEA

Hi Splunkers, Learn about what’s next for Splunk Platform at Cisco Live EMEA.  Data silos are a big challenge ...

The OpenTelemetry Certified Associate (OTCA) Exam

What’s this OTCA exam? The Linux Foundation offers the OpenTelemetry Certified Associate (OTCA) credential to ...

From Manual to Agentic: Level Up Your SOC at Cisco Live

Welcome to the Era of the Agentic SOC   Are you tired of being a manual alert responder? The security ...