Splunk Search

How to create a report to count events per day over a 6 month time span?

prurek
New Member

I am looking to set up a report counting daily occurrences over a period of 6 months, I want to be able to run this report on request. I've been looking around for a search to get this, but have run into a wall. Any help would be appreciated.

0 Karma
1 Solution

somesoni2
Revered Legend

Does the event that you're counting has retention period or more than 6 months? If yes, then you can run simple search like base search | timechart span=1d count on 6 month time range to get your report. If the retention period is less than 6 months than, you can get that report, at least not right away and directly. You would've to setup summary indexing , where you'll run a search daily to get count of events for yesterday and store it in a summary index with retention period of 6month or more. After a while this summary index will have data for your report.

View solution in original post

0 Karma

somesoni2
Revered Legend

Does the event that you're counting has retention period or more than 6 months? If yes, then you can run simple search like base search | timechart span=1d count on 6 month time range to get your report. If the retention period is less than 6 months than, you can get that report, at least not right away and directly. You would've to setup summary indexing , where you'll run a search daily to get count of events for yesterday and store it in a summary index with retention period of 6month or more. After a while this summary index will have data for your report.

0 Karma

prurek
New Member

Thank you, that works perfectly.

0 Karma
Get Updates on the Splunk Community!

Shape the Future of Splunk: Join the Product Research Lab!

Join the Splunk Product Research Lab and connect with us in the Slack channel #product-research-lab to get ...

Auto-Injector for Everything Else: Making OpenTelemetry Truly Universal

You might have seen Splunk’s recent announcement about donating the OpenTelemetry Injector to the ...

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...