Splunk Search

How do I join an index with a lookup?

Shashank_87
Explorer

Hi,

I need to join my query with a lookup which contains a field called username. I need to get the users who —

  1. exist in both my main query index and the lookup

  2. exist in lookup but do not exist in the main query index.

This is what my query looks like when i started writing this -

index="prod" sourcetype=prod_events 
| dedup username 
| eval type="MainIndex" 
| eval username = lower(username) 
| fields username type 
| appendpipe 
    [| inputlookup test.csv
    | eval type="lookup" 
    | eval username = lower(username) 
    | sort username
    | fields type username 
        ] 

Any help is appreciated. Many Thanks

0 Karma
1 Solution

Vijeta
Influencer

Add the below code to your search-

|stats dc(type) as dc ,values(type) as type by username | where NOT(dc=1 and type="MainIndex")

View solution in original post

0 Karma

Vijeta
Influencer

Add the below code to your search-

|stats dc(type) as dc ,values(type) as type by username | where NOT(dc=1 and type="MainIndex")
0 Karma
Get Updates on the Splunk Community!

Stay Connected: Your Guide to July and August Tech Talks, Office Hours, and Webinars!

Dive into our sizzling summer lineup for July and August Community Office Hours and Tech Talks. Scroll down to ...

Edge Processor Scaling, Energy & Manufacturing Use Cases, and More New Articles on ...

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

Get More Out of Your Security Practice With a SIEM

Get More Out of Your Security Practice With a SIEMWednesday, July 31, 2024  |  11AM PT / 2PM ETREGISTER ...