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

Resolved! Trying to make a custom report that sorts assets by state

Having trouble with making custom reports for Lansweeper. I'm trying to learn but I am having trouble getting the configuration down and can't find one already made on forums. If anyone has a report that can sort assets by state I would greatly appre...

dpsomma by • Engaged Sweeper
  • 5596 Views
  • 3 replies
  • 1 kudos

Report - All Assets with Specfic Default Gateway

Im wanting a report that displays ALL assets that have a certain default gateway configured. Report below only returns back windows devices. Any advice?Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tblAssets.Username...

Report - assets

Hi,New to Lansweeper, we're using it for asset management.I've been asked to run a report to show assets added to Lansweeper at a given date? I can't find that on the report section and not sure how to make a new report.Any advice would be great.tha...

martintk by • Engaged Sweeper
  • 2816 Views
  • 1 replies
  • 0 kudos

Run Report on PCs from a list

I need to run a detailed report on couple of hundred PCs. I have the host names in an excel and text file. These PC's are on the Lansweeper database. How do I run a report against those PCs? I did not see any option to run report based on text file o...

smurad by • Engaged Sweeper
  • 3426 Views
  • 1 replies
  • 0 kudos

Last Patch Date

I'm trying to generate a report to show the last patch date of a server.Logging on to a server and looking at it by Powershell and WMI it looks correct.Windows PowerShellCopyright (C) 2014 Microsoft Corporation. All rights reserved.PS C:\Users> Get-H...

Dass by • Engaged Sweeper
  • 5865 Views
  • 2 replies
  • 0 kudos

Resolved! WinSAT scores and an average of that score

Here is my code so far, I have modified someone else's query to match what I need, I just need an average of the scores, how would I go about this pleaseSelect Top 1000000 tblAssets.AssetID, tblAssets.AssetUnique, tblAssets.IPAddress, Convert(Deci...

Tholmes by • Engaged Sweeper III
  • 6058 Views
  • 6 replies
  • 0 kudos