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: 

Forum Posts

Sign in/Join

Software Installed and Last Patch Detected Report

Need to merge two reports and I'm having difficulty to combine both to one report. One is Software Inventory Report with 3 different software's, and the other is when last time Microsoft patch was installed. Both has asset name, and Username as com...

hlee by • Engaged Sweeper
  • 7282 Views
  • 1 replies
  • 0 kudos

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
  • 9813 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
  • 6331 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
  • 4178 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
  • 8524 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
  • 6842 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
  • 5487 Views
  • 2 replies
  • 1 kudos