topic Re: forwarder source logs displaying in UTC Time - Need EST in Getting Data In

forwarder source logs displaying in UTC Time - Need EST

bcusick — Tue, 11 Mar 2014 19:34:58 GMT

Hi,

I have a forwarder that goes by EST. My Splunk server also goes by EST. Today I had to add a source (from a completely different server with UTC time) to my EST Splunk forwarder.

How can I make _time for the logs in this source be in EST? They can still display UTC, but I need to see them in EST for Splunk timing.

I have already tried editing the props.conf to say:

[mdm]
TZ = UTC

Where mdm is the sourcetype for this source

Thanks,

Brian

Re: forwarder source logs displaying in UTC Time - Need EST

lukejadamec — Tue, 11 Mar 2014 19:53:04 GMT

Do the event timestamps include a timezone, or is the timestamp an epoch time?
How did you add the new server to the forwarder, and why not add it directly to the indexer?

Re: forwarder source logs displaying in UTC Time - Need EST

bcusick — Tue, 11 Mar 2014 19:59:24 GMT

Timestamp is showing up like this in the raw log...

2014-03-11 18:04:11

basically all I want to do is subtract 4 hours from it. Idk how that would go if the UTC time was between midnight and 3:59AM, but I could use temporarily a method to show this time as EST (4 hours prior to what it says now)

Re: forwarder source logs displaying in UTC Time - Need EST

lukejadamec — Tue, 11 Mar 2014 20:03:46 GMT

You should try to configure splunk to recognize the correct TZ for that source, that way splunk can do all of the search time corrections for you.

As for subtracting 4 hours, not a problem so long as splunk knows it is working with a time.

Re: forwarder source logs displaying in UTC Time - Need EST

bcusick — Mon, 17 Mar 2014 13:03:30 GMT

Somehow this issue has cleared itself up. 🙂

Re: forwarder source logs displaying in UTC Time - Need EST

woodcock — Mon, 29 Jun 2015 01:58:58 GMT

The indexers were probably rebooted which is required for this change to take effect.