Splunk Search

Sorting/Arranging chart results

RupeshMano
Explorer

Hi,

I have the below query which is used to find the total and used diskspace of a linux server. I need to arrange the results something like below. Please help me with the query

MountedOn  Size:abc Used_DS:abc Size:def Used_DS:abc

Query used:

index=test sourcetype="df"
| sort _time 
| multikv 
| rex field="Used" "^(?[\d.]*)(?\w+)$" 
| rex field="Size" "^(?[\d.]*)(?\w+)$" 
| eval Used=if(GB_MB="M", round(Used1/1024,2), round(Used1,2)), Size=if(GB_MB1="M", round(Size1/1024,2), round(Size1,2)) 
| stats latest(Used) AS "Usedable_DiskSpace", latest(Size) AS Size by host, MountedOn 
| chart values(Usedable_DiskSpace) as Used_DS, values(Size) AS Size over MountedOn by host limit=0 
| eval 
| fillnull value="0 G"

Current results:

MountedOn Size:abc Size:def Used_DS:abc Used_DS:def
Tags (1)
0 Karma
Get Updates on the Splunk Community!

Index This | Forward, I’m heavy; backward, I’m not. What am I?

April 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

A Guide To Cloud Migration Success

As enterprises’ rapid expansion to the cloud continues, IT leaders are continuously looking for ways to focus ...

Join Us for Splunk University and Get Your Bootcamp Game On!

If you know, you know! Splunk University is the vibe this summer so register today for bootcamps galore ...