Getting Data In

Backloading events with no year in timestamp

msorenson
Explorer

I have some month old syslog data that I need to load into an indexer, but the timestamp doesn't have the year. Is there a way to force the indexer to leverage the defined month, day and time against the current year? Can this be done through an index time props TIME_FORMAT?

Takajian
Builder

You can refer to following site.

http://docs.splunk.com/Documentation/Splunk/latest/Data/HowSplunkextractstimestamps

Splunk uses the following precedence to assign timestamps to events:

  1. Look for a time or date in the event itself using an explicit TIME_FORMAT if provided.

Use positional timestamp extraction for events that have more than one timestamp value in the raw data.

  1. If no TIME_FORMAT is provided, or no match is found, attempt to automatically identify a time or date in the event itself.

Use positional timestamp extraction for events that have more than one timestamp value in the raw data.

  1. If an event doesn't have a time or date, use the timestamp from the most recent previous event of the same source.

  2. If no events in a source have a date, look in the source (or file) name (Must have time in the event).

  3. For file sources, if no time or date can be identified in the file name, use the modification time on the file.

  4. If no other timestamp is found, set the timestamp to the current system time (at the event's index time).

  5. For file sources, if no time or date can be identified in the file name, use the modification time on the file.

  6. If no other timestamp is found, set the timestamp to the current system time (at the event's index time).

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Community Content Calendar, September edition

Welcome to another insightful post from our Community Content Calendar! We're thrilled to continue bringing ...

Splunkbase Unveils New App Listing Management Public Preview

Splunkbase Unveils New App Listing Management Public PreviewWe're thrilled to announce the public preview of ...

Leveraging Automated Threat Analysis Across the Splunk Ecosystem

Are you leveraging automation to its fullest potential in your threat detection strategy?Our upcoming Security ...