topic Re: Scheduled report not working as expected when collected to a new Summary index in Splunk Enterprise

Scheduled report not working as expected when collected to a new Summary index

Prasobh — Fri, 13 Dec 2024 07:01:55 GMT

Hi Team,

To reduce the time taken to load my Splunk dashboard, I created a new summary index to collect the events which retrieves the past 30 days of events and scheduled the same report to run every hour and "enabled the summary indexing" as per the documentation: Create a summary index in Splunk Web - Splunk Documentation

However, while checking the index, I could see that the data ingestion is not taking place as per the scheduled report.
Please find the attached screenshots for additional reference. Looking forward for a workaround or a solution.

Re: Scheduled report not working as expected when collected to a new Summary index

PaulPanther — Fri, 13 Dec 2024 08:32:34 GMT

Please share the screenshots and the search that you use to fill the summary index.

Re: Scheduled report not working as expected when collected to a new Summary index

Prasobh — Mon, 16 Dec 2024 10:32:45 GMT

Report scheduleSearch queryIndexSummary index

Re: Scheduled report not working as expected when collected to a new Summary index

Prasobh — Mon, 16 Dec 2024 10:33:24 GMT

Please find the requested screenshots

Re: Scheduled report not working as expected when collected to a new Summary index

PaulPanther — Fri, 20 Dec 2024 11:11:38 GMT

Remove the collect command in your search query. The enabled summary indexing is enough to fill the summary index.

Re: Scheduled report not working as expected when collected to a new Summary index

Prasobh — Sun, 22 Dec 2024 07:58:05 GMT

Thank you for the update @PaulPanther .
As advised, i removed the collect command from my search query.

Even then, I am not able to get the events in the summary index. This search is scheduled to run every hour, even then the latest events, I could see is 10 days ago and not 1 hour. Scheduled report is not ingesting events to the summary index as i could observe.

Re: Scheduled report not working as expected when collected to a new Summary index

woodcock — Mon, 23 Dec 2024 02:58:49 GMT

I am sure this is documented somewhere but it catches everybody the first time. It is not enough to just create the index on the indexers; you must also instantiate a dummy index on the Search Head(s), too! If you do not, "collect" (wheter explicitly in the SPL or as an alert action) will not work AND will not generate any kind of error.