[checkmk-commits] [Checkmk/checkmk] 757dcf: 15976 FIX mssql_backup: Correct timezone differenc...

Branch: refs/heads/master Home: https://github.com/Checkmk/checkmk Commit: 757dcf9ed7c0441ffc07444df233f11c1f2b4ec5 https://github.com/Checkmk/checkmk/commit/757dcf9ed7c0441ffc07444df233f11c1… Author: Rebekka Seltmann <rebekka.seltmann(a)checkmk.com> Date: 2023-11-20 (Mon, 20 Nov 2023) Changed paths: A .werks/15976 M agents/windows/plugins/mssql.vbs M cmk/base/plugins/agent_based/mssql_backup.py M tests/unit/cmk/base/plugins/agent_based/test_mssql_backup.py Log Message: ----------- 15976 FIX mssql_backup: Correct timezone difference for last backup date This werk is relevant for users monitoring the age of the last backup time of mssql databases in different timezones. The date/time of the last backup of a mssql database is currently stored in local host time without the information about the host timezone. When this time is used to check the age of the last backup, it is interpreted in the Checkmk server timezone. When using different timezones, this leads to incorrect values for "Age of last database backup" and if the age is negative, in newer Checkmk versions to the warning "Cannot reasonably calculate time since last backup (hosts time running ahead)". The mssql agent plugin will now store the time in UTC and the mssql_backup check will interpret the time accordingly. You will need to update the agent plugin mssql.vbs to receive the corrected times. SUP-14924 SUP-15900 SUP-15976 Co-authored-by: Benedikt Seidl <benedikt.seidl(a)checkmk.com> Change-Id: I6e6e9192632d1f35ff1516b6a3f123b74fb4cd89