→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
richgar4par
Engaged Sweeper
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.
3 REPLIES 3
brandon_jones
Champion Sweeper III
Sorry about that. It was a report I actually found in the forums. Thanks RC62N.
RCorbeil
Honored Sweeper II
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
Champion Sweeper III
The built in report Printers:Printed pages breaks down the B/W and colored pages.