Microsoft SQL Server version is not reported accurately in Database System data class after applying a SQL Cumulative Update

Products

• IT Management Suite
• Inventory Solution

Issue/Introduction

Microsoft SQL Server version is not reported accurately in Database System data class after applying a SQL Cumulative Update.

It seems that WMI may have incorrect value. i.e:

select @@version returns 'Microsoft SQL Server 2022 (RTM-CU16) (KB5048033) - 16.0.4165.4 (X64)   Nov  6 2024 19:24:49   Copyright (C) 2022 Microsoft Corporation  Enterprise Edition (64-bit) on Windows Server 2022 Standard 10.0 <X64> (Build 20348: ) (Hypervisor) '

WMI returns 16.0.1000.6
Inv_Database_System.Verison returns SQL Server 2022 RTM Enterprise Edition x64 16.0.1000.6

So WMI has RTM verison only and not version of applied CU:

 

It seems that WMI's SqlServiceAdvancedProperty and related classes focus on service management and do not expose version details. 

Environment

ITMS 8.7.2, 8.7.3

Cause

Known issue. We needed to fix "Inv Srv Database System" dataclass and we added "Inv Srv Database Logins" and "Inv Srv Database Linked Servers" dataclasses.

Resolution

This issue has been fixed in our ITMS 8.8 Release.

Also, under "Microsoft SQL Server inventory enhancements":

"Added collection of Microsoft SQL Linked Servers - data is stored in the new MS SQL Linked Servers data class. Added collection of Microsoft SQL Server logins - data is stored in the new MS SQL Server Logins data class."