Monitoring Splunk

time stamp mismatch in csv files

gowtham08091
Explorer

I have a set if CSV files getting created every day, none of the CSV files have any default data or time printed within it, when i index the files i could see the data is getting index with different time stamps over the past date.

I have also used crcSalt=<SOURCE>

Soucettype is CSV and set to Current, 

But all the file has created date and last modified data is the same (example today's date.) but the data gets indexed with different timestamp

gowtham08091_0-1596560357505.png

 

Labels (1)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

Splunk is trying to find timestamp information in those files even if it doesn't exist. If you know your data does not have a timestamp in it you can tell Splunk that by putting 

DATETIME_CONFIG = current

in the appropriate stanza of the props.conf file.  This props file must be installed on the first Splunk instance that parses the data - either a heavy forwarder or an indexer.  Be sure to restart the instance(s) after modifying the file.

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

gowtham08091
Explorer

@richgalloway  Thanks for your quick reply, but I have already configure the current time, but still the same issue

gowtham08091_0-1596561375127.png

 

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!

Build the Future of Agentic AI: Join the Splunk Agentic Ops Hackathon

AI is changing how teams investigate incidents, detect threats, automate workflows, and build intelligent ...

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...