Splunk Search

Add value on a column without csv input file

Lucie99
Explorer

Hi everyone,

I need to put in these fix values on the Interval_tolerance column. Has somebody an idea ?

 

Thanks

Capture.PNG

Labels (1)
0 Karma
1 Solution

FrankVl
Ultra Champion

Just do this in each of the sections of your search (replacing the ... by the respective value):

| eval Interval_tolerance = ...

Also, your search can be simplified a lot by doing both avg and stdev calculations in 1 go instead of the "appendcols"

| stats avg(Moy) as AV stdev(Moy) as SD by Debit

View solution in original post

FrankVl
Ultra Champion

Just do this in each of the sections of your search (replacing the ... by the respective value):

| eval Interval_tolerance = ...

Also, your search can be simplified a lot by doing both avg and stdev calculations in 1 go instead of the "appendcols"

| stats avg(Moy) as AV stdev(Moy) as SD by Debit

Lucie99
Explorer

Thanks !! It works

My code is also shorter !

 

Have a nice week

0 Karma

FrankVl
Ultra Champion

Looking at it once more, you can get rid of that whole "appends" approach, by simply removing the 'Debit=...' part from your search. Or replace it by Debit IN(a,b,c) if the data source contains other debit values which you want to ignore. Because the Debit field is the only thing that is different between the various appends bits, and you already do a 'by Debit' in your stats.

Then you can do the eval like this:

| eval Interval_tolerance = case(Debit=a,x,Debit=b,y,Debit=c,z)

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 ...