Last Windows Update Audit

Get an Overview of All Computers and Their Latest Windows Update on Your Network

Find out when your Windows device was last updated and discover devices with potential update issues. The report will provide an overview of assets and the date of their last installed update. Spot computers which are falling behind in patching easier, the report is color-coded with 4 stages depending on how long ago the last Windows update was installed. Identify and take action to make sure that you have no security risks in your network due to unpatched machines. For a chart version of this report, you can use the Last Windows Update Chart report.

Please note that his report can only be used in SQL Server installations.

Last Windows Update

Last Windows Update Query

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysOS.OSname,
  tblAssets.Username,
  tblAssets.IPAddress,
  tblAssets.Description,
  Max(Convert(date,tblQuickFixEngineering.InstalledOn)) As lastPatchDate,
  tblAssets.Lastseen,
  Case
    When Max(Convert(date,tblQuickFixEngineering.InstalledOn)) >=
      DateAdd(day, -7, GetDate()) Then '#d4f4be'
    When Max(Convert(date,tblQuickFixEngineering.InstalledOn)) < 
DateAdd(day, -7, GetDate()) And Max(Convert(date,tblQuickFixEngineering.InstalledOn)) >= DateAdd(day,
      -30, GetDate()) Then '#f7f0ca'
    When Max(Convert(date,tblQuickFixEngineering.InstalledOn)) < 
DateAdd(day, -31, GetDate()) And Max(Convert(date,tblQuickFixEngineering.InstalledOn)) >= DateAdd(day,
      -90, GetDate()) Then '#f2d59f'
    Else '#f7caca'
  End As backgroundcolor
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 tblAssetCustom.State = 1
Group By tblAssets.AssetID,
  tblAssets.AssetName,
  tsysOS.OSname,
  tblAssets.Username,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssets.Lastseen
Order By lastPatchDate

Run This Report in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting