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

Query multiple fields for reports

So I'm not a big SQL guy but I'm trying to make my life a little more efficient if possible. I tried reading up a bit on SQL stuff first before coming here.So basically what I'm doing is adding printer cartridges manually into Lansweeper. Inside th...

Persistent old data on switch port

Hi - I'm seeing some old, incorrect data appearing in column Deviceassetname in a report. Is there a way to refresh that? Re-scanning the switch didn't clear it.For example, I had a VOiP phone connected to our core switch a few months ago. It has sin...

jkoelker by Engaged Sweeper II
  • 5632 Views
  • 4 replies
  • 1 kudos

Report on Assets in a Static Group

I do not speak SQL. I need some help with what should be a pretty simple report to create.I need to take the built in report "All licensed assets in Lansweeper" but filter it to a static asset group I created called Network Devices.NOTE: This static...

chogan201 by Engaged Sweeper III
  • 4598 Views
  • 2 replies
  • 0 kudos

Excel Macros

Anyone know of this? "Excel Macros Bypass Your Filters and Slip in Malware Payloads"https://blog.knowbe4.com/excel-macros-bypass-your-filters-and-slip-in-malware-payloads?utm_medium=email&_hsmi=88982560&_hsenc=p2ANqtz-_20ShP5yruHljLcxfFQSB_uwWhpOAT73...

pcook by Engaged Sweeper II
  • 2301 Views
  • 0 replies
  • 0 kudos

Resolved! local admin users of a specific device

Hi there,Is there a way to create a report that shows all the local admin accounts on one or all win 10 devices?I can get to it manually by clicking on a device name--> Config tab--> User info tab--> Users in GroupsThanksKirk

kdunnett by Engaged Sweeper II
  • 4813 Views
  • 2 replies
  • 1 kudos

NOT doesn't work as expected

I'm not an SQL expert. I have some reports that are working, but I'd like to exclude certain PC models from them. If I use "NOT LIKE 'modelname'", instead of showing me every PC that matches the rest of the report and isn't that model name, I get eve...

ABECU by Engaged Sweeper III
  • 4921 Views
  • 3 replies
  • 0 kudos

Resolved! Bitlocker Report not contain all computers

We have introduced Bitlocker in our enterprise and we would like to manage the computer inventory where Bitlocker is installed or not.I observed that a builtin report already exist to show BitLocker machines... But I dont known why this report not li...

Glenn_Gagne by Engaged Sweeper III
  • 11584 Views
  • 4 replies
  • 0 kudos