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? Join Us for the Fall Product Launch! Register Now !

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! Report of Service Packs instead of Version Numbers

I have this report:Select Top 1000000 tblAssets.AssetID, tblAssets.AssetUnique, tblSoftwareUni.softwareName As software, tblSoftware.softwareVersion As version, tsysOS.Image As iconFrom tblSoftware Inner Join tblAssets On tblSoftware.AssetID = t...

abustraan by • Engaged Sweeper III
  • 6542 Views
  • 3 replies
  • 0 kudos

Reference Windows Hotfix list

This report will list all installed Windows hotfixes on a reference computer (i.e. lab computer) called "Reference" in the example below. Next to each hotfix a list of workstations will be displayed not having it installed.This report takes longer ti...

Daniel_B by • Lansweeper Alumni
  • 4363 Views
  • 0 replies
  • 0 kudos

Resolved! Report Help SQL with Cores

We have this report but I need to add IP Location how do I do that. Select Distinct Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tsysOS.OSname, tblSqlServers.displayVersion As Edition, tblSqlServers.skuName As License, ...

chads by • Lansweeper Alumni
  • 3594 Views
  • 1 replies
  • 0 kudos

Resolved! Request: System Protection On/Off

I would like to create a report to show me for PC's whether System Protection is on or off. I looked through the database dictionary and reports that were available on the forum, but couldn't find anything. Any help would be appreciated. Thanks.

syoulden by • Engaged Sweeper
  • 3575 Views
  • 1 replies
  • 0 kudos

Lansweeper database dictionary

Since Lansweeper version 5.2, Lansweeper has a built-in database dictionary which explains in great detail what each table and field stores. To access the database dictionary:Make sure you are running the latest Lansweeper release. Update instruction...

Susan_A by • Lansweeper Alumni
  • 45844 Views
  • 2 replies
  • 8 kudos

Users: AD users and their managers (Built-in)

Added in v.6.0.100The report below lists scanned domain users and their managers in Active Directory. AD manager scanning was added in Lansweeper 5.1. If you have an old Lansweeper installation, update to the latest release and rescan your users.Doma...

Susan_A by • Lansweeper Alumni
  • 13247 Views
  • 2 replies
  • 3 kudos

Resolved! Fixing SQL report to go back into Lansweeper

Hi Guys,I was working on a inventory report in Lansweeper, when I ran into issues with PCs that have multiple video cards, showing up as multiple line items on the report.So I handed the report over to our SQL guy, and this is what we got back (see b...

Resolved! Inventory summary report

I'm trying to create a summary report for hardware. I'm looking for the count by IP location for desktops, laptops and servers if possible. A server can be determined by Windows Server OS if needed. Something like:IP Location Desktop - # count Lap...

Carl527 by • Engaged Sweeper II
  • 5047 Views
  • 2 replies
  • 1 kudos