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

Report to show Eventcode 1096 but every Device only once

Hi, i try to build a report of the event-logs in last 7 days of id 1096.BUT i want every device to show up only once and not for every event.I use this Template:Event Log Cleared Audit - LansweeperCan you help me?Select Top 1000000 tblAssets.AssetID,...

TW by Engaged Sweeper
  • 0 replies
  • 0 kudos

Chart: Status of AD users

LS has a powerful chart. It is Bar-diagram. It can show more than 2 column data.I have developed SQL-query for AD Users. It have to be used with this type chart.You should use report's name with prefix "Chart:".Chart: Status of AD usersQuery: Select ...

Mister_Nobody_0-1709198428073.png Mister_Nobody_1-1709198531080.png Mister_Nobody_2-1709198708991.png

Server Utilization report

I need a report that will at least show CPU and RAM utilization...would like Disk Utilization as well (got GB used, but actual disk usage).  I've found the CPU and RAM reports below, but I'm not sure how to combine these in to 1 report, and then add ...

jmcelvoy by Engaged Sweeper II
  • 3 replies
  • 0 kudos

Workstations with No Biometric Hardware Report

I am trying to write a report that will identify all laptops that do not have biometric hardware installed. I was able to find a report that includes all computers with that hardware. Was wondering if this was possible to create?

zinger3031 by Engaged Sweeper II
  • 1 replies
  • 0 kudos

Resolved! All Assets with last logon user

Hey everyone,we are currently working on an integration for another system. For that, we need a report with a specific set of columns. I've built a report with the needed columns and the result is useless, since it returns around 1 million results Wh...

Moonbeam by Engaged Sweeper
  • 2 replies
  • 0 kudos

Resolved! Need Help with custom Sleeptime Report.

I need help with a report that shows sleeptime  for systems. Something like this: SELECT Name AS ‘Computer Name’, LastWakeTime, LastSleepTime, DATEDIFF(MINUTE, LastWakeTime, LastSleepTime) AS ‘Minutes Asleep’ FROM Computers WHERE LastSleepTime IS NOT...

PapaTuck by Engaged Sweeper III
  • 3 replies
  • 0 kudos