topic Re: How do you adjust time with syslog-ng or universal forwarder for devices in different time zones? in Getting Data In

How do you adjust time with syslog-ng or universal forwarder for devices in different time zones?

oleg106 — Wed, 03 Oct 2018 18:46:46 GMT

Hi,

We are centralizing and collecting logs from various devices via syslog-ng, and sending them to indexers via universal forwarder on the same box. The issue I am running into is that some devices in Asia and other places are on local time zones, so logs are stored in future time.

What's a good way to deal with this without changing the local time zone. Perhaps store log time in another field and convert _time to EST? Just curious if anyone found a good way to deal with this. Thanks in advance!

Re: How do you adjust time with syslog-ng or universal forwarder for devices in different time zones?

somesoni2 — Wed, 03 Oct 2018 19:30:50 GMT

You can specify the timezone to be used in props.conf on the universal forwarder. This can be done for a particular sourcetype, host or source (wildcard supported for host/source). See this for more information.

https://docs.splunk.com/Documentation/Splunk/7.1.3/Data/Applytimezoneoffsetstotimestamps#Specify_time_zones_in_props.conf

Re: How do you adjust time with syslog-ng or universal forwarder for devices in different time zones?

FrankVl — Wed, 03 Oct 2018 20:19:03 GMT

Several options really:

Get your source devices to log in a standard zone (but you already ruled out that option, which is indeed often a difficult thing to achieve).
Get your source devices to report their time zone as part of the event. Really depends on whether or not your source device supports that.
As @somesoni2 mentioned: configure per source type / source / host time zone through props.conf. But with many hosts this can become very hard to manage (depending also on how dynamic the set of source devices is).
Use regional syslog servers, such that the syslog server (and UF) are in same zone as the source device. But I know from experience that even with regional collection points you may still have to deal with exceptions.
Get your syslog daemon to overwrite the original time stamp with a time stamp of when the event was received on the syslog server. Bit of a last resort option as it obviously reduces the accuracy of the time stamp. But it may be a better solution than having to deal with many timezone exceptions.
Configure Splunk to use the file modify time or the index time to populate _time, rather than the time stamp from the event. Same drawbacks as 5.

Re: How do you adjust time with syslog-ng or universal forwarder for devices in different time zones?

TonyLeeVT — Mon, 15 Oct 2018 20:01:53 GMT

Unfortunately, this will not work because the Universal Forwarder will ignore props.conf. Per the link you shared:

"If you have Splunk Enterprise and need to modify timestamp extraction, perform the configuration on your indexer machines or, if forwarding data, use heavy forwarders and perform the configuration on the machines where the heavy forwarders run. If you have Splunk Cloud and need to modify timestamp extraction, use heavy forwarder and perform the configuration on the machines where the heavy forwarders run."