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

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
  • 4962 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
  • 2558 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
  • 1240 Views
  • 0 replies
  • 2 kudos

Firefox 91 Report

Firefox 91 (and ESR 78.13) are live. Windows Single-Sign-On has been added which will is a huge plus along with an enhanced cookie clearing feature. You can audit the update progress with the new Firefox 91 report.

Esben_D by Lansweeper Employee
  • 2045 Views
  • 0 replies
  • 0 kudos

Two AssetName colums clickable

Hello,I'm new to Lansweeper and I have basic knowledge of SQL.We are using Lansweeper to track corporate smartphones and SIM cards. We created the Smartphone and SIM card categories and registered a smartphone and a sim card to test, then created rel...

kschmeling by Engaged Sweeper II
  • 3384 Views
  • 2 replies
  • 0 kudos

Computer without Microsoft 365 Installed

I tried a program from another post for software not installed on a computer, and it's not working. I want a list of all computers without Microsoft 365 installed. Help please!Select Top 1000000 tsysOS.Image As icon,tblAssets.AssetID,tblAssets.Asse...

tjkalb by Engaged Sweeper II
  • 2561 Views
  • 2 replies
  • 0 kudos

Software per AD group

i am trying to create a report to show the software per AD Group name. I have create the below but it doesn't seem to work. I might miss something. Any help is appreciated. Select Top 900000000 tblSoftwareUni.softwareName, tblSoftware.softwareVersio...

Cpappas by Engaged Sweeper
  • 6640 Views
  • 8 replies
  • 0 kudos