topic Re: SPL Search- How do I reformat my table? in Splunk Search

How do I reformat my table?

uagraw01 — Wed, 26 Oct 2022 14:04:42 GMT

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.

Re: SPL Search- How do I reformat my table?

ITWhisperer — Fri, 21 Oct 2022 17:51:52 GMT

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

Re: SPL Search- How do I reformat my table?

uagraw01 — Sat, 22 Oct 2022 14:37:29 GMT

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

Re: SPL Search- How do I reformat my table?

uagraw01 — Sun, 23 Oct 2022 16:24:48 GMT

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

Re: SPL Search- How do I reformat my table?

ITWhisperer — Mon, 24 Oct 2022 05:38:18 GMT

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

Re: SPL Search- How do I reformat my table?

uagraw01 — Wed, 26 Oct 2022 11:12:27 GMT

@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