→ 🚀Are you a Lansweeper Champion?! Join our Contributor Program Sign up here!
yesterday
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?
12 hours ago - last edited 11 hours ago
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
5m ago
Thanks for this report! We were just discussing being able to track OS changes this morning, so this was very timely for us!
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now