WSUS Updates Needed/Failed or Successful

[ataylor]

Hello,

I'm looking for a report on what computers have WSUS updates Needed/Failed, or Installed/Not Required. It looks like this problem has been solved back in 2012, but the solution no longer works in Lansweeper 6. Is it possible to get it working in the current version? It would be very helpful.

http://www.lansweeper.com/Forum/yaf_postst6211_WSUS-Reports.aspx

Thanks,
Alexander

[MikeMc]

As long as you have your registry scanning set up, the following report will work with Lansweeper v6.

Select tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  T1.Value As LastDetectTime,
  T2.Value As LastDownloadTime,
  T3.Value As LastInstallTime
From tblAssets
  Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
  Left Join (Select tblRegistry.AssetID,
    tblRegistry.Value
  From tblRegistry
  Where
    tblRegistry.Regkey =
    'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\Results\Detect') T1 On T1.AssetID = tblAssets.AssetID
  Left Join (Select tblRegistry.AssetID,
    tblRegistry.Value
  From tblRegistry
  Where
    tblRegistry.Regkey =
    'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\Results\Download') T2 On T2.AssetID = tblAssets.AssetID
  Left Join (Select tblRegistry.AssetID,
    tblRegistry.Value
  From tblRegistry
  Where
    tblRegistry.Regkey =
    'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\Results\Install') T3 On T3.AssetID = tblAssets.AssetID
Where tblAssetCustom.State = 1 And tblAssets.Assettype = -1
Order By tblAssets.AssetName

[SystemsIT]

Would also like to see a report for this!