elastic / elastic/integrations

[Microsoft SQL Server]: Add capability to set timezone for logs dataset

Open
#12,854 2 comments 0 reactions 0 assignees View on GitHub
Integration:microsoft_sqlserver needs:triage Team:Obs-InfraObs
Dominant language
Handlebars
Stars
333
Forks
647
Avg merge
3d 4h
Merged PRs (30d)
209

Description

### Integration Name

Microsoft SQL Server [microsoft_sqlserver]

### Dataset Name

log

### Integration Version

2.9.4

### Agent Version

8.17.2

### OS Version and Architecture

Windows Server

### User Goal

Add the option to set the timezone so that `@timestamp` is displayed correctly in Kibana.

### Existing Features

Other integrations allow for users to set the timezone for the integration

### What did you see?

`event.timezone` is not set when ingesting the error log. When we ingest events the date is in EST timezone but when viewing the events in Kibana they are offset by -5:00. We needed to add a date processor to set the correct timezone.

### Anything else?

_No response_

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.