Solved: Re: How to search and compare the same data across...

dteo827 · ‎01-06-2016

Greetings Splunk Answers,
I have 4 CSV's containing similar data (usernames, first/last names, job roles) all of which I have imported into individual KV Stores (and separate collections).
I need to search a username and see if it is any/all of the KV Stores.

Does anyone have experience searching across multiple KV Stores for the same data?

Cheers!

renjith_nair · ‎01-06-2016

Try

| inputlookup kv1 | inputlookup append=t kv2 | inputlookup append=t kv3 | inputlookup append=t kv4|search username=<username_to_search>

http://docs.splunk.com/Documentation/Splunk/6.2.0/SearchReference/Inputlookup

---
What goes around comes around. If it helps, hit it with Karma 🙂

View solution in original post

renjith_nair · ‎01-06-2016

Try

| inputlookup kv1 | inputlookup append=t kv2 | inputlookup append=t kv3 | inputlookup append=t kv4|search username=<username_to_search>

http://docs.splunk.com/Documentation/Splunk/6.2.0/SearchReference/Inputlookup

---
What goes around comes around. If it helps, hit it with Karma 🙂

dteo827 · ‎01-06-2016

Many thanks, I somehow missed that in the documentation.

How to search and compare the same data across multiple KV stores?

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Why Splunk Customers Should Attend Cisco Live 2026 Las Vegas

What Is the Name of the USB Key Inserted by Bob Smith? (BOTS Hint, Not the Answer)

Automating Threat Operations and Threat Hunting with Recorded Future

Join the Conversation