Database insert issue

[BoschmanIT]

Hi Support,

We have a issue with inserting HM log data into our database. So we used to use the following insert query:

INSERT INTO IT_Internal.DBO.HMLOG
(TESTID, TESTNAME, STATUS, REPLY, EVENTTIME, RECURRENCES, TESTMETHOD)
VALUES
('%TestID%', '%TestName%', '%Status%', '%Reply%', '%DateTime%', '%Recurrences%', '%TestMethod%');

This was working just fine until the end of april. Now this insert query tells me he cannot convert to the right datetime output the database needs. We compared, and in april the datetime was inserted like 2025-05-15 12:00:00.000 but now it want to insert it like 15/may/2025 12:00:00 which the database does not seem to be able to convert.
Im not sure if/when something has changed in our environment. Is there a way to let Hostmonitor insert the datetime information like before?

[KS-Soft]

Yes, I think you changed date format somehow.
May be you changed regional settings for account used by HostMonitor.
May be you changed account used by HostMonitor process (logged on as different user with different regional settings).
May be account used by HostMonitor service was locked/disabled so HostMonitor service now runs under local system account.
May be you are using "Use fixed date&time format" option and changed date format using settings located in the Options dialog, Misc page

Regards
Alex

[BoschmanIT]

Hi Alex,

So Hostmonitor follows the date time settings used by the user account that runs the hostmonitor service?

[BoschmanIT]

Ahh yeah so I found in hostmonitor the check for fixed date and time was set. I unset it so now its working again. thank you for this.

[KS-Soft]

You are welcome

Regards
Alex