Monitoring Splunk

Lookup Table vs Summary Index

Sriram
Communicator

I want to create a summary index using a scheduled daily saved search and use in the dashboard view.I can accomplish this using a scheduled daily saved search and create a lookup table as well.In terms of performance, which one is preferable.

For eg.
I have a scheduled search which either build a summary index daily or build a lookup table daily.
Prior to that, I want to wreck and rebuild the summary index and lookup table daily as well.

Using Summary Index
index=cc_user_summary source=list_users | fields costCenter, displayName, userUid

Using Lookup table
| inputlookup userlist.csv | fields costCenter, displayName, userUid

0 Karma

gkanapathy
Splunk Employee
Splunk Employee

Use the lookup table.

0 Karma
Get Updates on the Splunk Community!

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

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 ...