
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-06-2018 10:50 AM
The report below lists printers and the amount of printed pages in black & white, color and a total of all printer pages.
The report will only list assets that meet all of the following criteria:
The report will only list assets that meet all of the following criteria:
- Lansweeper must be on version 6.0.230.45 or higher.
- The asset state is set to "active".
- The asset type is set to "Printer".
- The amount of total printed pages must be scanned.
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetName,
tblAssetCustom.Model As [Device model],
tblAssetCustom.Printerstatus As Status,
tblAssetCustom.PrintedMonoPages As [Printed Black & White Pages],
tblAssetCustom.PrintedColorPages As [Printed Color Pages],
tblAssetCustom.Printedpages As [Total Printed Pages],
tblAssets.Lastseen,
tblAssets.AssetID
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Where tblAssetCustom.Printedpages Is Not Null And tblAssetCustom.State = 1
Order By tblAssets.AssetName
Labels:
- Labels:
-
Finished Reports
-
Report Center
0 REPLIES 0
