
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-20-2014 01:07 PM
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 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"
Labels:
- Labels:
-
Built-In Reports
-
Report Center
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-30-2018 05:38 PM
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."
