Windows update report miss 32 bit edition hotfix

[maxh]

Hi All,

We are currently using this report below since couple of month in addition to the pie chart, but after investigation we find some updates are missing.

All updates that contain "32-bit Edition" in their names are not taken into account in this report, someone knows how to do?(')
This report just list the last patch update but if the last patch update contains 32-bit edition the last patchdate is wrong!!



Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysOS.OSname,
tblAssets.Username,
tblAssets.IPAddress,
tblAssets.Description,
Max(Convert(datetime,tblQuickFixEngineering.InstalledOn)) As lastPatchDate,
tblAssets.Lastseen,
tblAssetCustom.State
From tblQuickFixEngineering
Join tblAssets On tblAssets.AssetID = tblQuickFixEngineering.AssetID
Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblQuickFixEngineering.InstalledOn Like '%/%' And tblAssetCustom.State = 1
Group By tblAssets.AssetID,
tblAssets.AssetName,
tsysOS.OSname,
tblAssets.Username,
tblAssets.IPAddress,
tblAssets.Description,
tblAssets.Lastseen,
tblAssetCustom.State

[maxh]

Hi

I don't now why but after newapplied updates, and new scan it seems that ok now.

TX for your help.

[Bruce_B]

All scanned Windows update information in the Lansweeper database is stored in the tblQuickfixEngineering and tblQuickfixEngineeringUni tables. If an update is not found in these tables and the asset has been recently scanned, this likely indicates that the missing update is not being retrievable via WMI scanning unfortunately.

[maxh]

Thanks

The issue is the report but also we can't identify the right table to request all Windows updates.

We know is on tblQuickFixEngineering do you know if all updates can be requested on other table?

tx

Max

[Esben_D]

My answer might have been too direct and lacks some context. Basically, I would recommend checking if the updates are visible in the WMI class Lansweeper retrieves it from. If updates are not in the WMI class Lansweeper scans them from, then they will not be in the report either since they are not in Lansweeper.

Basically, in order to check what is going wrong, we need to identify the cause of the issue, WMI, Lansweeper or the report itself.

[maxh]

Thanks for your answer but still have issue but not only on win32 on our server th report doesn't show the last update, but not on all servers...

Any idea?

Thanks

Max

[Esben_D]

Lansweeper retrieves the data about Windows patches from the Win32_QuickFixEngineering WMI Class. You can check what information is available in this class by running the following code in PowerShell on asset itself:

Get-WmiObject -Class Win32_QuickFixEngineering