Splunk Search

What can be done when there is no date in the event?

Motivator

We have cases in which there is no date in the log files, meaning, only the time of the event is in the data. What can we do in such cases?

Tags (1)
0 Karma

SplunkTrust
SplunkTrust

In those cases, put DATETIME_CONFIG = current in the props.conf stanza for the sourcetype.

---
If this reply helps you, an upvote would be appreciated.

Ultra Champion

If you are indexing the files as they are written (as opposed to batch or historic imports) Splunk will 'assume' that the date is "today"(actually, it will assume the date is the same as the log modification date or the date on which is its indexed)

This can be problematic in the few seconds around midnight, so it is not ideal.

Unless there is some other field you can get the date from (maybe the filename eg 01012020.log) Then realistically your options are:
Fix the app/logs
Accept midnight glitches

If my comment helps, please give it a thumbs up!

Motivator

-- If you are indexing the files as they are written Splunk will 'assume' that the date is "today"

That's great

We also need to index original historic imports - what can we do there?

0 Karma

Ultra Champion

Thats harder.
If you look at a historic log line, is there anyway to figure out what date it was generated?
Do the filenames contain dates?

If my comment helps, please give it a thumbs up!
0 Karma

Motivator

-- Do the filenames contain dates?

They do!

0 Karma

Ultra Champion

Ahh - you maybe ok then:
See here:
https://docs.splunk.com/Documentation/Splunk/8.0.1/Data/HowSplunkextractstimestamps

If my comment helps, please give it a thumbs up!
0 Karma

Communicator

Are these in Splunk logs or a specific application? I am assuming you will need to address the issue with the specific application's logging functionality to ensure full timestamps are being recorded that include time AND date of events.

0 Karma

Motivator

These are specific application logs and the app team can't provide the date in the data.

0 Karma
Don’t Miss Global Splunk
User Groups Week!

Free LIVE events worldwide 2/8-2/12
Connect, learn, and collect rad prizes
and swag!