Splunk Search

order result High to Low

sdewar83
Path Finder

I have a simple query, listing event codes by host:

index=wineventlog sourcetype=WinEventLog:Security
Stats count by EventCode, host

I'd like to order the results so that it shows either the top 10 highest count event codes (e.g 100 of 4625, 80 of 4264, etc) per host.
Or at least displays the count column in a highest to lowest fashion, per host. At the moment it displays all the info, but in no specific ordering. I'd like it to be more readily obvious which are the most common errors happening on hosts in t he time period i'm searching.

Any assistance appreciated!

0 Karma
1 Solution

Sukisen1981
Champion

so you add this - sort host,- count

View solution in original post

0 Karma

Sukisen1981
Champion

so you add this - sort host,- count

0 Karma

sdewar83
Path Finder

perfect! worked like a charm.

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...