ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Example Report: Complete OS Version/Build of Client

book

Article ID: 226615

calendar_today

Updated On:

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.

Environment

ITMS 8.6 RU1 (SMP & SMA)

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.


image.png
 
For custom reports, the customer must use function fnGetComparableVersionAsString to decode 'OS Comparable version' as we see in Resource Manager (OS Comparable Version (decoded)) screenshot above.
 
Here is an example of SQL query which 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