‎05-06-2020 02:06 AM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblPrinters.Caption As Printer,
tblPrinters.Portname,
tblPrinters.Printjobdatatype,
tblPrinters.Printprocessor,
tblPrinters.Sharename,
tblPrinters.Status,
tblPrinters.Comment,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblPrinters.Lastchanged
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblPrinters On tblAssets.AssetID = tblPrinters.AssetID
Where tblAssetCustom.State = 1
Order By tblPrinters.Portname,
tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now