Cody,
I know this question has already been answered, but here is another query that I'm sharing that summarizes the Windows 10 Release Version Installs
select
RelVer.ReleaseVer [Win10 Release Version]
,Count(*)[Install Count]
,format( Count(*) * 1.0 / t.Win10Installs,'p') [Install %]
from VComputer vc
JOIN Inv_AeX_AC_Identification id ON id._ResourceGuid = vc.guid
CROSS APPLY dbo.fnSysMask_GetWindows10_VersionCodeAsTable( id.[OS System Mask]) RelVer -->> the built in fnSysMask_GetWindows10_VersionCodeAsTable function contains the Windows 10 Release Number
CROSS JOIN (
select COUNT(*) [Win10Installs] from VComputer vc
JOIN Inv_AeX_AC_Identification id ON id._ResourceGuid = vc.guid
CROSS APPLY dbo.fnSysMask_GetWindows10_VersionCodeAsTable( id.[OS System Mask]) RelVer
where vc.[OS Name] like '%Windows 10%'
)
where vc.[OS Name] like '%Windows 10%'
group by RelVer.ReleaseVer ,t.Win10Installs
Original Message:
Sent: 05-11-2020 10:54 AM
From: Cody Dirrigle
Subject: Report to show release version of Windows 10
What table or what do I need to hit on to show if windows 10 is 1803, 1809, 1909, etc?
------------------------------
Aspirus
------------------------------