Splunk Search

update lookup table with outputcsv

sonicZ
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
1 Solution

bmacias84
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

bmacias84
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

.conf21 Now Fully Virtual!
Register for FREE Today!

We've made .conf21 totally virtual and totally FREE! Our completely online experience will run from 10/19 through 10/20 with some additional events, too!