Not Latest Build of Windows 10 Audit

Discover All Computers Not Running the Latest Windows 10 Build

Discover all computers in your network which are not running the latest Windows 10 build. Once one computer in your environment has been updated to the latest Windows build, you can use this audit to find all computers which do not have the latest Windows 10 build. Providing you with a complete list of all assets that still require an update so you can start taking action right away.

Not latest Build of Windows 10

Click to Open - Not Latest Build of Windows 10 Query
Select Top (1000000) tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tsysOS.OSname As OS,
  tblAssets.OScode + '.' + tblAssets.BuildNumber As Build,
  tblAssets.Version As [OS Version],
  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 tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Left Outer Join tsysIPLocations On tblAssets.LocationID =
    tsysIPLocations.LocationID
Where (tsysOS.OSname = 'Win 10' And tblAssetCustom.State = 1 And
  tblAssets.BuildNumber Is Not Null And
  Cast(Replace(Replace(Replace(tblAssets.OScode, '.', ''), 'S', ''), 'R',
  '') As bigint) Not In (Select Max(Cast(Replace(Replace(Replace(tsysOS.OScode,
        '.', ''), 'S', ''), 'R', '') As bigint)) As Expr1 From tsysOS
      Where tsysOS.Sortorder = 18)) Or
  (tsysOS.OSname = 'Win 10' And tblAssetCustom.State = 1 And
  tblAssets.BuildNumber Is Not Null And tblAssets.BuildNumber Not In (Select
        Max(tblAssets.BuildNumber) As Expr1 From tblAssets
      Where Cast(Replace(Replace(Replace(tblAssets.OScode, '.', ''), 'S', ''),
        'R', '') As bigint) In (Select
              Max(Cast(Replace(Replace(Replace(tsysOS.OScode, '.', ''), 'S',
              ''), 'R', '') As bigint)) As Expr1 From tsysOS
            Where tsysOS.Sortorder = 18)))
Order By tblAssets.AssetName

Audit and Take Action in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Audit & Take Action

Download Lansweeper to Run this Audit

Harness the Power of Reporting