Getting Data In
Highlighted

Can I have different timestamp formats using the same sourcetype?

Communicator

Indexing a lot of SystemOut.log files from WebSphere I realize that all almost all log files uses the following time format

TIME_FORMAT = %m/%d/%y %H:%M:%S%3N %Z

But on some old servers the format is

TIME_FORMAT = %d/%m/%y %H:%M:%S%3N %Z

Is it possible for to use two formats for the same sourcetype? Or as an alternative can I create a "child sourcetype" with no other changes than the time_format?

Tags (2)
Highlighted

Re: Can I have different timestamp formats using the same sourcetype?

I don't know if this works in your usecase. But you should be able to use a custom datetime.xml to solve this. Take a look at this: http://answers.splunk.com/answers/1807/2-different-timestamps-in-single-log

Highlighted

Re: Can I have different timestamp formats using the same sourcetype?

Influencer
Highlighted

Re: Can I have different timestamp formats using the same sourcetype?

Communicator

For Windows users, worth noticing how to correctly define path to custom datetime.xml escaping backslashes. Took some time before I figured that one out (use double backslashes, it does not show here)

DATETIME_CONFIG = \\etc\\apps\\myapp\\local\\datetime.xml

0 Karma