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
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

SOC4Kafka - New Kafka Connector Powered by OpenTelemetry

The new SOC4Kafka connector, built on OpenTelemetry, enables the collection of Kafka messages and forwards ...

Rounding off the Splunk Dashboard Contest

What does a contest-winning Splunk dashboard look like? In this case, it isn't in a browser tab at all. It ...

A Four Part Event Series: AI + Observability: AI Agents, LLMs, Apps, & Infrastructure

AI + Observability: AI Agents, LLMs, Apps, & Infrastructure The rapid evolution of artificial intelligence ...