This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject

→ 🚀Are you a Lansweeper Champion?! Join our Contributor Program Sign up here!

Community FAQ

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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Forum Posts

Sign in/Join

Resolved! Duplicate Assests Displayed in Report

Good Day, I have created the query below to find all members of the Local Administrators group on all Scanned Windows Systems (excluding Domain admins).The issue with this report is that it duplicates all assests and renders the report useless.What a...

mrfite by • Engaged Sweeper
  • 4495 Views
  • 2 replies
  • 0 kudos

New Hardware detail report

I have the following report.Select Top 1000000 tblAssets.AssetID, tblAssets.AssetUnique, tblAssets.Domain, tblAssets.Processor, tblAssets.Memory, tblAssets.IPAddress, tblVideoController.Caption, tblNetworkAdapter.Name, tblIDEController.Captio...

MrPatrick by • Engaged Sweeper
  • 4866 Views
  • 1 replies
  • 0 kudos

Resolved! monitor report

Hello,I was wondering if there was a way to run the monitor report but add a column to show what resolution the monitor is.Dominic

Dtyner by • Engaged Sweeper II
  • 8363 Views
  • 5 replies
  • 0 kudos

Resolved! Unexpected results with added criteria

I’m seeing an unexpected behavior in a report. When I add an additional criterion, instead of dropping 1 record like I expect, it drops almost all of them. The report is to show old systems to be replaced, and I want to drop out those I’ve tagged as ...

Jeff_Henze by • Engaged Sweeper III
  • 4849 Views
  • 1 replies
  • 0 kudos

I need a Report

Hi, I need a report.All devices which have entered "FD102" in Custom1 or are in the OU "102".The devices in Custom1 are created manually. The Pcs in the OU are automatically there, I need for the inventory a query to display all devices which are eit...

Resolved! report with links to others pages

Hello,I would like to know how I can create a report with links to other pages of Lansweeper.For example I have created a report with a column reporting computer names; I would like that those computer names be linked to the page showing the detail o...

nicoven by • Engaged Sweeper
  • 14494 Views
  • 6 replies
  • 0 kudos

Various Helpdesk Reports

I am really hoping someone can assist me. My SQL skills are shocking. I need to create the following reports, but have no clue how to do it. FOR THE ENTIRE HELPDESK 1. Average Closure Times for a user defined period for the following:• ...

mariskak by • Engaged Sweeper
  • 3773 Views
  • 1 replies
  • 1 kudos