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,818  
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 Ticket Summary by Agent?
by  susan.starr   Go to last post Go to first unread
Last post: Yesterday at 4:41:26 PM(UTC)
Report Center Virtual machines and their host
by  klaus  
Go to last post Go to first unread
Last post: Yesterday at 8:44:57 AM(UTC)
Lansweeper Patch Tuesday report, last 3 months
by  Esben.D   Go to last post Go to first unread
Last post: 9/16/2019 1:38:33 PM(UTC)
Lansweeper Query on 'Assets: Installed software by computer' Report
by  RC62N  
Go to last post Go to first unread
Last post: 9/12/2019 5:12:40 PM(UTC)
Lansweeper Adding Comments
by  AZHockeyNut   Go to last post Go to first unread
Last post: 9/10/2019 7:39:40 PM(UTC)
Lansweeper Handling Device ID and Hardware ID
by  nicsweeper  
Go to last post Go to first unread
Last post: 9/10/2019 8:50:26 AM(UTC)
Report Center Workstation: Last reported boot time
by  Victor Heijmerikx   Go to last post Go to first unread
Last post: 9/10/2019 8:21:37 AM(UTC)
Lansweeper Firefox 69
by  Esben.D  
Go to last post Go to first unread
Last post: 9/5/2019 10:50:19 AM(UTC)