Getting Data In

timezone issue

ofeefee
New Member

how come if I set the timezone to CST, logs sent with UTC timestamp doesn't get put in CST, they appear to stay as UTC, but then logs without a timestamp get tagged CST. So then I have some logs in CST, some in UTC, so when trying to correlate these, it's a mess! I figured if it was all CST, it would keep them all as Central time, and convert the times.

Tags (1)
0 Karma

ofeefee
New Member

i think this is one of those restrictions that splunkstorm has. if you have data coming in from different timezones you have to put them in seperate projects. Problem is hafl the data is tagged with the timezone data, the other has no timezone data, so it's getting split. I solved it by setting Splunkstorm to UTC, and it's all syncing up now. I just have to do the time shift mentally, not too difficult after this many years.

0 Karma

aholzer
Motivator

I am assuming you mean setting the timezone in the props.conf, as so:

[YourSourcetype]
...
TZ=YourTimezone

If this is the case, then the timezone you want to specify here is the timezone of the events being written to those logs that are being tagged with "YourSourcetype". Example: logInEST.log is being generated on an EST server, monitored by a forwarder and tagged as ESTST (EST SourceType). The props.conf on the indexer, which is a London based server, should be something like this:

[ESTST]
...
TZ=US/Eastern

So when you run a search that captures ESTST, it will convert everything from the US/Eastern to the local time of the indexer.

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!

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...

[Puzzles] Solve, Learn, Repeat: Matching cron expressions

This puzzle (first published here) is based on matching timestamps to cron expressions.All the timestamps ...