How to send all results to the database for every execution Instead of only new results using using splunk db database output . Can we delete results in database from database input. My requirement is I have to update the database with the new results everytime replacing the old results.
DB Connect V3 supports stored procedures. I would upgrade and create a stored procedure in the DB itself to handle this.
Hi ankithreddy777,
I don't like very much this solution, but I think that the only way is to schedule a delete procedure before uploading from Splunk.
Bye.
Giuseppe
Hi cusello,
can we delete rows in database by creating database input and update all results by creating database output mapping to search results?.
By DB Connect you can run a query, but remember that the user you use in DB Connect must be enabled to delete, and it isn't an usual configuration (not secure!)!
Bye.
Giuseppe