All Apps and Add-ons

Using dbconect2, how do I reindex data in a day in the pass without reindexing current data

phamxuantung
Communicator

Hello,

We have a dbinput that pull in data from an Oracle database. Yesterday, there was some problems with our indexer so we lost a bit of data in that time. I know that I can change the rising checkpoint value to yesterday but it will reindex data till that point to now.

I want to know are there any other way to reindex those missing data in the pass without delete it all?

Edit: I try the delete and reindex all by changing the tail_rising_column_checkpoint_value to the epoch time in the pass but when it's start it only start indexing from the point that I refresh please help

Labels (2)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

How do you index the entries? Is this a scheduled report with collect or something like that? If so, you may need to modify the report to make it idempotent by checking with the existing entries from the index and removing duplicates before collecting the new entries.

I do something similar to this for summary indexes already.

0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud | Unified Identity - Now Available for Existing Splunk ...

Raise your hand if you’ve already forgotten your username or password when logging into an account. (We can’t ...

Index This | How many sides does a circle have?

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

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...