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!

The OpenTelemetry Certified Associate (OTCA) Exam

What’s this OTCA exam? The Linux Foundation offers the OpenTelemetry Certified Associate (OTCA) credential to ...

From Manual to Agentic: Level Up Your SOC at Cisco Live

Welcome to the Era of the Agentic SOC   Are you tired of being a manual alert responder? The security ...

Splunk Classroom Chronicles: Training Tales and Testimonials (Episode 4)

Welcome back to Splunk Classroom Chronicles, our ongoing series where we shine a light on what really happens ...