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 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
Cast(Replace(Replace(Replace(tblAssets.OScode, '.', ''), 'S', ''),
'R', '') As BIGINT)
Else 0
End) As OsCodeNumeric,
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(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 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
