‎02-24-2015 06:50 PM
Select Top 1000000 tblQuickFixEngineeringUni.HotFixID,
tblQuickfixengineeringUni.Description,
tNotInstalled.AssetID,
tNotInstalled.AssetName
From tblQuickFixEngineering
Inner Join tblQuickFixEngineeringUni On tblQuickFixEngineering.QFEID =
tblQuickFixEngineeringUni.QFEID
Inner Join tblAssets On tblAssets.AssetID = tblQuickFixEngineering.AssetID
Left Join (Select tblQuickFixEngineeringUni.QFEID,
tblAssets.AssetID,
tblAssets.AssetName
From tblQuickFixEngineeringUni,
tblAssets
Inner Join tblComputersystem
On tblAssets.AssetID = tblComputersystem.AssetID
Where tblAssets.Assettype = -1 And tblComputersystem.Domainrole < 2 And
Not Exists(Select tblQuickFixEngineering.QFEID,
tblQuickFixEngineering.AssetID From tblQuickFixEngineering
Where tblQuickFixEngineering.QFEID = tblQuickFixEngineeringUni.QFEID And
tblQuickFixEngineering.AssetID = tblAssets.AssetID)) tNotInstalled
On tNotInstalled.QFEID = tblQuickFixEngineering.QFEID
Where tblAssets.AssetName = 'Reference'
Order By tblQuickFixEngineeringUni.HotFixID,
tNotInstalled.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now