MS Hotfixes

[grnat]

Hi

I've found some references in the forums on creating a report to list a certain MS hotfix but they only seem to be applicable to version 4.2 and don't list all the hotfixes that are installed on computers. Please could someone help me out with creating a report to list installed MS hotfixes?

Cheers

[grnat]

Perfect! Many thanks.

[Hemoco · Accepted solution]

A sample report can be seen below.

Select Distinct Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.SP,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblQuickFixEngineeringUni.HotFixID,
tblQuickFixEngineeringUni.FixComments,
tblQuickFixEngineeringUni.Description,
tblQuickFixEngineeringInstalledBy.InstalledBy,
tblQuickFixEngineering.Lastchanged
From tblAssets
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblQuickFixEngineering On tblAssets.AssetID =
tblQuickFixEngineering.AssetID
Inner Join tblQuickFixEngineeringUni On tblQuickFixEngineeringUni.QFEID =
tblQuickFixEngineering.QFEID
Inner Join tblQuickFixEngineeringInstalledBy
On tblQuickFixEngineeringInstalledBy.InstalledByID =
tblQuickFixEngineering.InstalledByID
Where tblAssets.Lastseen <> ''
Order By tblAssets.AssetName,
tblAssets.Domain,
tblQuickFixEngineering.Lastchanged Desc

To use the specified report, do the following:
• Browse to the Dashboard\Reports\Report Builder section of the web console.
• Paste the SQL code we provided at the bottom of the page.
• Left-click somewhere in the upper section of the page so the code applies.
• Give the report a Title and hit the Save & Run Report button to save it. Export options are listed on the left.
• The report will now also be listed under Dashboard\Reports\All Reports.