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.

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...

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
  • 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
  • 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
  • 2 replies
  • 1 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
  • 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
  • 3 replies
  • 2 kudos

Resolved! How to show Linux OS name or version in a report

I have Linux servers that show the correct OS when editing the asset (e.g. "Ubuntu 14.04.5 LTS") but I can't get that to show up in a report. I've tried both tsysOS and tblOperatingsystem and neither contain the info that shows up in the asset itself...

dsegel by Engaged Sweeper
  • 1 replies
  • 0 kudos