20 Nov
2023
20 Nov
'23
5:24 a.m.
Branch: refs/heads/2.1.0
Home: https://github.com/Checkmk/checkmk
Commit: 74a37eed03541af7f359b96fc054c6e01ba34152
https://github.com/Checkmk/checkmk/commit/74a37eed03541af7f359b96fc054c6e01…
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 checks/mssql_backup
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
Change-Id: I6e6e9192632d1f35ff1516b6a3f123b74fb4cd89