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

Topics in this forum

Sign in/Join

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
  • 3167 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
  • 9235 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
  • 5112 Views
  • 5 replies
  • 0 kudos

Merging 2 reports

I'm still fairly new to SQL. Through lots of trial and error I was able to come up with the following 2 reports. I'm trying to merge them but am having difficulty. This is the Registry report I want to combine with a Software report: Select Top 1000...

Computer age report with categories.

Hi I need some help with my computer age report.I would like to based on the years old have a new Column called "Risk".So that if a computer is 0 years old = "Unknown age".So that if a computer is 0.001 to 4 years old = "Compliant Device" and row col...

Daniel_Red by • Engaged Sweeper II
  • 2681 Views
  • 1 replies
  • 0 kudos

VM Inventory - Hybrid environment

Dear Team,As is the case for everyone these days, we have a hybrid environment consisting of on-premise servers and servers which are hosted in Cloud providers such as AWS, Azure. etc. I know there is a report which can individually group the VMs but...

kchand by • Engaged Sweeper
  • 1281 Views
  • 0 replies
  • 2 kudos