https://community.splunk.com/t5/Splunk-Search/Update-a-lookup-file-in-realtime/m-p/65251#M16173 <P>I know outputcsv does not update (it should just append to) a lookup table until the search is finalized. Is there any other way this could be done?<BR /> Or is the best way to run a search every couple of minutes and write the csv?</P> <P>Thanks,<BR /> Chris</P> Wed, 19 Sep 2012 20:41:43 GMT chris 2012-09-19T20:41:43Z https://community.splunk.com/t5/Splunk-Search/Update-a-lookup-file-in-realtime/m-p/65251#M16173 <P>I know outputcsv does not update (it should just append to) a lookup table until the search is finalized. Is there any other way this could be done?<BR /> Or is the best way to run a search every couple of minutes and write the csv?</P> <P>Thanks,<BR /> Chris</P> Wed, 19 Sep 2012 20:41:43 GMT https://community.splunk.com/t5/Splunk-Search/Update-a-lookup-file-in-realtime/m-p/65251#M16173 chris 2012-09-19T20:41:43Z https://community.splunk.com/t5/Splunk-Search/Update-a-lookup-file-in-realtime/m-p/65252#M16174 <P>Updating CSV files is an expensive process because they cannot be updated in place. Even if you were able to update the lookup table in real time, due to bundle replication it will still take at least one minute before the lookup table gets to the indexers. </P> <P>There are 3 ways you could update the lookup table <BR /> 1. periodically run the search <BR /> 2. write a custom search command that does what you want <BR /> 3. use the MysqlConnector app, this app offers great lookup update performance </P> Thu, 08 Nov 2012 16:11:40 GMT https://community.splunk.com/t5/Splunk-Search/Update-a-lookup-file-in-realtime/m-p/65252#M16174 Ledion_Bitincka 2012-11-08T16:11:40Z