‎08-17-2015 05:08 PM
Solved! Go to Solution.
‎08-18-2015 02:49 PM
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
‎08-18-2015 03:21 PM
‎08-18-2015 02:49 PM
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now