Splunk Search

increment count in a field based on field values..

jiaqya
Builder

Need help with a situation.

Example table below:

column1,column2,column3,_time

1,2,3,21st

1,2,3,22nd

1,2,3,23rd

3,2,1,23rd

4,5,6,23rd

if on multiple days/times,  column1 ,2 and 3 are same(4th column is _time ) , then add a new field(count) with incrementing numbers by _time , like below. how can this be done  ? need help with query..

column1,column2,column3,_time,count

1,2,3,21st,1

1,2,3,22nd,2

1,2,3,23rd,3

3,2,1,23rd,1

4,5,6,23rd,1

Labels (1)
0 Karma
1 Solution

thambisetty
SplunkTrust
SplunkTrust

| bin _time span=1d
| stats count  by column1,column2,column3_time

| streamstats count by column1,column2,column3

————————————
If this helps, give a like below.

View solution in original post

0 Karma

jiaqya
Builder

Works perfectly fine, thank you...

 

0 Karma

thambisetty
SplunkTrust
SplunkTrust

| bin _time span=1d
| stats count  by column1,column2,column3_time

| streamstats count by column1,column2,column3

————————————
If this helps, give a like below.
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 ...