Last scanned Windows update report

[Susan_A]

The report below lists your Windows computers and the date/time Lansweeper last detected a new Windows update on each computer. The report will only list assets that meet all of the following criteria:

• The asset is a Windows computer.
  
• The computer's state is set to "active".
  
• The computer has been successfully scanned at least once.

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  Max(tblQuickFixEngineering.Lastchanged) As LastPatchDetected
From tblAssets
  Inner Join tblQuickFixEngineering On tblAssets.AssetID =
    tblQuickFixEngineering.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tblQuickFixEngineeringUni On tblQuickFixEngineeringUni.QFEID =
    tblQuickFixEngineering.QFEID
Where tblAssetCustom.State = 1
Group By tsysOS.Image,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried
Order By LastPatchDetected

[Sven_Waetzold1]

Hi,

I have used this Report, but I only get the Date of the first Scan of the Asset.
Is it posible that the Reg Entry is not used for this Report?

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto
Update\Results\Detect
LastSuccessTime

and here:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto
Update\Results\Download
LastSuccessTime

I think this is the Reason. Is it posible to read the RegKey an put this information into the Database for Reports?

best regards Sven

[Susan_A]

Sven Waetzold wrote:
Hi,

I have used this Report, but I only get the Date of the first Scan of the Asset.
Is it posible that the Reg Entry is not used for this Report?

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto
Update\Results\Detect
LastSuccessTime

and here:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto
Update\Results\Download
LastSuccessTime

I think this is the Reason. Is it posible to read the RegKey an put this information into the Database for Reports?

best regards Sven

The report lists the date/time a new Windows update was last scanned on the computer, not necessarily when the last update was actually installed. If you would like to scan registry keys for more accurate reporting, you can do so by following the instructions in this knowledge base article. (A sample registry report is included as well.)