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

Locally Connected Devices

Hello,I'm looking for a report that could generate information about devices connected to each computer in our domain. I've recently found a SQL query on these forums which allowed me to pull accurate information on USB/Local printers installed on ea...

tbeau1 by • Engaged Sweeper II
  • 10822 Views
  • 5 replies
  • 1 kudos

CPU / Core report All Physicals (maybe virtuals)

Hey All;I poked around some of the canned reports and also searched here, but havent found a report that will give me the CPU / Core count on all physicals being HyperV, Windows , Linux, VMware etc...Some of the report I tried to create dont work rig...

aragones by • Engaged Sweeper II
  • 9573 Views
  • 2 replies
  • 0 kudos

Resolved! Mass Inventory Report

Hello,I would like to create a report which has the following field if possible:DomainManufacturer REPLACE (CS.Manufacturer0, 'System manufacturer', 'Assembled') AS Manufacturer0, REPLACE (CS.Model0 , 'System Product Name' , 'Assembled')AS Model0, ...

adeleon31 by • Engaged Sweeper
  • 5538 Views
  • 1 replies
  • 0 kudos

Resolved! Requesting assistance modifying built in report

Hello, I am attempting to modify a built in report (then save as a new report) Computer: Mac Address listI am having difficulties narrowing the report down to list just systems whose names begin with BRSP.I am sure it is something simple... but for t...

Chris1 by • Engaged Sweeper III
  • 4081 Views
  • 1 replies
  • 0 kudos

Resolved! Unexpected results on where statement

I'm a bit baffled by the fact that even though I specifically say I do not want to see records with a tblAssetCustom.Custom2 field like %retired%, I still get items with "Retired" in that field. Here's the report:Select Top 1000000 tblAssets.AssetID,...

Jeff_Henze by • Engaged Sweeper III
  • 8370 Views
  • 3 replies
  • 0 kudos

Resolved! Scan for admin account

Hello there I would like to know how I can scan the Computers, to see if the users got admin rights. Is that possible with Lansweeper? Thank you for your answers.Best RegardsRoot

Root by • Engaged Sweeper
  • 11566 Views
  • 4 replies
  • 0 kudos

Devices inventory per manufacturer

Hi, My requirement is pretty straight-forward but I am having a hard time creating the conditions in Edit Report for this output. I have a network that has Cisco Routers and Switches and Switches from different vendors like Juniper, D-link, Cisco and...

ksantosh by • Engaged Sweeper
  • 4977 Views
  • 1 replies
  • 0 kudos

Resolved! What query is run for the "All Macintosh assets" report

HiI would like to know what query is run for this default view?Under Assets -> Asset Types -> All Macintosh assetsI would like to customize the report but can't seem to come right with the base to start from.Once i have the query that is run I will b...