tuner cartridge page printed report

[Fahd]

hi everyone,

i am a licences user of lansweeper network management,
i want to export report from the lansweeper that gives me the number of pages that the toner cartridge print from each printer on my network or connected to a PC?

any ideas?

best regards

[Esben_D · Accepted solution]

Printed pages is stored in the tblAssetsCustom and the toner levels are stored in tblCustDevPrinter. By creating a custom report and adding these tables you should get the information you want. We added an example report below.

Instructions for adding this report to your Lansweeper installation can be found here: https://www.lansweeper.com/Forum/yaf_postst9882_How-to-run-a-report.aspx#post38309
If you are interested in building or modifying reports, we do recommend:

• Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial: https://www.w3schools.com/sql/
  
• Making use of our database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here: https://www.lansweeper.com/Forum/yaf_postst9870_Lansweeper-database-dictionary.aspx#post38296

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblCustDevPrinter.Lastchanged,
  tblAssetCustom.Printedpages,
  tblCustDevPrinter.TonerColorName,
  tblCustDevPrinter.TonerRemaining
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblCustDevPrinter On tblAssets.AssetID = tblCustDevPrinter.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName,
  tblCustDevPrinter.TonerColorName