cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
capeuser
Engaged Sweeper
On my Main Screen, in the middle my system is reporting that all of my Windows 10 installation are not on the latest version of the OS.

it reports 1903 as of out date. as well as everything from 1703 to 1903. Why does it do this?

4 REPLIES 4
grimstar
Champion Sweeper II
It's actually not misleading. The report states not latest "Build", and "Build" is the field it is basing it off of.

If you wanted it to be based off of anything less than the most current OS Version you could do something like this:

[To be clear on the report below, I just took the other canned report and removed the requirement to check the build number. There was already something in place to check the OSCode max value so no additional work was necessary.]


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,
Cast(Replace(Replace(Replace(tblAssets.OScode, '.', ''), 'S', ''), 'R',
'') As BIGINT) 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 Join tsysIPLocations On tblAssets.LocationID =
tsysIPLocations.LocationID
Where tsysOS.OSname = 'Win 10' And tblAssetCustom.State = 1 And
tblAssets.BuildNumber Is Not Null) SQ
Cross Join (Select Max(os1.OSCodeNumeric) MaxOsCodeNumeric
From tsysOS os1
Where os1.Sortorder = 18) mo
Cross Join (Select Max(Cast(a.BuildNumber As INT)) MaxBuildNumber
From tblAssets a
Inner Join tsysOS As o On o.OScode = a.OScode
Where o.OSname = 'Win 10' And a.BuildNumber Is Not Null And
Cast(Replace(Replace(Replace(a.OScode, '.', ''), 'S', ''), 'R',
'') As BIGINT) = (Select Max(os2.OSCodeNumeric) From tsysOS os2
Where os2.Sortorder = 18)) mb
Where (SQ.OsCodeNumeric < mo.MaxOsCodeNumeric) Or
(SQ.BuildNumber < mb.MaxBuildNumber)
Order By SQ.AssetName
capeuser
Engaged Sweeper
Ok, so this is very misleading. If I look at the dashboard, it would appear that 82 systems need 1902, when in fact it is not correct.

How can this be corrected to reflect what is the truth?
cycleheat
Engaged Sweeper III
CAP wrote:
Ok, so this is very misleading. If I look at the dashboard, it would appear that 82 systems need 1902, when in fact it is not correct.

How can this be corrected to reflect what is the truth?


To be fair to Lansweeper, version and build are two different things.

For the Dashboard, using the "Windows 10 Version Overview" widget is also specific to the versions, like 1809 or 1903.
grimstar
Champion Sweeper II
The actual report checks the full build number, and not just the OS Version. I'll use myself as an example. The highest build number on my "OS: Not latest Build of Windows 10" report is -

10.0.18362.175

This is 1903, but comes up on the report still. If I check all of my Windows assets I can see that I have two devices with a build number of -

10.0.18362.295

Essentially you have a device (or devices) that is (are) at a higher patch level than everything else in the report.