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!

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...

Think Like an Architect: Introducing the Splunk Certified Cybersecurity Defense ...

In cybersecurity, defenders respond to threats. Architects design the systems that stop them.    As ...

Best Practices: Splunk auto adjust pipeline queue

When you enable autoAdjustQueue in Splunk, maxSize should be understood as the queue size Splunk starts with ...