Splunk Search

Autolookup strangeness - 2 fields not returning - several others are - explicit inline lookup works - what should I look at?

snoobzilla
Builder

So I have a couple of chained auto lookups. For some reason 2 fields in the second lookup are not returning when all the others are. Only 1 input value for second lookup. All values in lookup are non-null. Explicit inline lookup of same fields works. They happen to be named COMMENT and Client_Impact.

Anyone have any similar experiences or wisdom to share? Are there character/formatting issues I should look for?

Ideas and feedback appreciated.

Thinking maybe it was a hidden/bad character issue, I went through and retyped the values for Client_Impact and reuploaded using sideview lookup updater.

I am going to try deleting and recreating the lookup file.

Tags (2)
0 Karma
1 Solution

snoobzilla
Builder

Lesson learned... look for competing lookups.

I found a competing old global autolookup conflict which was causing the issue. It explicitly called those fields as output and did not have values in the lookup it was referencing. When this was removed the issue was addressed.

Thanks for the feedback.

View solution in original post

0 Karma

snoobzilla
Builder

Lesson learned... look for competing lookups.

I found a competing old global autolookup conflict which was causing the issue. It explicitly called those fields as output and did not have values in the lookup it was referencing. When this was removed the issue was addressed.

Thanks for the feedback.

0 Karma

snoobzilla
Builder

Is this what you are looking for?

Autolookup - servicelog : LOOKUP-FIXIT2_METADATA_AUTO

FIXIT2_METADATA KER OUTPUT APR APR_STATUS ASKIT CALLS_VIS COMMENT Call_Tip Cause_Type Client_Impact DEFECT INC PRB

All the other fields work except for COMMENT and Client_Impact.

0 Karma

rsennett_splunk
Splunk Employee
Splunk Employee

It's possible that you can see the settings but not alter them.
Click Settings (upper right hand corner of GUI) and see if "lookups" is present on the left hand side.
Then EDIT your answer and add the definition.

With Splunk... the answer is always "YES!". It just might require more regex than you're prepared for!
0 Karma

snoobzilla
Builder

I am not an admin. I don't know if I have access or if I do how to get there. Will get with my splunk admin unless there is a way to get there from web interface.

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

Do post the LOOKUP-foo lines from props.conf.

0 Karma
Get Updates on the Splunk Community!

Introducing Splunk Enterprise 9.2

WATCH HERE! Watch this Tech Talk to learn about the latest features and enhancements shipped in the new Splunk ...

Adoption of RUM and APM at Splunk

    Unleash the power of Splunk Observability   Watch Now In this can't miss Tech Talk! The Splunk Growth ...

Routing logs with Splunk OTel Collector for Kubernetes

The Splunk Distribution of the OpenTelemetry (OTel) Collector is a product that provides a way to ingest ...