→ 🚀What's New? Explore Lansweeper's Fall 2024 Updates! Fall Launch Blog !

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