Last Windows update date and Last software installed

[robd]

Hello,

I've got this report that shows the last windows update installed which is great as it works for server 2016 (the registry key method doesnt exist on server 2016):

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysOS.OSname,
  tblAssets.IPAddress,
  tsysOS.Image As icon,
  tblQuickFixEngineeringUni.HotFixID,
  tblQuickFixEngineeringUni.Description,
  tblQuickFixEngineering.InstalledOn,
  tblQuickFixEngineering.QFEID
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
  Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
    tblAssetGroupLink.AssetGroupID
  Inner Join tblQuickFixEngineering On tblAssets.AssetID =
    tblQuickFixEngineering.AssetID
  Inner Join tblQuickFixEngineeringUni On tblQuickFixEngineeringUni.QFEID =
    tblQuickFixEngineering.QFEID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName,
  tblQuickFixEngineering.InstalledOn Desc

the problem is if you check the history of a server other updates have been installed but lansweeper thinks they are software installs rather than windows updates:



So does anyone have a report I could run to get both software and windows updates and when they were last run?