Splunk Search

Issue with date and time for indexed csv data

darshini2790
Explorer

I am facing date time issue while indexing csv data .
I do have a date field in my CSV file but i want to consider system time for an indexed data. I have added below parameters into props.conf of windows UF and on single instance linux splunk server $splunk home$/etc/system/local props.conf but still it is taking date/ time from the csv file.
Please suggest.

DATETIME_CONFIG = NONE
MAX_TIMESTAMP_LOOKAHEAD = 0

Tags (1)
0 Karma
1 Solution

skalliger
Motivator

Hi,

  1. MAX_TIMESTAMP_LOOKAHEAD should not be set to 0.
  2. DATETIME_CONFIG should not be set to "none" in your case.
  3. Did you set KV_MODE = none on your Search Head? The question is, if you want indexed extractions or not.

Skalli

View solution in original post

skalliger
Motivator

Hi,

  1. MAX_TIMESTAMP_LOOKAHEAD should not be set to 0.
  2. DATETIME_CONFIG should not be set to "none" in your case.
  3. Did you set KV_MODE = none on your Search Head? The question is, if you want indexed extractions or not.

Skalli

niketn
Legend

@darshini2790 if you are planning to use current time, should you not be using?

   DATETIME_CONFIG = CURRENT 
____________________________________________
| makeresults | eval message= "Happy Splunking!!!"

darshini2790
Explorer

Yes I have tried that as well and no luck.

0 Karma
Get Updates on the Splunk Community!

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...