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

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
  • 7738 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
  • 10631 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...

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
  • 4606 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
  • 9784 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
  • 7526 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
  • 6068 Views
  • 2 replies
  • 1 kudos