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!

Splunk Mobile: Your Brand-New Home Screen

Meet Your New Mobile Hub  Hello Splunk Community!  Staying connected to your data—no matter where you are—is ...

Introducing Value Insights (Beta): Understand the Business Impact your organization ...

Real progress on your strategic priorities starts with knowing the business outcomes your teams are delivering ...

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...