Splunk Search

Pulling multiple Columns from an inputlookup

dbturner
New Member

Trying to pull more than one column from an inputlookup. One of the columns maps to a field in the index I am searching in and the other I just want in as a category to table with. Struggling with how I would do that.

This is my current search and added subsearch:
index=myindex [| inputlookup my.csv | fields ip | rename ip as asset_ip] - I want to bring in a column named system from the lookup but don't need to rename it to fit into the index. I just want to make sure the system id in the lookup matches up to the appropriate ip for charting/tabling.

0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

I think you may need to use the lookup twice.

index=myindex [| inputlookup my.csv | fields ip | rename ip as asset_ip] | lookup my.csv ip as asset_ip output system
---
If this reply helps you, Karma would be appreciated.

View solution in original post

0 Karma

richgalloway
SplunkTrust
SplunkTrust

I think you may need to use the lookup twice.

index=myindex [| inputlookup my.csv | fields ip | rename ip as asset_ip] | lookup my.csv ip as asset_ip output system
---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Demo Day: Strengthen Your SOC with Splunk Enterprise Security 8.1

Today’s threat landscape is more complex than ever. Security operation centers (SOCs) are overwhelmed with ...

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...