Getting Data In

How to convert the timestamp from ETC TO GMT?

vrmandadi
Builder

I have a source that sends data at UTC timezone but when coming into Splunk it comes as EST.How can I convert indexed data in GMT and run searches in GMT timezone

Sample events -with timestamp

19 Mar 2019 08:47:20,409 [INFO] (StreamHandler)  private.com.amazonaws.services.datapipeline.runner.ApplicationRunner: [ERROR] 2019-03-19 08:47:20.409 [main] EdwEntryProgram$ - [EDH-Application-Exception] - Job ID 1068 FAILED

Sample event-without TIMESTAMP

[EDH-Application-Exception] - Job ID EDM_PRODUCT_AVAILABILITY failed at edm_datapipeline_status_check lambda function or datapipeline is in failed state.
0 Karma

richgalloway
SplunkTrust
SplunkTrust

Click on your name at the top of the Splunk UI and select "Preferences". Choose "GMT" from the Time Zone dropdown and click Apply. You will now see times in GMT/UTC.

---
If this reply helps you, Karma would be appreciated.
0 Karma

vrmandadi
Builder

I did that one , The sample event which has timestamp is GMT timestamp but when coming into Splunk it is coming in as EST

0 Karma

bcyates
Communicator

GMT and UTC are the same thing, are they not?

0 Karma

vrmandadi
Builder

I am sorry for the confusion.Yes they are same I want to convert them to gmt

0 Karma
Get Updates on the Splunk Community!

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Wednesday, May 29, 2024  |  11AM PST / 2PM ESTRegister now and join us to learn more about how you can ...

Get Your Exclusive Splunk Certified Cybersecurity Defense Engineer at Splunk .conf24 ...

We’re excited to announce a new Splunk certification exam being released at .conf24! If you’re headed to Vegas ...

Share Your Ideas & Meet the Lantern team at .Conf! Plus All of This Month’s New ...

Splunk Lantern is Splunk’s customer success center that provides advice from Splunk experts on valuable data ...