→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
06-21-2024 05:48 PM
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!
Solved! Go to Solution.
07-03-2024 05:26 PM
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:
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.
08-13-2024 07:54 PM
Thank you!
07-03-2024 05:26 PM
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:
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.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now