Splunk Search

How do I reformat my table?

uagraw01
Motivator

Hello Splunkers!!

As per my requirement my current results are as below :

severity Vulnablities
Critical 3
Medium  4
Low 6

 

But my expected results are like:

Critical Medium Low
3 4 6

 

Please help me how can I achieve the expected results. 

0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
| transpose 0 header_field=severity column_name=severity
| fields - severity

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust
| transpose 0 header_field=severity column_name=severity
| fields - severity

uagraw01
Motivator

  @ITWhisperer  My results looking not expected. Please help me how to fix it.

IMG_20221023_215005__01.jpg

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

You will have to show what spl you have used in order for me to make any suggestions as to what to change.

0 Karma

uagraw01
Motivator

@ITWhisperer Thanks for your suggestion. I will try once I will resume the work let you know.

0 Karma

uagraw01
Motivator

@ITWhisperer Thanks for your valuable response, I was away from the work from last few days. Once I will come across with that query I will let you know.

 

Thanks

 

Tags (1)
0 Karma
Get Updates on the Splunk Community!

October Community Champions: A Shoutout to Our Contributors!

As October comes to a close, we want to take a moment to celebrate the people who make the Splunk Community ...

Community Content Calendar, November Edition

Welcome to the November edition of our Community Spotlight! Each month, we dive into the Splunk Community to ...

Stay Connected: Your Guide to November Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...