→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Guest
Lansweeper Employee
Lansweeper Employee
I created this report using info from another post I saw from someone who wanted to create a report that shows when a computer was updated last. It works, in that it shows me 29 computers and the last date they were updated. However if I click the Assets menu in Lansweeper, and click on Windows, its shows me 40 assets. So it’s skipping 11 for some reason in the report. They are all active. Some are identical models, created with the same Windows image. Any ideas were to look? Thanks.

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
Max(tblQuickFixEngineering.Lastchanged) As LastPatchInstalled
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.IPAddress
Order By LastPatchInstalled
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
Possibly the other computers in your network were not successfully scanned. You could give the following report a try which lists all active Windows computers, regardless if hotfixes have been scanned from them or not.

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
Max(tblQuickFixEngineering.Lastchanged) As LastPatchInstalled
From tblAssets
Left Join tblQuickFixEngineering On tblAssets.AssetID =
tblQuickFixEngineering.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join tblQuickFixEngineeringUni On tblQuickFixEngineeringUni.QFEID =
tblQuickFixEngineering.QFEID
Where tblAssetCustom.State = 1 And tblAssets.Assettype = -1
Group By tsysOS.Image,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress
Order By LastPatchInstalled

View solution in original post

2 REPLIES 2
Guest
Lansweeper Employee
Lansweeper Employee
That worked, I now have all the Windows PC's.
Yes, some of the systems dont show patches, but thats good as well, I know to check them.

Thanks.
Daniel_B
Lansweeper Alumni
Possibly the other computers in your network were not successfully scanned. You could give the following report a try which lists all active Windows computers, regardless if hotfixes have been scanned from them or not.

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
Max(tblQuickFixEngineering.Lastchanged) As LastPatchInstalled
From tblAssets
Left Join tblQuickFixEngineering On tblAssets.AssetID =
tblQuickFixEngineering.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join tblQuickFixEngineeringUni On tblQuickFixEngineeringUni.QFEID =
tblQuickFixEngineering.QFEID
Where tblAssetCustom.State = 1 And tblAssets.Assettype = -1
Group By tsysOS.Image,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress
Order By LastPatchInstalled