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
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Defend at Machine Speed: Your Guide to Security Sessions at .conf26

Splunk .conf26   With threats moving at machine speed and attack surfaces expanding across hybrid ...

Where Innovation Takes Flight: The Splunk4Aviation Flight Sim Lands at .conf26

If you hear someone at .conf26 shouting "gear down, GEAR DOWN" across the show floor, you have found us.  The ...

Turn Cisco Telemetry Into Action with Cisco Data Fabric, powered by the Splunk ...

The surge in machine data is already hitting enterprise budgets, and the agentic era will only intensify it. ...