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.

Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...