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!

Accelerating Observability as Code with the Splunk AI Assistant

We’ve seen in previous posts what Observability as Code (OaC) is and how it’s now essential for managing ...

Integrating Splunk Search API and Quarto to Create Reproducible Investigation ...

 Splunk is More Than Just the Web Console For Digital Forensics and Incident Response (DFIR) practitioners, ...

Congratulations to the 2025-2026 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...