The customer noticed that some client machines are changing the OS version. For example, from "Windows Server 2019" to "Unknown Windows" and then back to "Microsoft Server 2019".
This caused issues where filters or targets based on specific OS versions will not contain the right set of machines.
Is there a way to track such OS version changes?
ITMS 8.5, 8.6
Network Discovery, Connector Solution Import, and AD Import may cause overwriting of the current OS version.
We base this information from "Inv_Aex_AC_Identification" table. For example, the default "Windows Servers" uses a query like this:
SELECT cr.[Guid] AS [_ResourceGuid]
FROM vComputerResource AS cr
JOIN Inv_AeX_AC_Identification AS id ON id._ResourceGuid = cr.[Guid]
CROSS APPLY dbo.fnSysMask_IsWindowsServerAsTable(id.[OS System Mask], 18, 36, 0) tt -- Win, Server 2000-2022 (with Hyper-V)
WHERE cr.IsManaged = 1