Example Report: Complete OS Version/Build of Client

Products

• IT Management Suite

Issue/Introduction

As an IT administrator, I need to have a report that shows the complete OS version/build (e.g. Windows 10.0.18363.1016 (1909)), so that I can quickly and easily determine which devices are running the latest version/build supported by my organization.

As an IT administrator, I need to know how I can decode build version numbers to create my own custom reports. 

The last four (4) digits are also 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

With our ITMS 8.6 RU1 Release, we have added a new feature that should help to collect the necessary information.

Feature: Full operating system version and full operating system build number of the clients.

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, the customer must use the function fnGetComparableVersionAsString to decode the 'OS Comparable version' as we see in Resource Manager (OS Comparable Version (decoded)) screenshot above.

 

Here is an example of an SQL query that is used to show all these fields above in "Resource Manager" for "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