Example Report: Complete OS Version/Build of Client

Products

• IT Management Suite

Issue/Introduction

You need to have a report that shows the complete OS version/build (e.g. Windows 10.0.18363.1016 (1909)), so that you can quickly and easily determine which devices are running the latest version/build supported for your organization.

You also need to know how to decode build version numbers to create your own custom reports. 

NOTE: The last four (4) digits of the version are called the UBR (Update Build Revision) which is stored in the Registry: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\

Environment

ITMS 8.6 RU1+

Resolution

In the ITMS 8.6 RU1 Release there was a new feature added that should help to collect the necessary information.

Feature: Inventory Solution now collects the full operating system version and full operating system build number of all managed machines.

Description: The AeX AC Identification page in Resource Manager now shows the full operating system version and full operating system build number. You can also add this data to your customized reports:

 

For custom reports, you must use the function fnGetComparableVersionAsString to decode the 'OS Comparable version' as you can see in Resource Manager (OS Comparable Version (decoded)) in the screenshot above.

Here is an example of a SQL query that is used to show all of these fields seen above in "Resource Manager" for the "Inv_Aex_AC_Identification" SQL table:

SELECT
c.[GUID],
c.[Name],
c.[Domain],
c.[System Type],
c.[OS Name],
c.[OS Type],
c.[OS Version],
c.[OS Revision],
c.[Last Logon User],
c.[Last Logon Domain],
c.[Client Date],
c.[OS Major Version],
c.[OS Minor Version],
c.[OS Build Number],
c.[OS Primary Language],
c.[OS Sub Language],
c.[User Primary Language],
c.[User Sub Language],
c.[Install Primary Language],
c.[Install Sub Language],
c.[FQDN],
c.[Unique ID],
c.[Timezone Bias],
c.[Hardware Serial Number],
c.[BIOS Serial Number],
c.[HW Chassis Serial Number],
CASE WHEN c.[OS System Mask] IS NULL THEN '' ELSE dbo.fnBinToChar(c.[OS System Mask]) END AS 'OS System Mask (HEX)',
CASE WHEN c.[OS System Mask] IS NULL THEN '' ELSE dbo.fnSysMask_GetPlatformName (c.[OS System Mask]) END AS 'OS System Mask - Platform',
CASE WHEN c.[OS System Mask] IS NULL THEN '' ELSE dbo.fnSysMask_GetTypeName (c.[OS System Mask]) END AS 'OS System Mask - Type',
CASE WHEN c.[OS System Mask] IS NULL THEN '' ELSE dbo.fnSysMask_GetOSNumberNameEx2 (c.[OS System Mask], c.[DisplayVersion]) END AS 'OS System Mask - OS Name',
CASE WHEN c.[OS System Mask] IS NULL THEN '' ELSE dbo.fnSysMask_GetHWPlatformName (c.[OS System Mask]) END AS 'OS System Mask - Hardware Platform',
CASE WHEN c.[OS System Mask] IS NULL THEN '' ELSE dbo.fnSysMask_GetArchitectureName (c.[OS System Mask]) END AS 'OS System Mask - Processor Architecture',
CASE WHEN c.[OS System Mask] IS NULL THEN '' ELSE dbo.fnSysMask_GetTagFlagsName (c.[OS System Mask]) END AS 'OS System Mask - Tag Flags',
CASE WHEN c.[OS System Mask] IS NULL THEN '' ELSE dbo.fnSysMask_GetServicePackName (c.[OS System Mask]) END AS 'OS System Mask - Service Pack',
CASE WHEN c.[OS System Mask] IS NULL THEN '' ELSE dbo.fnSysMask_GetOSEditionName (c.[OS System Mask]) END AS 'OS System Mask - OS Edition',
CASE WHEN c.[OS Comparable Version] IS NULL THEN '' ELSE dbo.fnBinToChar(c.[OS Comparable Version]) END AS 'OS Comparable Version (HEX)',
CASE WHEN c.[OS Comparable Version] IS NULL THEN '' ELSE dbo.fnGetComparableVersionAsString(c.[OS Comparable Version]) END AS 'OS Comparable Version (decoded)',
c.[OS Canonical Name]
FROM Inv_AeX_AC_Identification c


Additional Information

Please also see KB 231798 - Complete OS Version/Build of Client