‎11-20-2014 01:07 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename As AssetType,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssetCustom.Printerstatus As Status,
tblAssetCustom.Printedpages As TotalPrintedPagesForPrinter,
tblCustDevPrinter.TonerColorName,
Cast(tblCustDevPrinter.TonerRemaining As nvarchar) + '%'
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblCustDevPrinter On tblCustDevPrinter.AssetID = tblAssets.AssetID
Where tsysAssetTypes.AssetTypename = 'Printer' And
tblAssetCustom.Printedpages Is Not Null And tblState.Statename = 'Active'
Order By tblAssets.IPNumeric,
tblAssets.AssetName"
‎01-30-2018 05:38 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now