Splunk Search

How to get the head K of each index in a Splunk search?

lys1030
Explorer

My stats contain an entry called "index". How to get the head K of each index type? For example I want the top 10 in index=a, plus the top 10 in index=b, etc.

Tags (4)
0 Karma

woodcock
Esteemed Legend

You need a thing to "top" by. For example, to see the top sourcetypes by index, do this:

index=* | top sourcetype by index
0 Karma

woodcock
Esteemed Legend

If you need the 10 most recent events by index, you can do this:

index=* | streamstats current=t count by index | where count<=10 | stats list(_raw) by index
0 Karma
Get Updates on the Splunk Community!

Financial Services Industry Use Cases, ITSI Best Practices, and More New Articles ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Splunk Federated Analytics for Amazon Security Lake

Thursday, November 21, 2024  |  11AM PT / 2PM ET Register Now Join our session to see the technical ...

Splunk With AppDynamics - Meet the New IT (And Engineering) Couple

Wednesday, November 20, 2024  |  10AM PT / 1PM ET Register Now Join us in this session to learn all about ...