Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

Showing results for 
Show  only  | Search instead for 
Did you mean: 

Forum Posts

Resolved! Page Count report split by Color and B&W?

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...

Tickets Created and Closed per month on one report

Hi All,I am trying to get a report that shows created and closed tickets on the same report or SQL query.I have attempted to use a combination of the pre-loaded reports for Created and closed but am unable to get the details on the same report. Is th...

dan-jones by Engaged Sweeper
  • 1 replies
  • 0 kudos

USB printers with toner levels

Hi there,I was wondering if there was a report that can be made that can pull all of the USB printers that are connected to computers (I have some code below that I pulled from a different thread)but also have a column for toner. Is this possible?Sel...

ajokerst by Engaged Sweeper II
  • 3 replies
  • 0 kudos

Showing all assets without a department

I tried creating a report to show all assets which have no department showing. It is not happening to all assets, but some assets are showing multiple times. Where did I go wrong in making the report? All fields show the same information.Select To...

JTempleton by Engaged Sweeper III
  • 1 replies
  • 0 kudos

Count by Department

I am trying to get a count of our assets by department. I have created this report, but it only counts up to 554. When I look at our configuration/License page, it says we have 1779 licensed assets. I am not sure what is wrong with the report. Th...

JTempleton by Engaged Sweeper III
  • 3 replies
  • 0 kudos

Adding computer type to Windows 10 report

We have a Windows 10 report that we would like to also show whether each asset is a desktop or a laptop. What do we need to add to the report to show these?Here is the Windows 10 report we have:Select Top 1000000 tblAssets.AssetID, tblAssets.AssetUn...

chenegh by Engaged Sweeper II
  • 3 replies
  • 1 kudos

Hardware Inventory

I decided to publish some of my reports.Problem: collect HW inventory.Solution: LS HW Inventory Report.Select Distinct Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblBaseBoard.Manufacturer As MBManufacturer, tblBaseBoard.Product, tblAsset...