Determine Windows 10 Build

[maph]

Is there a way for LANSweeper 6.0 to report on Windows 10 build? The scanned asset simply states its "Windows 10 Education x64". But there doesn't appear to be a way to determine if its build 1511, build 1607, etc. That's becoming increasingly important with the new Windows 10 servicing model.

[Leandroi9]

Thank you Susan,

I used your sample and made some adjustments to my use, below for those who want to 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

[Susan_A]

Just some additional information for everyone: you can view the information on individual asset pages as moore_mat indicated or run a report. I've included a sample report below, which you can add to your Lansweeper installation by following these instructions.

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
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 tblAssetCustom.State = 1
Order By tblAssets.Domain,
  tblAssets.AssetName

[moore_mat · Accepted solution]

I'll try to have a look further into this, but at the moment if you head to a Windows 10 PC in LANSweeper; go into Config --> Windows --> OS; the version is listed second from the bottom.

I'm not too up on version numbers, but this matched the output from running "winver" from the Run box (my PC is running 1607 at the moment, but the build is listed as 14393.51, which is what LanSweeper found).

I'll keep digging and see if there's anywhere else...


Mat