Getting Data In

forwarder source logs displaying in UTC Time - Need EST

bcusick
Communicator

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

0 Karma

woodcock
Esteemed Legend

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

0 Karma

bcusick
Communicator

Somehow this issue has cleared itself up. 🙂

0 Karma

lukejadamec
Super Champion

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.

0 Karma

bcusick
Communicator

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)

0 Karma

lukejadamec
Super Champion

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?

0 Karma
Get Updates on the Splunk Community!

Community Content Calendar, November Edition

Welcome to the November edition of our Community Spotlight! Each month, we dive into the Splunk Community to ...

October Community Champions: A Shoutout to Our Contributors!

As October comes to a close, we want to take a moment to celebrate the people who make the Splunk Community ...

Stay Connected: Your Guide to November Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...