Splunk Search

How do I get my top 10 search to return results per month for the last three months?

TCK101
New Member

Hello I have a Top 10 query and it's run using earliest of -3mon to latest @mon

So I would like to be able to return the top 10 results displayed per month

e.g.

Jan       Count    Feb       Count    Mar       Count             
item 1    xxxx     item 1    xxxx     item 1    xxxx             
item 2    xxxx     item 2    xxxx     item 2    xxxx             
item 3    xxxx     item 3    xxxx     item 3    xxxx  
Tags (3)
0 Karma

somesoni2
Revered Legend

Try like this

your base search | eval Month=strftime(_time,"%m/%Y") | top limit=10 item by Month
0 Karma
Get Updates on the Splunk Community!

Join Us at the Builder Bar at .conf24 – Empowering Innovation and Collaboration

What is the Builder Bar? The Builder Bar is more than just a place; it's a hub of creativity, collaboration, ...

Combine Multiline Logs into a Single Event with SOCK - a Guide for Advanced Users

This article is the continuation of the “Combine multiline logs into a single event with SOCK - a step-by-step ...

Everything Community at .conf24!

You may have seen mention of the .conf Community Zone 'round these parts and found yourself wondering what ...