Windows Servers with Hotfixes Installed

[EOINT]

Daniel thanks for the reply and starting a new thread as requested.
In a similar request, I am currently looking for the following:

- Asset Name
- OS
- IP
- Hot Fixes Currently installed

I tried different queries of the quickfix table and i havent been able to refine it. The output is mulitple hotfixes (as to be expected) but it possible to GROUP the each asset?

For example:

Server1 | WindowsXXX | 172.X.X. | Quickfix | Last Scanned | Last Seen
Quickfix1
quickfix2

Server2 | WindowsXXX | 172.X.X. | Quickfix | Last Scanned | Last Seen
Quickfix1
quickfix2
QUickfix3

Hope I am relaying what I am looking for clearly

Any help is greatly appreciated!!!

[Daniel_B · Accepted solution]

Reports will always have the same format in every line of the report. This is related to how SQL works. For a better overview, you might consider exporting your report to XLS and using Pivot tables.
This report lists all hotfixes on every computer:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysOS.OSname,
  tblAssets.IPAddress,
  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
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName,
  tblQuickFixEngineering.InstalledOn Desc