Windows OS overview - Windows 10 versions and build number

[DaveNL78]

I need to have an overview of Windows 10 versions which are deployed and the build versions. Is this already build into LANsweeper? If not, should this be possible in for example the Windows Operating System Overview?

[hoddino]

Just confirmed that this latest update includes the data.

Thanks for the quick fix!

[Bruce_B · Accepted solution]

As the poster above me correctly indicated, support for the latest Windows 10 update was added in the latest Lansweeper release version 6.0.0.64 which you can download here.

In this update we also added a feature which will automatically add new Windows build numbers to the table tsysOS when found during scanning.

[stiwa]

Just install latest Lansweeper update and report should be fine.

[zdlease]

I'm also having problems with creating a report to filter out the Creators Update. The following query works fine for Windows 10 to filter out 1507, 1511, and 1607, but will not produce any results for 1703. I have an asset with 1703 installed and scanned into Lansweeper, and the build reports correctly on the asset's page, but the query never sees it.

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tsysOS.OSname As OS,
  tblOperatingsystem.Caption,
  tblOperatingsystem.Version,
  tblAssets.SP As SP,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Location,
  tsysIPLocations.IPLocation,
  tblAssets.Firstseen,
  tblAssets.Lastseen
From tblAssets
  Inner Join tblOperatingsystem
    On tblAssets.AssetID = tblOperatingsystem.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID
Where tblOperatingsystem.Version Like '10.0.15063'
Order By OS,
  tblAssets.AssetName,
  tblOperatingsystem.Caption

[hoddino]

This code works great but one thing I've noticed is it's not showing the latest build for "Creators" Update. Which is version 1703 Build 15063. Is it possible that Microsoft changed something in the naming?

Thanks!

[MariusC]

I think I found what I want:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tsysOS.OSname,
  tsysOS.OScode,
  tblRegistry.Value
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
  Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Where (tsysOS.OSname = 'Win 10' Or tsysOS.OSname = 'Win 2016') And
  tblRegistry.Valuename = 'UBR' And tblAssetCustom.State = 1

[MariusC]

How can I have a complete build of windows 10 report?
Ca you combine your report with File and registry Scanning to add the last number after current build like from WinVer (Ex Build win10 14393.969

The last digit I can find with registry scan from:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurentVersion\UBR
The build is from HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurentVersion\CurentBuildNumber

If exist a report where I can add both command from registry It will be perfect!

Thanks

[Karel_DS]

There isn't a built-in report for this specifically, but you could easily add a custom report.

The following query will show all scanned OS codes and the amount of assets on this version:

Select Top 1000000 tsysOS.OScode,
  tsysOS.OSname,
  Count(tblAssets.AssetID) As Amount
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssetCustom.State = 1 And (tsysOS.OSname = 'Win 10' Or
    tsysOS.OSname = 'Win 2016')
Group By tsysOS.OScode,
  tsysOS.OSname

This query will show all Windows 10 assets and their OS code (adjust or filter as needed):

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tsysOS.OScode,
  tsysOS.OSname
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 (tsysOS.OSname = 'Win 10' Or tsysOS.OSname = 'Win 2016') And tblAssetCustom.State = 1