Splunk Search

How to sort data?

jaydiare
Explorer

Hello, I wonder if somebody can please help me to sort the following data:

jaydiare_0-1694807431957.png

Into this table:

jaydiare_1-1694807459588.png

Any ideas are welcome

I was trying to run this query but it is not separating the values of the fields properly:

index=query_mcc | eval data = split(_raw, ",") | eval Date = strftime(_time, "%Y-%m-%d-%H:%M:%S") | eval Category = mvindex(data, 1) | eval Status = mvindex(data, -1) | eval Command = mvindex(data, 0) | table host, Date, Category, Status, Command

 

but is giving me this , where it only shows the first line.. 

jaydiare_0-1694810092225.png

 

 

 

 

 

 

Labels (4)
0 Karma

PickleRick
SplunkTrust
SplunkTrust

Regardless of splitting the event, there is no "merged" cells in Splunk. So you can't visualize it this way.

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
index=query_mcc 
| eval data=split(_raw,"
")
| mvexpand data
| eval data = split(data, ",")
| eval Date = strftime(_time, "%Y-%m-%d-%H:%M:%S") 
| eval Category = mvindex(data, 1) 
| eval Status = mvindex(data, -1) 
| eval Command = mvindex(data, 0) 
| table host, Date, Category, Status, Command
0 Karma
Get Updates on the Splunk Community!

Now Playing: Splunk Education Summer Learning Premieres

It’s premiere season, and Splunk Education is rolling out new releases you won’t want to miss. Whether you’re ...

The Visibility Gap: Hybrid Networks and IT Services

The most forward thinking enterprises among us see their network as much more than infrastructure – it's their ...

Get Operational Insights Quickly with Natural Language on the Splunk Platform

In today’s fast-paced digital world, turning data into actionable insights is essential for success. With ...