Windows 10 Build Version report

[SPAMHATER007]

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

[pfenton]

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]

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