Splunk Search
Highlighted

update lookup table with outputcsv

Contributor

I would like to update an existing app lookup table with static known fields instead of search results, for example my lookup table just has

ip, dns, country

Something like this search should work with some tweaking i suppose?

 | inputcsv append=true edge_lookup.csv | eval dns=somehost.somedomain.com | eval ip="199.156.128.1" | eval country=mexico | outputcsv  edge_lookup.csv

I have the syntax wrong though.
Also It seems like it's trying to write to var/run/splunk though on the search head, is there a way to rewrite the existing app lookup table?

Thanks

0 Karma
Highlighted

Re: update lookup table with outputcsv

Champion

If I understand your question. You will want to create a saved search under the context of the app in question. Also take a look at my other post updating-lookup-table-data-externally-auto-magically.

Hope this helps.

View solution in original post