This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Community FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

Nashterator
Engaged Sweeper

2 weeks ago - last edited 2 weeks ago

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

 

Labels:
0 Kudos
3 REPLIES 3
Mister_Nobody
Honored Sweeper III

a week ago - last edited a week ago

 

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
Honored Sweeper III
In response to Mister_Nobody

a week ago - last edited a week ago

Report for newer versions

0 Kudos
Mister_Nobody
Honored Sweeper III

a week ago

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

 

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now