Not Latest Build of Windows 10 Audit
Operating SystemDiscover 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 Query
Select Top (1000000) SQ.icon, SQ.AssetID, SQ.AssetName, SQ.OS, SQ.Build, SQ.[OS Version], SQ.Domain, SQ.Username, SQ.Userdomain, SQ.IPAddress, SQ.Description, SQ.Manufacturer, SQ.Model, SQ.Location, SQ.IPLocation, SQ.Firstseen, SQ.Lastseen From (Select 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, (Select Case When IsNumeric(Replace(Replace(Replace(tblAssets.OScode, '.', ''), 'S', ''), 'R', '') + '.0') = 1 Then Try_Cast(Replace(Replace(Replace(tblAssets.OScode, '.', ''), 'S', ''), 'R', '') As BIGINT) Else 0 End) As OsCodeNumeric, Try_Cast(tblAssets.BuildNumber As INT) As BuildNumber 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) As SQ Cross Join (Select Max(os1.OSCodeNumeric) As MaxOsCodeNumeric From tsysOS As os1 Where os1.Sortorder = 18) As mo Cross Join (Select Max(Try_Cast(a.BuildNumber As INT)) As MaxBuildNumber From tblAssets As a Inner Join tsysOS As o On o.OScode = a.OScode Where o.OSname = 'Win 10' And a.BuildNumber Is Not Null And (Select Case When IsNumeric(Replace(Replace(Replace(a.OScode, '.', ''), 'S', ''), 'R', '') + '.0') = 1 Then Try_Cast(Replace(Replace(Replace(a.OScode, '.', ''), 'S', ''), 'R', '') As BIGINT) Else 0 End) = (Select Max(os2.OSCodeNumeric) As Expr1 From tsysOS As os2 Where os2.Sortorder = 18)) As mb Where (SQ.OsCodeNumeric < mo.MaxOsCodeNumeric) Or (SQ.BuildNumber < mb.MaxBuildNumber) Order By SQ.AssetName