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

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
  • 6824 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
  • 4537 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
  • 9612 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
  • 7402 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
  • 5971 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
  • 3979 Views
  • 1 replies
  • 0 kudos

Last seen report for all devices

HiI am trying to create a report that gives me the lastseen time of all the scanned devices in the Lansweeper databaseWhen i run the following report it only gives me the windows devices:Select Top 1000000 tblAssetCustom.Custom1 As FullName, tblAsse...

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

Scan attempts logged by scan logging

The report below lists scan attempts logged by scan logging. Information on enabling scan logging can be found in this knowledge base article. Keep in mind that scan logging is disabled by default.Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As ...

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