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!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...