Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-16-2016 07:35 PM
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
Labels:
- Labels:
-
Finished Reports
-
Report Center
2 REPLIES 2
![Sven_Waetzold1 Sven_Waetzold1](https://community.lansweeper.com/html/assets/User_Avatar.png)
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-18-2016 10:16 AM
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
I have used this Report, but I only get the Date of the first Scan of the Asset.
![](/legacyfs/online/forums_emojis/eusa_wall.gif)
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-21-2016 02:44 PM
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.)
![](/skins/images/6AE91C23811BC8C2ED7451073DC36BEF/responsive_peak/images/icon_anonymous_message.png)