Delete database results and update with new results for every execution from splunk db

[ankithreddy777]

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.

[woodcock]

DB Connect V3 supports stored procedures. I would upgrade and create a stored procedure in the DB itself to handle this.

[gcusello]

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

[ankithreddy777]

Hi cusello,
can we delete rows in database by creating database input and update all results by creating database output mapping to search results?.

[gcusello]

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