IIS logs and timezone

Guys really sorry if this is a repeat Question. I have searched and read almost all the posts on timezone and iis. but i m not able to fix my issue. I guess i m overthinking :slight_smile: so here is my setup.

windows filebeat sending IIS logs-- logstash -- elastic server.

issue is IIS logs are in UTC . I want them to show up in kibana in CST. so after reading tons of posts this is what i tried .

on filebeat in filebeat.yml i have added
processors:

  • add_locale:
    format: offset

in logstash i have tried 3 options of timezone one by one and none works.

date {
timezone => "-05:00"
# timezone => "US/Central"
# timezone => "America/Chicago"
match => ["log_timestamp", "YYYY-MM-dd HH:mm:ss", "ISO8601"]
target => "@timestamp"
}

so IIS log has

2019-08-13 03:31:37 XX.X.XXX.XX GET

in logstash file out put it shows as 2019-08-13 03:31:37 and @timestamp is of course 2019-08-13 03:31:37.

I want data to be ingested in my elastic as 2019-08-13 03:31:37 -05:00 i.e 2019-08-12 22:31:37.

what am i missing ?

i solved it. Just had to add timezone UTC and that some how has fixed it.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.