
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-17-2016 02:43 PM
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
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
Labels:
- Labels:
-
Report Center
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-12-2016 10:06 PM
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

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-11-2016 10:46 PM
Would also like to see a report for this!
