Need Assistance on Windows Update Reports

[EOINT]

I have browsed a quite a few posts and havent found the exact answer. I am looking to take the information from the Asset\Quickfix link and basically have a report that will list each asset with all the KB's/Hotfixes installed.

I know i can look for a specific KB, I can find a report on when an update was installed, but not all 3. I am not an expert on SQL - Itcould look like something like this

ASSETNAME - Update installed - Updates Installed (Listed)

Any help would be appreciated.

[sumatia]

Instead of listing all the hotfixes for one system, is it possible just to list when was the last update installed?

[Daniel_B · Accepted solution]

Hotfixes are stored in tables tblQuickFixEngineering and tblQuickFixEngineeringUni. You could use a report like the following example:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Lastseen,
  tsysOS.OSname,
  tsysOS.Image As icon,
  tblQuickFixEngineeringUni.HotFixID,
  tblQuickFixEngineeringUni.Description,
  tblQuickFixEngineering.InstalledOn
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,
  tsysOS
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName,
  tblQuickFixEngineering.InstalledOn Desc