Splunk Search

How do I reformat my table?

uagraw01
Builder

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. 

Labels (1)
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
Builder

  @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
Builder

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

0 Karma

uagraw01
Builder

@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!

Build Scalable Security While Moving to Cloud - Guide From Clayton Homes

 Clayton Homes faced the increased challenge of strengthening their security posture as they went through ...

Mission Control | Explore the latest release of Splunk Mission Control (2.3)

We’re happy to announce the release of Mission Control 2.3 which includes several new and exciting features ...

Cloud Platform | Migrating your Splunk Cloud deployment to Python 3.7

Python 2.7, the last release of Python 2, reached End of Life back on January 1, 2020. As part of our larger ...