Splunk Search

How do I extract value from stats list

apichai32356
Explorer

I want to extract count from list (picture 1 ) to table (picture 2) How do  I  do?

 

 

 

 |stats count by  Name,severity |sort - count | stats list(severity) as severity, list(count) as count, sum(count) as Total by Name 
| sort -Total

 

 

The field severity is follow by name the count for each level inside severity

apichai32356_0-1624565098885.png

apichai32356_1-1624565112484.png

 

Labels (1)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
| chart count by Name,severity
| addtotals

View solution in original post

apichai32356
Explorer

Ok, now I know the error point thank you Mr.ITWhisperer .

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| chart count by Name,severity
| addtotals

apichai32356
Explorer

I have try, but the information are inaccurate 

apichai32356_0-1624567815751.png

 

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| stats count by Name,severity
| xyseries Name severity count
| addtotals
0 Karma
Get Updates on the Splunk Community!

Splunk MCP & Agentic AI: Machine Data Without Limits

  Discover how the Splunk Model Context Protocol (MCP) Server can revolutionize the way your organization ...

Finding Based Detections General Availability

Overview  We’ve come a long way, folks, but here in Enterprise Security 8.4 I’m happy to announce Finding ...

Get Your Hands Dirty (and Your Shoes Comfy): The Splunk Experience

Hands-On Learning and Technical Seminars  Sometimes, you just need to see the code. For those looking for a ...