Splunk Search

How to query an automatic lookup

luna
Explorer

Hi Guys,

 

How can I query an automatic lookup? Now, this is not the fields created through  an automatic lookup, but the name given to the automatic lookup.

 

my automatic lookup is src_top_sales_by_model

I have tried:

index=blah model=* | stats values(src_top_sales_by_model) 

the dilemma, I have two different automatic lookups and they both have the same field name but different values

so I was thinking of just querying the automatic lookups names given to then find the values. 

Is this even possible?

 

Labels (3)
0 Karma
1 Solution

scelikok
SplunkTrust
SplunkTrust

Hi @luna,

Unfortunately you cannot get the lookup name that outputs values. You can edit your automatic lookup definitions to output different fieldnames to understand which one hit. 

If your lookup files has the same fields as output, you can alias them on automatic lookup definition using AS setting.

If this reply helps you an upvote and "Accept as Solution" is appreciated.

View solution in original post

0 Karma

scelikok
SplunkTrust
SplunkTrust

Hi @luna,

Unfortunately you cannot get the lookup name that outputs values. You can edit your automatic lookup definitions to output different fieldnames to understand which one hit. 

If your lookup files has the same fields as output, you can alias them on automatic lookup definition using AS setting.

If this reply helps you an upvote and "Accept as Solution" is appreciated.
0 Karma
Get Updates on the Splunk Community!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...