Deployment Architecture

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

ankithreddy777
Contributor

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.

Tags (1)
0 Karma

woodcock
Esteemed Legend

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

0 Karma

gcusello
SplunkTrust
SplunkTrust

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

0 Karma

ankithreddy777
Contributor

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

0 Karma

gcusello
SplunkTrust
SplunkTrust

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

0 Karma
Get Updates on the Splunk Community!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

Splunk is officially part of Cisco

Revolutionizing how our customers build resilience across their entire digital footprint.   Splunk ...

Splunk APM & RUM | Planned Maintenance March 26 - March 28, 2024

There will be planned maintenance for Splunk APM and RUM between March 26, 2024 and March 28, 2024 as ...