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:
- 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.
Please note that some information might not be shown for all printers. Some printers do not support returning black & white and color printed pages.
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
