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

Resolved! Page Count report split by Color and B&W?

I've been asked to use Lansweeper to create a monthly report showing how many B&W prints and how many color prints are being done for each copier in our business.  Lansweeper shows page counts, but I don't see any way to differentiate between b&w and...

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
  • 7842 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
  • 4576 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
  • 3189 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
  • 7082 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
  • 9687 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
  • 4147 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...

Facilities by Engaged Sweeper III
  • 4650 Views
  • 1 replies
  • 0 kudos

Resolved! Software Report

HiI'm new to this and very impressed with the wealth of info available in Lansweeper. I wonder if anyone can help me create/run a report that will tell me all the software that is installed which asset(s) it's on and when it was last used? Grateful...

Tizdebz by Engaged Sweeper
  • 11827 Views
  • 7 replies
  • 0 kudos