Notification

Icon
Error

OS: Not latest Build of Windows 10??

Posted: Tuesday, June 11, 2019 3:29:52 AM(UTC)
nekrosoft13

nekrosoft13

Member Original PosterPosts: 11
1
Like
How does this list work? How does it know if the windows is latest build or not?

All my windows 10 are 1903 build 10.0.18362.145 (which is current build) and all are listed on being not current build.


note: tomorrow, there will be a new build
Esben.D
#1Esben.D Member Administration Posts: 1,834  
posted: 6/11/2019 8:42:05 AM(UTC)
If I'm not mistaken it searches for the highest build number scanned and compares the rest to that.

Try running the report below and see if that works. If I remember correctly there was an issue with the built-in report where it compared strings instead of converting the data to a number first.
Code:
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 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 int) Not In (Select Max(Cast(Replace(Replace(tsysOS.OScode, '.', ''),
          'S', '') As int)) From tsysOS
        Where tsysOS.Sortorder = 18) Or tblAssets.BuildNumber Not In (Select
          Max(Cast(tblAssets.BuildNumber As Int)) From tblAssets
        Where Cast(Replace(Replace(Replace(tblAssets.OScode, '.', ''), 'S', ''),
          'R', '') As int) In (Select Max(Cast(Replace(Replace(tsysOS.OScode,
                '.', ''), 'S', '') As int)) From tsysOS
              Where tsysOS.Sortorder = 18)))
Order By tblAssets.AssetName
nekrosoft13
#2nekrosoft13 Member Original PosterPosts: 11  
posted: 6/12/2019 3:36:27 PM(UTC)
somehow the report things that this build "10.0.18362.30" is the latest...


while yesterday they released "10.0.18362.175", and the report doesn't like that number....

Could it be only looking at the .3 and thinking that well 3 is larger then 1 in .1?
coffee2000
#3coffee2000 Member Posts: 4  
posted: 7/9/2019 8:46:05 AM(UTC)
Same issue here, my PC (most up-to-date) is listed in the report even though it has the highest build number of all workstations in my company....
brodiemac
#4brodiemac Member Posts: 19  
posted: 8/7/2019 1:28:21 PM(UTC)
This worked for me. Thanks!

Originally Posted by: Esben.D Go to Quoted Post
If I'm not mistaken it searches for the highest build number scanned and compares the rest to that.

Try running the report below and see if that works. If I remember correctly there was an issue with the built-in report where it compared strings instead of converting the data to a number first.
Code:
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 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 int) Not In (Select Max(Cast(Replace(Replace(tsysOS.OScode, '.', ''),
          'S', '') As int)) From tsysOS
        Where tsysOS.Sortorder = 18) Or tblAssets.BuildNumber Not In (Select
          Max(Cast(tblAssets.BuildNumber As Int)) From tblAssets
        Where Cast(Replace(Replace(Replace(tblAssets.OScode, '.', ''), 'S', ''),
          'R', '') As int) In (Select Max(Cast(Replace(Replace(tsysOS.OScode,
                '.', ''), 'S', '') As int)) From tsysOS
              Where tsysOS.Sortorder = 18)))
Order By tblAssets.AssetName


Active Discussions

Lansweeper Remove all users from old domain
by  cmuter   Go to last post Go to first unread
Last post: 9/20/2019 8:03:58 PM(UTC)
Lansweeper Static IP Address
by  cycleheat  
Go to last post Go to first unread
Last post: 9/20/2019 4:07:16 PM(UTC)
Lansweeper Bitlocker Encryption Recovery Key no information found
by  Stephane   Go to last post Go to first unread
Last post: 9/20/2019 2:26:19 PM(UTC)
Lansweeper InTune Scanning Issues
by  Esben.D  
Go to last post Go to first unread
Last post: 9/20/2019 12:34:59 PM(UTC)
Lansweeper Office 365 scanning issues
by  Esben.D   Go to last post Go to first unread
Last post: 9/20/2019 12:23:30 PM(UTC)
Lansweeper Hard Drive Tracking - Start to Finish
by  Lone Jedi  
Go to last post Go to first unread
Last post: 9/19/2019 8:11:56 PM(UTC)
Lansweeper Lansweeper Reporting Old Assets as New
by  Jpatterson   Go to last post Go to first unread
Last post: 9/19/2019 12:52:14 PM(UTC)
Lansweeper Cannot edit a ticket anymore
by  Esben.D  
Go to last post Go to first unread
Last post: 9/19/2019 12:32:42 PM(UTC)