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: 

Forum Posts

Sign in/Join

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
  • 2515 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
  • 1216 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
  • 2008 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
  • 3326 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
  • 2518 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
  • 6504 Views
  • 8 replies
  • 0 kudos

Resolved! Report Merge

I would like to merge the following two reports. One will report the installed version of Office, while the other will show the value of a specific registry dword. The purpose is to show which workstations have Modern Authentication turned on (or off...

ccarlisle by • Engaged Sweeper
  • 2860 Views
  • 2 replies
  • 1 kudos