We’re currently experiencing a high volume of support requests, which may result in longer response times — thank you for your patience and understanding.

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: 

Topics in this forum

Resolved! Query to sort if computers are up-to-date

Hi everyone, I'm pretty new in the query world of lansweeper, i wanted to make a query to show all the computers of the network and see if their windows updates are installed. I assume to make that lansweeper had to have a table with all the latest u...

nilskate by Engaged Sweeper
  • 3312 Views
  • 3 replies
  • 0 kudos

Resolved! Why tblMonitor is bound to assets of type -1 and not 208

I wonder why the foreign key AssetId of tblMonitor is bound to the WindowsPC and not to the Asset of type monitor.I need to retrieve those columns, but due the relation of the record I obtain a lot of duplicated rowsTry before and after un-commenting...

SandroR by Engaged Sweeper II
  • 8925 Views
  • 9 replies
  • 1 kudos

AD Enable/Disable Within Last Day

Good Afternoon All!I'm trying to set up a report to determine what accounts have been changed between enabled/disabled within the past day so I can create a regular email notification for auditing and tracking purposes.  I see that Lansweeper can det...

DevAku by Engaged Sweeper
  • 1161 Views
  • 2 replies
  • 0 kudos

New Warranty report which includes Device Location

Hi,I am trying to create a report that shows assets that are out of warranty by a set time.  I have modified a previous report that I found to include the Asset Location The Asset location is set here for each asset Sometimes there is an asset which ...

Report.jpg location.jpg Location Missing.jpg

Resolved! Report Local Account + AD Group member

Hello, I've been assigned to make reports on our different assets and to make sure they don't have local accounts, but I got an issue while doing so is that there was groups inside the assets and therefore i need to make a recursive query to do so. I...

Nearuppp by Engaged Sweeper
  • 2675 Views
  • 2 replies
  • 0 kudos