Is there a way in Lansweeper to report on printer pages printed for only black pages printed excluding color copies?
For instance:
Lansweeper states 60000 pages printed by a printer, but in reality on 28k have been black print outs.
We have a vendor who charges per page on black toner. We would like to run reports through Lansweeper to verify their invoices each month.
I have pasted our current report below. It only offers the option to have total pages printed. For our color printers this is difficult as the page count is totaled and displayed in Lansweeper.
Select Top 1000000 tblAssets.AssetName,
tblAssetCustom.Printedpages,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Mac,
tblAssets.AssetID,
tsysAssetTypes.AssetTypename
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tsysAssetTypes.AssetType = 16
Order By tblAssetCustom.Printedpages Desc