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! Ignore Drive Letters in Low Disk Space Report

Running Version: am looking for the code to ignore multiple drive letters (like CDRom Drive, USB Drives, etc.) I really only want to see low disk space on Drive C:\Here is my current code:Select Top 1000000 tblAssets.AssetID, tblAssets.As...

SeelyeIT by Engaged Sweeper
  • 6 replies
  • 0 kudos

Limiting a Windows report to servers

To limit any Windows report to servers only (and not list workstations), do the following:Hit the pencil shaped edit button next to the report under Reports\View All Reports.Double-click on the tblComputersystem database table in the table list on th...

Susan_A by Lansweeper Alumni
  • 8 replies
  • 3 kudos

Helpdesk Report - Tickets by Users/Problem Users

Hi, I am sure this has been answered before but I cant find it.I need a report that shows and counts all helpdesk tickets regardless of status that have been raised against a user?Example:John Smith: Total of XX tickets raisedLIST OF ALL TICKETS JOHN...

plangham by Engaged Sweeper
  • 2 replies
  • 1 kudos

Adding IP locations to a report

To add your assets' IP locations to a report, do the following:Hit the pencil shaped edit button next to the report under Reports\View All Reports.In the search bar in the left-hand pane. Search for IPlocation.Double-click tsysIPLocations to add it t...

Susan_A by Lansweeper Alumni
  • 11 replies
  • 17 kudos

Add Filed

Hello all,I’m on Ver 7.1I have a wonderful report wich give me all I need for reporting but the filed to know if it’s a laptop or not,Select Top 1000000 tsysAssetTypes.AssetTypeIcon16 As icon, tblAssets.AssetID, tblAssets.AssetName, tblEncryptable...

Chart Report: Jabber

Hi,I would like a chart report counting the number (and %) of assets with Cisco Jabber installed and which have not.I have made this none-chart detailed version, which works fine:Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetT...

rawi05ab by Engaged Sweeper
  • 1 replies
  • 0 kudos

Office 365: Users (Built-in)

The report below gives back a list of Office 365 users.The report will only list users when the following criteria are met:You have Lansweeper 7.1 or higher.There is Office 365 user data scanned.Select Top 1000000 'user.png' As Icon, tblO365User.Dis...

Esben_D by Lansweeper Employee
  • 1 replies
  • 0 kudos

Resolved! List of computers without a monitor

Some of our monitors do not appear to be discoverable by WMI, even looking in device manager I just get Generic PnP Monitor.I have been trying to build a report of all Computers that do not have a Monitor as a child asset.I have found this report tha...

lcrowther by Engaged Sweeper
  • 3 replies
  • 0 kudos