Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
avjunior
Engaged Sweeper

Does anyone know of a report that lists all active machines in the technology park, containing computer data and which operating system (Win 10... Win 11...), which OS Version (22H2... 21H1 ...).

1 REPLY 1
Mister_Nobody
Honored Sweeper II
Select Top 1000000 tblassets.AssetID,
  tblassets.AssetName,
  tblOperatingsystem.Caption,
  tblOperatingsystem.Version As OS_Build,
  tblassets.Version
From tblassets
  Inner Join tblOperatingsystem On
      tblassets.AssetID = tblOperatingsystem.AssetID

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