Splunk Search

Does the header sequence in a csv file for lookuptable matter?

Starlette
Contributor

Is there a rule for sequence of the header field in csv lookuptables?

Lets say i have a csv header

status,status_description,status_type
100,Continue,Informational
101,Switching Protocols,Informational
200,OK,Successful

In this example the status is a splunk event field, but are you restricted to this sequence?
lets say as below :

status_type,status,status_description
Informational,100,Continue
Informational,101,Switching Protocols
Successful,200,OK,
Tags (2)
0 Karma

mslvrstn
Communicator

No, the order of the fields does not matter.
It's just important that the columns are consistent with the header.

mslvrstn
Communicator

Do the events that match "searchstring" correspond to the sourcetype you have configured for the autolookup, and do those events already have one of the fields listed in the header? That's what it needs to fill out the rest of the field/values.

0 Karma

Starlette
Contributor

When configurating this in props.conf, transforms.conf (autolookup, on all fields)
Must you expect a return on all relevant events / lookup fields ( for this example) as :

"searchstring"

no results for status_description

But got results when defining detailed results like

sourcetype=blabla status=100

0 Karma
Get Updates on the Splunk Community!

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...

Introducing the 2024 Splunk MVPs!

We are excited to announce the 2024 cohort of the Splunk MVP program. Splunk MVPs are passionate members of ...

Splunk Custom Visualizations App End of Life

The Splunk Custom Visualizations apps End of Life for SimpleXML will reach end of support on Dec 21, 2024, ...