cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
DavidHooie
Engaged Sweeper

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!

1 ACCEPTED SOLUTION
francisswest
Champion Sweeper

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):

printer.png

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

View solution in original post

2 REPLIES 2
DavidHooie
Engaged Sweeper

Thank you!

francisswest
Champion Sweeper

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):

printer.png

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