Splunk Search

How to sort list by size of group by?

viggor
Path Finder

I have a query of the form

'stats list(body) AS events BY id

Which gives me for example:

id body
1 jack
2 foo
  bar
  joe
3 sun
  moon

I would like this to be sorted according to the size of each group, i.e., the output should be

    id body
    2 foo
      bar
      joe
    3 sun
      moon
    1 jack

How would I achieve this?

Tags (3)
0 Karma
1 Solution

somesoni2
SplunkTrust
SplunkTrust

Try like this

your base search | stats list(body) AS events BY id | eval t=mvcount(events) | sort -t | fields -t 

View solution in original post

somesoni2
SplunkTrust
SplunkTrust

Try like this

your base search | stats list(body) AS events BY id | eval t=mvcount(events) | sort -t | fields -t 

viggor
Path Finder

Nice thanks, should the last part of your query maybe be sort -t | table id events -t ?

0 Karma
Get Updates on the Splunk Community!

Routing logs with Splunk OTel Collector for Kubernetes

The Splunk Distribution of the OpenTelemetry (OTel) Collector is a product that provides a way to ingest ...

Welcome to the Splunk Community!

(view in My Videos) We're so glad you're here! The Splunk Community is place to connect, learn, give back, and ...

Tech Talk | Elevating Digital Service Excellence: The Synergy of Splunk RUM & APM

Elevating Digital Service Excellence: The Synergy of Real User Monitoring and Application Performance ...