Splunk Search

how group a field values with the maxevents of 4, without using transaction command

vinod743374
Communicator

Hi everyone,

i need an alternative for the transaction command, bcoz its taking to much time to load the dashboard,

this is my actual data

Botid             count

1528               1 

1228               1

1015              1

1558              1

12                    1

1698              1

1589.15        1

1589              1

 

am looking for an output like below

BotId                                                               count

1528,1228,1015,1558                              1

12,1698,1589.2,1589                                2

 

 

 

thanks in advance

Labels (1)
Tags (1)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
| table Botid
| streamstats count as row
| eval row=row%4
| streamstats count(eval(row=1)) as count
| stats list(Botid) as Botid by count
| eval Botid=mvjoin(Botid,",")

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust
| table Botid
| streamstats count as row
| eval row=row%4
| streamstats count(eval(row=1)) as count
| stats list(Botid) as Botid by count
| eval Botid=mvjoin(Botid,",")
Get Updates on the Splunk Community!

Detecting Remote Code Executions With the Splunk Threat Research Team

WATCH NOWRemote code execution (RCE) vulnerabilities pose a significant risk to organizations. If exploited, ...

Enter the Splunk Community Dashboard Challenge for Your Chance to Win!

The Splunk Community Dashboard Challenge is underway! This is your chance to showcase your skills in creating ...

.conf24 | Session Scheduler is Live!!

.conf24 is happening June 11 - 14 in Las Vegas, and we are thrilled to announce that the conference catalog ...