search

hmscott4 / Score

System Center Operational Reporting Environment
GNU General Public License v3.0
2 stars 0 forks source link

Simplify handling of Time Zone information and current time zone offset #2

Closed hmscott4 closed 5 years ago

hmscott4 commented 5 years ago

Current process has a procedure in MonitorSCOM to synch TimeZone data from local computer. Need some way to adjust for UTC data (in database) to local time zone (local to user, not just report server). Options?

  1. There is a table called "TimeZone" in SCOM. Can this be leveraged?
  2. Is it possible to write code into a report that handles timezone changes?
  3. Is it possible to leverage AT TIME ZONE feature in SQL?
hmscott4 commented 5 years ago

Not sure if this counts as simplified. Added a Stored procedure dbo.spCurrentTimeZoneOffsetUpdate. It will update the ConfigValue in dbo.Config for the entry DefaultTimeZoneCurrentOffset.