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! 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
  • 9812 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
  • 1379 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
  • 3084 Views
  • 2 replies
  • 0 kudos

Resolved! Narrow down report results to asset group

Hello, I'm trying to narrow results of this report to particular static asset group, but no luck. All my tries with utilizing  tblAssetGroups shows errors like this: The multi-part identifier "tblAssetGroupLink.AssetGroupID" could not be bound... Hav...

PiotrL by Engaged Sweeper
  • 3293 Views
  • 5 replies
  • 0 kudos