‎01-15-2015 08:48 PM
Solved! Go to Solution.
‎01-16-2015 02:09 PM
Select Top 1000000 tblPrinters.Sharename,
tblPrinters.Caption,
tblPrinters.Comment,
tblPrinters.Portname,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Right Join tblPrinters On tblAssets.AssetID = tblPrinters.AssetID
Where tblPrinters.Sharename Is Not Null And tblAssetCustom.State = 1
Order By tblPrinters.Sharename,
tblAssets.AssetName
‎01-16-2015 02:09 PM
Select Top 1000000 tblPrinters.Sharename,
tblPrinters.Caption,
tblPrinters.Comment,
tblPrinters.Portname,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Right Join tblPrinters On tblAssets.AssetID = tblPrinters.AssetID
Where tblPrinters.Sharename Is Not Null And tblAssetCustom.State = 1
Order By tblPrinters.Sharename,
tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now