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!

Splunk Edge Processor | Popular Use Cases to Get Started with Edge Processor

Splunk Edge Processor offers more efficient, flexible data transformation – helping you reduce noise, control ...

3 Ways to Make OpenTelemetry Even Better

My role as an Observability Specialist at Splunk provides me with the opportunity to work with customers of ...

What's New in Splunk Cloud Platform 9.2.2406?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.2.2406 with many ...