elastic / elastic/integrations
[Microsoft SQL Server]: Add capability to set timezone for logs dataset
- 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
Assessment
This issue has not been assessed yet.