Splunk Search

How to match search with KV lookup files?

New Member

Hello,
I have a KV file that is auto generated with username using a script running every hour. I want to match the username in the KV file with a different index search. I have written the following query but it is always stuck on "Parsing Job". The index contains a user column. The output should be the username that is common in both user table.

index=abc
| search [| inputlookup Leaver_Lookup.kv | fields "User ID" | rename "User ID" as user | dedup user | table user ]
0 Karma

Champion

Is LOOKUP defined?

| inputlookup <lookup-name> where <eval-expression> | ...

Is this search working?

| inputlookup Leaver_Lookup.kv | fields "User ID" | rename "User ID" as user | dedup user | table user 
0 Karma

New Member

Yes that search works.

0 Karma
Don’t Miss Global Splunk
User Groups Week!

Free LIVE events worldwide 2/8-2/12
Connect, learn, and collect rad prizes and swag!