Windows 10 OD latest version

[capeuser]

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?

[grimstar]

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]

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]

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]

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.