Missing assets from report

[Guest]

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

[Guest]

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 · Accepted solution]

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