Splunk Search

How to optimize a subsearch with a wide range?

lmzheng
Explorer

I have a subsearch that I use to determine the first occurrence of the issue logged. I currently have an earliest=-4d, because the report runs every 15 minutes. If I were to extend the range to 365 days, the search would not be able to update efficiently.

Since the data remains the same before the current day, is it possible is cache this information so the search does not delay?

Thank you,
Lee

0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

This sounds like a job for Summary Index.

Run your reports every 15 minutes and save results in a summary index. Your search to find the first occurrence need only scan the summary rather than the raw data and should be much faster.

---
If this reply helps you, Karma would be appreciated.

View solution in original post

0 Karma

richgalloway
SplunkTrust
SplunkTrust

This sounds like a job for Summary Index.

Run your reports every 15 minutes and save results in a summary index. Your search to find the first occurrence need only scan the summary rather than the raw data and should be much faster.

---
If this reply helps you, Karma would be appreciated.
0 Karma

lmzheng
Explorer

Is this option available for Splunk Cloud or only Splunk Enterprise?

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Summary indexing is available in both Splunk Enterprise and Splunk Cloud.

---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

(view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...