Deployment Architecture

How to find time range and 1st and last event indexed in warm bucket events?

aatik5u
Path Finder

Hello,

I have a corrupted warm bucket. What I am trying to do is to find out is the time interval of the events stored in this bucket. I found the file buckt_info.csv where I have _indextime_et that I assume is indextime earliest which means the time the 1st event of the bucket was indexed, right?

how can I find the time range of events in a bucket? in other words, is there a way to find the 1st event indexed in a backet and the last one?

any help will be appreciated.

thank you 🙂 

Labels (1)
Tags (3)
0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

If you have the name of the bucket then you have the time range.  Bucket names are in the form db_<latest time>_<earliest time>_<id> with variations for indexer clusters.  The key parts for this situation are <latest time> and <earliest time>, which are in epoch form.  Copy these values into a converter (I like https://www.epochconverter.com/) to see values in a more readable format.

---
If this reply helps you, Karma would be appreciated.

View solution in original post

aatik5u
Path Finder

thank you @johnhuang @richgalloway really appreciate it !

0 Karma

johnhuang
Motivator

dbinspect will give you all the info you need about buckets;

 

| dbinspect index=<index_name>

 

https://docs.splunk.com/Documentation/Splunk/9.0.1/SearchReference/Dbinspect

 

richgalloway
SplunkTrust
SplunkTrust

If you have the name of the bucket then you have the time range.  Bucket names are in the form db_<latest time>_<earliest time>_<id> with variations for indexer clusters.  The key parts for this situation are <latest time> and <earliest time>, which are in epoch form.  Copy these values into a converter (I like https://www.epochconverter.com/) to see values in a more readable format.

---
If this reply helps you, Karma would be appreciated.
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

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

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...