Report for last Windows update install

[predator29]

I'm trying to come up with a report that shows the last time windows updates were installed on a system. I've been messing around with the newest date for Quickfix but I cant seem to get a working report. Has anyone come up with a report that does this?

[RCorbeil]

Try this:

SELECT Top 1000000
  tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  ( SELECT Top 1
      tblQuickFixEngineering.Lastchanged
    FROM
      tblQuickFixEngineering
    WHERE
      tblQuickFixEngineering.AssetID = tblAssets.AssetID
    ORDER BY
      tblQuickFixEngineering.Lastchanged Desc) AS LastQFChange
FROM
  tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
WHERE
  tblAssetCustom.State = 1

Assumes that the entries in tblQuickFixEngineering are placed there as part of a Windows Update run, not one-off updates.