→ 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: 
Fahd
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Esben_D
Lansweeper Employee
Lansweeper Employee
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

View solution in original post

1 REPLY 1
Esben_D
Lansweeper Employee
Lansweeper Employee
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