topic Re: Is Splunk able to automatically offset timestamps at indextime when TZ is embedded in the event? in Getting Data In

Is Splunk able to automatically offset timestamps at indextime when TZ is embedded in the event?

the_wolverine — Tue, 26 Feb 2013 21:40:32 GMT

Would this be automatic or would additional TZ configuration need to be set in order for this to work?

Re: Is Splunk able to automatically offset timestamps at indextime when TZ is embedded in the event?

jbsplunk — Tue, 26 Feb 2013 21:58:08 GMT

The answer in short is No. If TZ is embedded into the event, the Indexer will trust the embedded TZ explicitly and ignore any instructions that are given regarding timestamp in props.conf, irrespective of variance.

Re: Is Splunk able to automatically offset timestamps at indextime when TZ is embedded in the event?

jrodman — Tue, 26 Feb 2013 23:15:43 GMT

The longer answer is that Splunk may not automatically recognize the TZ offset expression. If you're using a common pattern, Splunk should recognize it, but if it's less common you may need a TIME_FORMAT to specify where the offset is located.

Re: Is Splunk able to automatically offset timestamps at indextime when TZ is embedded in the event?

the_wolverine — Wed, 27 Feb 2013 19:21:54 GMT

I just care about the added workload of having to process a TZ at all vs having the event use GMT (or the same TZ as my indexer.) Sounds like there is no added "load" with an embedded TZ.

Re: Is Splunk able to automatically offset timestamps at indextime when TZ is embedded in the event?

woodcock — Mon, 29 Jun 2015 03:40:37 GMT

There is only 1 way to override an in-event TZ setting and that is with TZ_ALIAS; read about it here:

http://docs.splunk.com/Documentation/Splunk/latest/Admin/Propsconf

Re: Is Splunk able to automatically offset timestamps at indextime when TZ is embedded in the event?

woodcock — Tue, 07 Jul 2015 05:02:46 GMT

This is incorrect; you can use TZ_ALIAS to override in-event TZ values (see my answer).

Re: Is Splunk able to automatically offset timestamps at indextime when TZ is embedded in the event?

alacercogitatus — Tue, 07 Jul 2015 12:49:56 GMT

Actually, @jbsplunk is correct. The timestamp on this question was from Feb 26, 2013. At the time, Splunk 4.3 was the de-facto version, Splunk 5 would be released during .conf2013. So according to the correct documentation, http://docs.splunk.com/Documentation/Splunk/4.3.6/admin/Propsconf, the TZ option was the only option. TZ_ALIAS wasn't an option until Splunk 6.0.

Re: Is Splunk able to automatically offset timestamps at indextime when TZ is embedded in the event?

alacercogitatus — Tue, 07 Jul 2015 18:39:19 GMT

This would be correct for version 6.X.