Splunk Search

How do I get Splunk to recognize the full Date AND Time in the timestamp of this CSV?

jimmitch923
New Member

Event lines look like this
{I5K5-M8HD47HI-6694GOIH},01/02/2010 07:13:39,NLR0174,PC-8272,Connect

Everything I've tried only recognizes the time...but not the date.
TIME_FORMAT = %d/%m/%Y %H:%M:%S
TIME_PREFIX = {.+}\,

Help please!

Tags (1)
0 Karma

Jeremiah
Motivator

Are the dates really that old? You may need to increase MAX_DAYS_AGO. Does it work differently for more recent timestamps?

http://docs.splunk.com/Documentation/Splunk/6.4.2/Admin/Propsconf

MAX_DAYS_AGO = <integer>
* Specifies the maximum number of days past, from the current date, that an
  extracted date can be valid. Splunk still indexes events with dates older
  than MAX_DAYS_AGO with the timestamp of the last acceptable event. If no 
  such acceptable event exists, new events with timestamps older than MAX_DAYS_AGO 
  will use the current timestamp.
* For example, if MAX_DAYS_AGO = 10, Splunk applies the timestamp of the last 
  acceptable event to events with extracted timestamps older than 10 days in 
  the past. If no acceptable event exists, Splunk applies the current timestamp.
* Defaults to 2000 (days), maximum 10951.
* IMPORTANT: If your data is older than 2000 days, increase this setting.
0 Karma

sheron_splunk
Splunk Employee
Splunk Employee

Have you tried using MAX_TIMESTAMP_LOOKAHEAD=19 ?

0 Karma
Get Updates on the Splunk Community!

Detecting Remote Code Executions With the Splunk Threat Research Team

REGISTER NOWRemote code execution (RCE) vulnerabilities pose a significant risk to organizations. If ...

Observability | Use Synthetic Monitoring for Website Metadata Verification

If you are on Splunk Observability Cloud, you may already have Synthetic Monitoringin your observability ...

More Ways To Control Your Costs With Archived Metrics | Register for Tech Talk

Tuesday, May 14, 2024  |  11AM PT / 2PM ET Register to Attend Join us for this Tech Talk and learn how to ...