→ 🚀Are you a Lansweeper Champion?! Join our Contributor Program Sign up here!

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
jstella
Engaged Sweeper

Hello, is there a report where I can see the date that a machine updated its Windows version? For example, when it was updated from Windows 10 to Windows 11?

2 REPLIES 2
Mister_Nobody
Honored Sweeper II

Firstly, you must set Scanned Item Interval - OS:
History - Enabled
Refresh  - 0 or 1

Then try this report:

 

 

Select Top 1000000 tblassets.AssetID,
  tblassets.AssetName,
  tblOperatingsystemHist.Caption As Old_OS,
  tblOperatingsystemHist.Version As Old_OS_Ver,
  tblOperatingsystemHist.InstallDate As Old_OS_Installed,
  tblOperatingsystem.Caption As New_OS,
  tblOperatingsystem.Version As New_OS_Ver,
  Max(tblOperatingsystemHist.Lastchanged) As Upgrade_Date
From tblassets
  Inner Join tblOperatingsystemHist On
      tblassets.AssetID = tblOperatingsystemHist.AssetID
  Inner Join tblOperatingsystem On
      tblassets.AssetID = tblOperatingsystem.AssetID
Where tblOperatingsystemHist.Caption <> tblOperatingsystem.Caption
Group By tblassets.AssetID,
  tblassets.AssetName,
  tblOperatingsystemHist.Caption,
  tblOperatingsystemHist.InstallDate,
  tblOperatingsystem.Caption,
  tblOperatingsystemHist.Version,
  tblOperatingsystem.Version
Order By Upgrade_Date Desc

Thanks for this report! We were just discussing being able to track OS changes this morning, so this was very timely for us!