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: 

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! All Assets Report

We are implementing an Asset Management software and I have been asked to pull in a lot of information. Here is my query however I am returning the same machine literally thousands of times, is there a way to only list each machine only once?Select T...

mmeetze by Engaged Sweeper III
  • 5420 Views
  • 2 replies
  • 1 kudos

Switch Interface Mac Changes Report

We are looking for a report that will show AssetMacAddress changes on switch interface port in the past 24 hours. Similar to the builtin report Switch: Ports but only show Ports that have AssetMacAddress changed in the past 24 hours. Also show previ...

ponyisa by Engaged Sweeper II
  • 3469 Views
  • 1 replies
  • 0 kudos

list assets manually edited in last 30 days

I'm trying to find a field that would indicate the last time the asset record was manually edited. For instance, if you enter some data into Custom4 and save the record, is there a field that updates with the current date/timesamp at that time? Ideal...

Jeff_Henze by Engaged Sweeper III
  • 5453 Views
  • 3 replies
  • 0 kudos

Resolved! Report Laptops: Report shows duplicate entries

Hi,my report shows duplicate entries.I figured out that it is because some assets have more than 1 battery installed.How can I edit the report, so that only one entry for each asset is shown?Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName,...

MrCount by Engaged Sweeper III
  • 4201 Views
  • 1 replies
  • 0 kudos

Resolved! Add header to export reports

Hi folks,I am facing the problem, that we have several different reports which still need to be printed out.For that, we export to Excel and then print it.But as the exported report has no title on it, we sometimes swap the reports.So it would be nic...

MrCount by Engaged Sweeper III
  • 3854 Views
  • 1 replies
  • 0 kudos

Resolved! Existing Report Filtering Options

Hello,I'm looking for a description of what I can filter on at the top of an existing report. Let's say I open a report for an installed program with several versions. At the top of the report I can type a version number and the report filters down...

ngebhar2 by Engaged Sweeper II
  • 11318 Views
  • 3 replies
  • 3 kudos

Feature not installed report

Hi,Can anyone help? I'm working on a report with criteria:* Is server* Has folder shares* Feature 'FSRM Infrastructure' NOT installedI'm struggling on the feature not installed bit. I think I need something like the example here but I'm new to SQL an...

heybobby1 by Engaged Sweeper III
  • 3952 Views
  • 1 replies
  • 0 kudos