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

→ 🚀What's New? Explore Lansweeper's Fall 2024 Updates! Fall Launch Blog !

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

Organizational Unit Report

Hi,Currently I'm trying to create an Organizational Unit report that list all assets in found in Active Directory by LANSweeper. I have the report created already; however, I keep receiving duplicate entries from assets in the report. Is there as dat...

mhaygood by • Engaged Sweeper
  • 3162 Views
  • 2 replies
  • 0 kudos

Enabled User Only

I have filters in some reports but doesn't seem to work.I don't need to know if a user has not logged in for thirty days if his account is not enabled. tblADusers.IsEnabled = 'True'

Percentage Between Two Values

Hi Guy's I have a report as per below.Its a battery life report etc. I am wanting to calculate the battery life, for example 44004 is the Design Capacity, Warranty terms are 25% of the batter per year etc, I was wanting to see if there is a way to c...

AD computers where security group membership != 1

Hello!We have several AD groups, of which all Windows machines on the domain should be a member of one of them. Ideally, I'd like a report that lists all Windows machines that are in a number of those groups not equal to 1.Let's say that the group na...

dhoward by • Engaged Sweeper III
  • 3009 Views
  • 2 replies
  • 0 kudos

Resolved! Report for KB Articles

There is a solved question for creating a report for finding a specific Windows Update but it is for the older version of Lansweeper. SELECT TOP 100 PERCENT dbo.tblComputers.Computername, dbo.tblComputers.Domain, dbo.tblOperatingsystem.Descriptio...

abustraan by • Engaged Sweeper III
  • 8948 Views
  • 5 replies
  • 1 kudos

Software and all hardware report

Has anyone created a report to get all the software and Hardware (including pc and monitor)? I have been looking and have not had any luck. I would like it to list the PC name, username, IP, monitors attached, printer if attached and all software i...

dmerkel by • Engaged Sweeper
  • 4870 Views
  • 5 replies
  • 0 kudos