SO Version Report

[avjunior]

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 ...).

[Mister_Nobody]

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