Report Show devices that have a Windows version less than 22H2

[Nashterator]

Hi, I need to show devices that have a windows version less than 22H2.

[Mister_Nobody]

Select Top 1000000 tblassets.AssetID,
  tblassets.AssetName,
  tblassets.IPAddress,
  tblassets.Lastseen,
  tblassets.Lasttried,
  tblOperatingsystem.Caption,
  tblassets.Version,
  tblOperatingsystem.Version As build
From tblassets
  Inner Join tblOperatingsystem On
      tblassets.AssetID = tblOperatingsystem.AssetID
Where Replace(tblOperatingsystem.Version, '.', '') > 10019045 And
  Replace(tblOperatingsystem.Version, '.', '') <> 10022000 And
  Replace(tblOperatingsystem.Version, '.', '') <> 10020348

[Mister_Nobody]

Report for newer versions

[Mister_Nobody]

Try this:

Select Top 1000000 tblassets.AssetID,
  tblassets.AssetName,
  tblassets.IPAddress,
  tblassets.Lastseen,
  tblassets.Lasttried,
  tblOperatingsystem.Caption,
  tblOperatingsystem.Version
From tblassets
  Inner Join tblOperatingsystem On
      tblassets.AssetID = tblOperatingsystem.AssetID
Where Replace(tblOperatingsystem.Version, '.', '') < 10019045 And
  Replace(tblOperatingsystem.Version, '.', '') <> 10022000