Color printer report

[richgar4par]

Is there a way to breakout the number of B/W and color printed pages? Ricoh requires that we give them both meters on color copiers. This will beat remoting to each copier to obtain the meter reads.

[brandon_jones]

Sorry about that. It was a report I actually found in the forums. Thanks RC62N.

[RCorbeil]

Are you sure "Printers: Printed pages" is a stock report? I don't show it on my installation.

Assuming not, richgar4par, the printed page counts can be found in tblAssetCustom. See if this is enough to get you started:

Select Top 1000000
  tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblAssetCustom.Printedpages,
  tblAssetCustom.PrintedMonoPages,
  tblAssetCustom.PrintedColorPages
From
  tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where
  tsysAssetTypes.AssetTypename = 'Printer'
  And tblAssetCustom.State = 1

[brandon_jones]

The built in report Printers:Printed pages breaks down the B/W and colored pages.