cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Daniel_B
Lansweeper Alumni
Old name: Device: Printer status (Built-in)

The report below lists the printers with their respective status

The report will only list assets that meet all of the following criteria:
  • The asset state is set to "active".
  • The asset type is set to "Printer".
  • The status information is available.


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"
1 REPLY 1
BES_IT
Engaged Sweeper II
When I try to put this in (I accidentally overwrote the Built-In one), I get Error while saving report: "Create View or Function failed because no column name was specified for column 14."