Does anyone have a good report to show Windows build number?

[Chris Burkhardt]

I know it is in the database somewhere because when I click on a client from manage computers I see it in ()'s but I haven't been able to track down where in the database it is stored.  Does anyone have an existing report they can share or even a link to where in the database certain info can be located?​

[Martin Sapsed]

I know it is in the database somewhere because when I click on a client from manage computers I see it in ()'s but I haven't been able to track down where in the database it is stored. Does anyone have an existing report they can share or even a link to where in the database certain info can be located?​

Chris Burkhardt,  09-09-2020 10:51 AM

The "build number" is in AeX AC Identification, if you really mean the Build number? If you mean the Windows 10 Version (1909 etc) then I suspect it's derived from the build number.

Regards
Martin

------------------------------
Bangor University
------------------------------

[Johannes Bedrech]

Hi Chris Burkhardt,

Take a look at this community post: https://community.broadcom.com/groups/communities/community-home/digestviewer/viewthread?MessageKey=bd3e3bdb-d212-4f65-bf32-1733fb1a86aa&CommunityKey=2eae875e-f73e-4358-8452-7bb8f7f27f59&tab=digestviewer#bmbd3e3bdb-d212-4f65-bf32-1733fb1a86aa-------------------------------------------

Network23

Original Message:
Sent: 09-09-2020 10:51 AM
From: Chris Burkhardt
Subject: Does anyone have a good report to show Windows build number?

I know it is in the database somewhere because when I click on a client from manage computers I see it in ()'s but I haven't been able to track down where in the database it is stored.  Does anyone have an existing report they can share or even a link to where in the database certain info can be located?​

[Igor Perevozchikov]

This version calculates using this function fnSysMask_GetWindows10_VersionCodeAsTable and [OS System Mask] value from Inv_AeX_AC_Identification data class.

Example below:
SELECT DISTINCT
vc.[Name] AS [PC Name],
ide.Domain,
ide.[Last Logon User],
ide.[Hardware Serial Number],
ide.[OS Name] +
CASE WHEN aa.ReleaseVer IS NULL
THEN ''
ELSE ' (' + CAST(aa.ReleaseVer AS nvarchar(8)) + ')'
END AS [OS Name]
FROM vRM_Computer_Item AS vc
LEFT JOIN Inv_AeX_AC_Identification AS ide ON ide._ResourceGuid = vc.[Guid]
OUTER APPLY dbo.fnSysMask_GetWindows10_VersionCodeAsTable( ide.[OS System Mask] ) aa

Note:
Windows version ( ) will be shown if basic inventory is sent from Symantec Management Agent 8.5 RU1 version (not lower than 8.5 RU1)

Thanks,
IP.

------------------------------
Software QA Engineer
Broadcom Inc.
------------------------------

[Chris Burkhardt]

Thank you for the info.  I actually found the info online but hadn't had a chance to update this thread​ and unfortunately I can't seem to find the link so my apologies to the original poster.  It is very similar to what was already posted.

select
    vc.name Computer
    ,VC.[OS Name]
    ,RelVer.ReleaseVer [Win10 Release Verision]
       ,OS.[Type]
    ,OS.Architecture
    ,OS.[Platform]
    ,OS.[OS Name] OperatingSystem
    ,os.[Service Pack]
    ,os.[OS Edition]
    ,os.TagFlags
from VComputer vc
JOIN  Inv_AeX_AC_Identification id ON id._ResourceGuid = vc.guid
CROSS APPLY dbo.fnSysMask_GetAllSystemMaskAsStringTable( id.[OS System Mask]) OS   -->> the built in fnSysMask_GetAllSystemMaskAsStringTable contains a number of useful filter that can be used for filters
CROSS APPLY dbo.fnSysMask_GetWindows10_VersionCodeAsTable( id.[OS System Mask]) RelVer  -->> the built in fnSysMask_GetWindows10_VersionCodeAsTable function contains the Windows 10 Release Number
where vc.[OS Name] like '%Windows%'
order by vc.[os name], os.[os edition]

[Terry@WAB]

Sample of what i've been using, not sophisticated but works. 
SELECT ac.[Name]
,ac.[Domain]
,ac.[OS Name]
,ac.[Last Logon User]
,ac.[OS Build Number]
FROM Inv_AeX_AC_Identification ac
where ac.[OS Name] like 'Windows 10%'
and ac.[OS Build Number] = '17763'