Page Count report split by Color and B&W?

[DavidHooie]

I've been asked to use Lansweeper to create a monthly report showing how many B&W prints and how many color prints are being done for each copier in our business.  Lansweeper shows page counts, but I don't see any way to differentiate between b&w and color?

These are Canon iR-ADV C5860 copiers.

Any advice/help is appreciated!

[DavidHooie]

Thank you!

[francisswest · Accepted solution]

I gotcha, bud.  Try this one on for size:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.IPAddress,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssets.Lastseen As [Last successful scan],
  tblAssetCustom.PrintedColorPages As [Color Prints],
  tblAssetCustom.PrintedMonoPages As [Black and White Prints]
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tsysAssetTypes.AssetTypename = 'Printer'
Group By tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.IPAddress,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssets.Lastseen,
  tblAssetCustom.PrintedColorPages,
  tblAssetCustom.PrintedMonoPages
Order By tblAssets.AssetName

It relies on the following parts:

• tblAssetCustom.PrintedColorPages
• tblAssetCustom.PrintedMonoPages

So long as the printer asset page pulls that info (like this):

Then the report should work.  Lemme know if it doesnt.  Final report appearence:
If your printer models dont pull that info via SNMP, it might require some additional OID/MIB info.