Splunk Search

Using stats to organise repetitive data

leonheart78
Explorer

I have a set of data as below:
alt text

If you can see, the TagNames are repetitive. I would want to re-arrange it to below format

TagName LimitString1 LimitString2 LimitString3 .. . . . . . . . . .

CHEM_R13719 null 18
CHEM_R13720 null 01
.
.
CHEM_R13723 0 4940

May I know how can I use stats command to achieve this? Thank you

Tags (2)
0 Karma

utk123
Path Finder

It seems you are looking for something like this:
index=.... | stats list(LimitString) as "Limit String" by TagName

0 Karma

DalJeanis
Legend

Try...

 Your search
| eval LimitString=coalesce(LimitString,"")
| stats count by TagName LimitString
0 Karma

leonheart78
Explorer

Unfortunately, the output is not what I required. Basically, we need to sort the values in LimitString, into the respective TagName. I was reading up on the "bin" command, not sure it would help in getting what I wanted.

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