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: 

Topics in this forum

Asset field to identify computer type

My apologies if this is a common question - my searches have brought up a lot of results, but none of them match what I need. I am new to Lansweeper, but experienced in SQL.In our environment, we use desktops, laptops and thin clients of both, and w...

bwaddell by Engaged Sweeper
  • 9950 Views
  • 2 replies
  • 0 kudos

Resolved! Report of last seen computers

HiI am trying to get a list of all of the computers in the Lansweeper database and determine the last time that they were scanned. I am running this report:Select Top 1000000 tblAssetCustom.Custom1 As FullName, tblAssets.AssetID, tblAssets.AssetUni...

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

Resolved! Asset Specific Location Listed Report

Hi there,I'm trying to organise a report listing assets which have been given a specific location of "Inventory" but not having much luck.Anyone know how this can be achieved?

Drexilla by Engaged Sweeper II
  • 4298 Views
  • 1 replies
  • 0 kudos

Resolved! Empty AD Groups

I know I can query for a list of users in an Active Directory group but can I get a list of groups in Active Directory that have no users?

JoshM by Engaged Sweeper
  • 8759 Views
  • 4 replies
  • 0 kudos

Resolved! Report listing Ticket field values

If I have a basic ticket that has a Username field, a date field and two custom fields (Department, Test Score), is there a report that will list those fields?Report:Ticket ID, Ticket Subject, Username, Date, Department, Test Score

harringg by Champion Sweeper
  • 7012 Views
  • 3 replies
  • 0 kudos

Resolved! Requesting help on an attachment report...

What I am trying to do is create a report that shows all tickets that have attachments added to the ticket.The ability to differentiate between file types would be a plus but is not required.Can anyone help or guide me on this?Wayne

Wmorrill by Engaged Sweeper II
  • 5646 Views
  • 2 replies
  • 1 kudos

Resolved! Report to list all pcs with Win10 specific build os versions

Hi, I'm trying to make a report to list all our computers running win10 and which can shows also the specific build os version. I've found some reports which list the version 10.0.10586, 10.0.14393 etc etc but i need to go deeper.I need that the repo...

riceanny by Engaged Sweeper
  • 3730 Views
  • 1 replies
  • 0 kudos