→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎03-20-2015 11:58 PM
Solved! Go to Solution.
‎03-23-2015 11:29 AM
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.AssetName Like 'targetComputerName ' And 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 = 'refereceComputerName '
Order By tblQuickFixEngineeringUni.HotFixID,
tNotInstalled.AssetName
‎03-23-2015 11:29 AM
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.AssetName Like 'targetComputerName ' And 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 = 'refereceComputerName '
Order By tblQuickFixEngineeringUni.HotFixID,
tNotInstalled.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now