Report to see what machine upgrade Windows

[jstella]

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?

[Mister_Nobody · Accepted solution]

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

[StillGoing]

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