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.

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

Resolved! Hyperlinks in Reports through Excel-Import

Aloha,i am "importing" reports directly into Excel over SQL-Import. However the hyperlinks of the assets are gone after i did the import. When i run the report directly in Lansweeper the hyperlinks are working.Is it possible to get the hyperlinks for...

Nukular by Engaged Sweeper
  • 5859 Views
  • 3 replies
  • 0 kudos

Resolved! Duplicate entires

Hi im having an issue with duplicate entries on tblSoftware. Essentially i want to show all the software installed on the various computers and who was the last user to log on. I have tried something similar to the link below but with no success. Any...

chrisjones by Engaged Sweeper II
  • 3299 Views
  • 1 replies
  • 0 kudos

Resolved! Computer model summary with Custom Field

I use the custom20 field to hold the planned retirement year of of our computers. I'd like to be able to run the "Computer model summary" report and have the Custom20 (Retirement year) show. I think because this is consoldated report it doesn't wan...

murpmic by Engaged Sweeper III
  • 4446 Views
  • 1 replies
  • 1 kudos

Resolved! Report showing Windows assets missing Java

I am trying to create a report that will have all the assets that do not have Java installed on them. I have this report that shows all of them that are not at the current version:Select Top 1000000 tblAssets.AssetID, tblAssets.AssetUnique, tblSof...

sullivane by Champion Sweeper III
  • 4081 Views
  • 2 replies
  • 0 kudos

Resolved! Report Hostname + Last User

I am trying to create a report to generate Computer names and last logged in user.My final goal would be to match last user to AD property "MangedBy", but I don't if that's possible. If it is the I would like to flat it if there is a difference. Can ...

ogeccut by Engaged Sweeper II
  • 5965 Views
  • 1 replies
  • 0 kudos

Resolved! Assets with Relational mapping report

Hello,I'm a SQL novice and I need help generating a custom report that has the following fields for Windows/PC Systems:System/PC NameIP LocationPC TypePC ManufacturerPC ModelPC Serial Number# of monitor(s) connectedMonitor Manufacturer(s)Monitor Mode...

MCXCCR by Engaged Sweeper
  • 4492 Views
  • 2 replies
  • 1 kudos

Resolved! scan for service present

is there a way to scan for a specific service on a windows workstation? specifically I am looking for a dameware serviceC:\Windows\dwrcs\DWRCS.EXE -servicedwmrcsDameWare Mini Remote Controlany help is appreciated