Splunk Search

need search with if condition

avikc100
Path Finder

Screen Shot 2021-06-08 at 8.57.22 PM.png

 

Am getting data in this format now.
but i need to show only those row where sum of all column values are > 500

am trying somethign like this. am new so unable to form the query, please help

index=b2b_wm_core  sourcetype=wm_woheaderdetail_log logType="header" type="proc" woCountInFile | bin woCountInFile span=10.1 | 
search if(count(woCountInFile < 70) > 500) | timechart  span=1h  count by woCountInFile
Labels (3)
0 Karma
1 Solution

avikc100
Path Finder

its working now! Appreciate!

View solution in original post

0 Karma

avikc100
Path Finder

its working now! Appreciate!

0 Karma

bowesmana
SplunkTrust
SplunkTrust

If the existing columns are what you initial expect before your >500 test, then simply add the following to the end of your query

| addtotals
| where Total>500
| fields - Total

 

0 Karma

bowesmana
SplunkTrust
SplunkTrust

If it works for you, please mark the question as solved, so others can benefit

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...