‎11-18-2015 11:20 PM
Select Top 1000000 tblAssets.AssetName,
tblAssets.AssetID,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblQuickFixEngineeringUni.ServicePackInEffect,
tblQuickFixEngineeringUni.HotFixID,
tblQuickFixEngineeringUni.FixComments,
tblQuickFixEngineeringUni.Description,
tblQuickFixEngineering.InstalledOn,
tblQuickFixEngineering.Lastchanged
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblQuickFixEngineering On tblAssets.AssetID =
tblQuickFixEngineering.AssetID
Inner Join tblQuickFixEngineeringUni On tblQuickFixEngineeringUni.QFEID =
tblQuickFixEngineering.QFEID
Where tblAssetCustom.State = 1
Solved! Go to Solution.
‎11-23-2015 01:45 PM
‎11-23-2015 01:45 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now