This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Community FAQ

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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Forum Posts

Sign in/Join

Calculate computer online time (needs SQL Server)

This report function can be executed only if the Lansweeper database is running on SQL Server.Before creating and/or running the report, connect to your database with SQL Server Management Studio under the sa account and execute the following SQL cod...

Daniel_B by • Lansweeper Alumni
  • 35552 Views
  • 10 replies
  • 3 kudos

Total Space & Free Space

HiI am looking to create a report to show the space servers have free and the total space. I have found a report that does what i want but shows the disk spaces in MB and i would prefer GB I was just wondering if there is a report that can show total...

IP4 not IP6

HII am having problems to create an asset list withAssetnameRAM in GBMemory in GBDisk in GBManufacturerModelOSnameIP4 Adresse which have now a ping respond ( switcht on)I can get IP Adresse but then I get also the IP 6 Adresse and in the moment I am ...

Last Windows Update

There is a chart report Last Windows Update Chart QueryAnd the SQL query is:Select Top 1000000 Case When LastPatchDate.lastPatchDate >= DateAdd(day, -7, GetDate()) Then '1. less than a week' When LastPatchDate.lastPatchDate < DateAdd(day, ...

paultech by • Engaged Sweeper
  • 3344 Views
  • 3 replies
  • 0 kudos

Resolved! Report showing multiple entries for same device

I am making a custom report that works but entries are duplicated multiple times. I have 78 printers and the report displays the printers IP location, Manufacturer, Model, SerialNumber, AssetName, Location (Custom Field 01), and the IPAddress.I have...

jatinder by • Engaged Sweeper
  • 3882 Views
  • 2 replies
  • 0 kudos

Need help with the "AD manager" field

I have an uptime report that I want to run on the regular, but the current user field is populated by the last logged on user, rather than the "AD manager" field in AD. I need to be able to pull the AD manager in order to get a clean enough report t...