→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎06-29-2016 02:57 PM
Solved! Go to Solution.
‎07-01-2016 10:25 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssetCustom.Model,
tblComputerSystemProduct.UUID
From tblAssets
Left Join tblWarranty On tblAssets.AssetID = tblWarranty.AssetId
Left Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tblComputerSystemProduct On tblAssets.AssetID =
tblComputerSystemProduct.AssetID
Where tblAssetCustom.State = 1 And tblAssets.Assettype = -1
‎07-01-2016 10:25 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssetCustom.Model,
tblComputerSystemProduct.UUID
From tblAssets
Left Join tblWarranty On tblAssets.AssetID = tblWarranty.AssetId
Left Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tblComputerSystemProduct On tblAssets.AssetID =
tblComputerSystemProduct.AssetID
Where tblAssetCustom.State = 1 And tblAssets.Assettype = -1
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now