cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
SPAMHATER007
Engaged Sweeper III
I would like to build are report by Windows 10 version 1xxx and build number:
Version 1709 (OS Build 16299.64) - Latest build update.

These are found here:
Windows 10 update history – Usually released around beginning of month.

Updates for Windows 10 Version 1709
https://support.microsoft.com/en-us/help/4043454

Updates for Windows 10 Version 1703
https://support.microsoft.com/en-us/help/4018124

Updates for Windows 10 Version 1607
https://support.microsoft.com/en-us/help/4000825

Updates for Windows 10 Version 1511
https://support.microsoft.com/en-us/help/4000824

Updates for Windows 10 (initial version released July 2015)
https://support.microsoft.com/en-us/help/4000823


2 REPLIES 2
pfenton
Engaged Sweeper III
This is what I use:

Select Top 1000000 tblAssets.AssetName,
tsysOS.OSname,
tsysOS.Image As icon,
tblAssets.OScode,
tblAssets.IPAddress,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssetCustom.State = 1
Order By tsysOS.OSname
andrewhancock91
Engaged Sweeper II
Not sure if it helps but this is a report I use to identify any Windows 10 install over 1604, you should be able to tweak it to only show 1709 I'd think

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tsysOS.OSname,
tblOperatingsystem.Caption As FullOSname,
tblOperatingsystem.Version,
tblOperatingsystem.InstallDate
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tsysOS.OSname = 'win 10' And tblOperatingsystem.Version > '10.0.14393' And
tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName