Knowledge Management

Running a search for "All Time" using Summary Search Index

pmccomb
Explorer

I would like to run a search for time period = "All Time". The idea is to get a unique list of all users and user firms that have ever logged into a particular web site.

In order to have the search run more efficiently/quickly I think I should use a Summary Index.

How do I update the Summary Index so that it contains all data over all time in the past and then gets augmented periodically (say, hourly) as time moves forward and not overlap data sets or have time gaps?

Here is an example of may search:
sourcetype="Logins" message="User logged in" Userid NOT "*@internaluser.com" | sichart distinct_count(Userid)

Tags (1)
0 Karma
1 Solution

MuS
Legend

Hi pmccomb,

take a look at the docs about the fill_summary_index.py script, which can be used to add new event into summary index.

hope this helps ...

cheers, MuS

View solution in original post

MuS
Legend

Hi pmccomb,

take a look at the docs about the fill_summary_index.py script, which can be used to add new event into summary index.

hope this helps ...

cheers, MuS

pmccomb
Explorer

Thanks. Yes. I think that will work.

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Community Content Calendar, September edition

Welcome to another insightful post from our Community Content Calendar! We're thrilled to continue bringing ...

Splunkbase Unveils New App Listing Management Public Preview

Splunkbase Unveils New App Listing Management Public PreviewWe're thrilled to announce the public preview of ...

Leveraging Automated Threat Analysis Across the Splunk Ecosystem

Are you leveraging automation to its fullest potential in your threat detection strategy?Our upcoming Security ...